How to update SQLite DB on iPhone app update?

You should store the current version number of the app somewhere persistent -- in the database or better yet in the Defaults database. On startup, your app will compare it's own version number with the persisted version number. If they differ, then this is the first run after an update.

If the persisted version number isn't there, then obviously also this is the first run after an update.

We check for updates by querying the server for a hash value in the header of a plist that is spit out via a php file that queries the server database. You can store that hash locally and compare it to the last time the app ran. That way the phone knows if its version is out of date.

Then we download the new plist in the background and update the database on the phone.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.