SQLite question

[Marquisk2]

I have a SQLite database in my application and when I make any updates to the database and test it on my iPhone the database does not get updated unless I delete the app completely off my iPhone. Is this normal? Will this cause an issue with future updates when people download them as well?

[timle8n1]

Originally Posted by Marquisk2

I have a SQLite database in my application and when I make any updates to the database and test it on my iPhone the database does not get updated unless I delete the app completely off my iPhone. Is this normal? Will this cause an issue with future updates when people download them as well?

I suspect you are using code that checks if the database is present in the documents directory and if not copies it over. As you have noticed after an upgrade this database is already there and so the code doesn't copy it over - if it did all the data added since the app was last installed would be lost.

If you need to handle this use case (changing the schema after an install) you should probably look at Core Data and migration. While complex it will be much easier to learn that versus trying to do all that in raw SQL.

[Marquisk2]

Thanks for the information. Maybe on my next project I'll work with Core Data but I figured to insert a version table/field where the app checks what version it has and updates if it needs to or not.

[thenerd]

Originally Posted by Marquisk2

Thanks for the information. Maybe on my next project I'll work with Core Data but I figured to insert a version table/field where the app checks what version it has and updates if it needs to or not.

Yesterday I wrote how to on my blog when you want to migrate data between versions... its not so hard as you think it is!

You can check it out at How to do a lightweight Core Data migration | the-nerd

Cheers,
Fre