CODEWITHSUNDEEP
iphoneiosobjective-csqlite
1110
1110

Reputation: 6839

Best strategy for db update when updating application

I have function that initialize my database create tables etc.
Now I prepare version two of the application and in this function at the end I added check for column existence and if not exist I alter table.

My question is:
To avoid checking this all the time is it good to put in UserDefaults some flag that indicate that current app is version two and if it is to avoid this code?

This seams logical to me but other opinion is always welcome ;)

Upvotes: 0

Views: 310

Answers (2)

user1673099
user1673099

Reputation: 3299

Yes, you can user NSUSER Default to check this. I don't think anything wrong with this.

Upvotes: 1

Suhail Patel
Suhail Patel

Reputation: 13694

You could have a version number table/column in your database which stores the schema version number. Every time you change the schema, increment the number in your application file and then run the relevant migration code to get from one schema version to another whilst updating the schema version in the database.

This answer has a handy way of tracking db schema version numbers without creating a separate table in SQLite

Upvotes: 1

Related Questions