Android Question Database

Stefano Di Chiano · Jun 6, 2020

Hi, I was wondering one thing.
Let's say I put a db in the application folder, so I don't create it by code but I copy and paste one I already had.
When I upload the apk on the google store and someone download the app, will the db be downloaded as well?
I don't know if I'm explaining myself well or if it's a dumb doubt, but what I mean is: do I have to create the db when the app is run the first time or I can just put one in the Files folder (or whatever the right folder for dbs is)?

Sandman · Jun 6, 2020

Stefano Di Chiano said:
When I upload the apk on the google store and someone download the app, will the db be downloaded as well?

Yes.

EnriqueGonzalez · Jun 6, 2020

You can save it on the file dir assets folder and later copy it in the dirinternal (or wherever you like) once the user installed it.

Stefano Di Chiano · Jun 6, 2020

All right, thanks. Probably it was more obvious than I thought but I needed to be sure about it.

MicroDrie · Jun 6, 2020

Copy an existing Db file has a price: You have to think about overwriting an existing Db file, because in such case all user Db mutations are lost. Crate a Db file from the app can detect the existence an only add non-existing table(s) or upgrade an existing table(s) design.

Stefano Di Chiano · Jun 7, 2020

MicroDrie said:
Copy an existing Db file has a price: You have to think about overwriting an existing Db file, because in such case all user Db mutations are lost. Crate a Db file from the app can detect the existence an only add non-existing table(s) or upgrade an existing table(s) design.

I don't want to copy it, I just a need an already existing and filled one when the user download the app.

Mahares · Jun 7, 2020

Stefano Di Chiano said:
I don't want to copy it, I just a need an already existing and filled one when the user download the app

You must copy the database to File.DirInternal or if you use RunTImePermissions to the external. You cannot open or read a SQLite database when it is in FIle.DirAssets

Stefano Di Chiano · Jun 7, 2020

Mahares said:
You must copy the database to File.DirInternal or if you use RunTImePermissions to the external. You cannot open or read a SQLite database when it is in FIle.DirAssets

I didn't know that. How do I write the code in a way that it doesn't copy it every time the app is run?

klaus · Jun 7, 2020

Did you have a look at the B4X SQLite Database ?
All this is explained there.
And the whole B4X Booklets collection ?

Stefano Di Chiano · Jun 7, 2020

klaus said:
Did you have a look at the B4X SQLite Database ?

I didn't but I will, thanks for pointing that out.

Android Question Database

Stefano Di Chiano

Active Member

Sandman

Expert

EnriqueGonzalez

Well-Known Member

Stefano Di Chiano

Active Member

MicroDrie

Well-Known Member

Stefano Di Chiano

Active Member

Mahares

Expert

Stefano Di Chiano

Active Member

klaus

Expert

Stefano Di Chiano

Active Member

Similar Threads

Android Question Database

Active Member

Expert

Well-Known Member

Active Member

Well-Known Member

Active Member

Expert

Active Member

Expert

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency