Android Question Database question

NJDude

Expert

Licensed User

Longtime User

• Jul 8, 2016

• #2

If you added that field to the database then you will have to update the previous version on the device, it won't do it automatically.

 

Upvote 0

A

anaylor01

Well-Known Member

Licensed User

Longtime User

• Jul 8, 2016

• #3

So lets say that my app was finished and on the market. Lets say I had to make a change to the database. How would I update it? And how do I update the one on my phone now?

 

Upvote 0

NJDude

Expert

Licensed User

Longtime User

• Jul 8, 2016

• #4

In simple terms, after updating/installing the app, check the DB on the device (you can check the number of columns, version, etc) if it matches the latest version, you are done, otherwise, modify the DB adding/removing the necessary columns.

There are samples posted in the forums, do a little research.

 

Upvote 0

A

anaylor01

Well-Known Member

Licensed User

Longtime User

• Jul 8, 2016

• #5

So can I delete the existing and then use the new one? It seems like it would be a lot easier if every time you installed it would overwrite the existing database with the new one.

 

Upvote 0

NJDude

Expert

Licensed User

Longtime User

• Jul 8, 2016

• #6

Well, if the data is static then yes, the easiest way is to overwrite, but, if the user saves data to the database then it will be lost, it depends on your app.

 

Upvote 0

A

anaylor01

Well-Known Member

Licensed User

Longtime User

• Jul 9, 2016

• #7

Gotcha. Thanks for the help.

 

Upvote 0

Computersmith64

Well-Known Member

Licensed User

Longtime User

• Jul 9, 2016

• #8

FWIW, I actually build the database on the device on the first install of the app (I don't distribute the DB in the apk), then on every startup of the app I run a validation routine. That way if I make any structural changes to the DB (eg: add or drop a table, add a field to a table, etc...) the validation routine makes the required changes & brings the DB up to date without deleting any of the user's data.

- Colin.

 

Upvote 0