I'm planning to create an App for iOS and Android that work with SQLite.
However when I release new features to the App it might need some changes to the SQLite DB that was released on the first version.
I asumme data modeler will help me in the way that if DB changes in tables and fields I can obtain scritps between versions right?
However I want to ask you If I release 4 versions of my App, and each of them contains files like: 2.txt, 3.txt and 4.txt, when my user upgrade his first release 1.0 from Appstore or playstore the initial SQLite database with version 1.0 will not be modified with the next versions?
- One user download the App version 1.0 containing SQLite DB version 1.0
- Next Month the same user upgrade the App trought PlayStore and the next release was the App version 2.0 containing SQLite version 2.0, does PlayStore will update only the APK only or it will replace the SQLite DB version 1.0 with the SQLite version 2.0?
If my user entered several records to his SQLite version 1.0 I do not want the PlayStore upgrade process replace his entire SQLite database with the new empty released on the version 2.0
Does any body know how to solve this incremental upgrades to an existing SQLite database without erase any data?