Android Question Create a db or "insert" it?

[LucaMs]

Doubt (posthumous):

it is better to create the db in the code or externally (and then copy it etc.).?

Since I'm tired of thinking, I leave to you the judge

 

[NJDude]

I personally create DBs using a DB Editor, it's easy and fast, add it to my assets and copy it to the device.

 

[LucaMs]

I started reading manuals and examples for java, where I found out how to create db by code; I did not know and had no tools (now I know them).
Then, when I discovered the fantastic B4A, I created everything from code.

Now I have some doubts. I would like to think about the situations of any changes to the DB structure and the distribution, but if anyone thought in my place, I would do my little brain work less .

Thank for your reply, NJDude

 

[NJDude]

There's no problem, if you use a DB editor and then your app requires a DB change you can manage that as well, it's just matter of checking the app version and creating an "update DB" routine, I think I've posted some examples, but you can just also search the forums for answers.

 

[LucaMs]

There are other things to consider (and then I will be forced to think ).

By creating the db from code, I use some "constants" for the names of the fields. This must be done even if the db was created externally.

For now, I leave everything as it is, then I'll try to develop a simple app using both methods.


Thanks again for your reply.