💬
Get Help
VJ
Vishal Joshi

SQFLite new DB Changes require app uninstall and reinstall

Database & APIs

I have a live app published on the App Store that has a SQLite db integrated now some user have stored their data in a table called "Logs" but now I want to publish a new app that will have two more columns "Notes", "Option" in same "Logs" table. Now I want to keep the users old data and add new data as well in the same table after updating the app but during testing with TestFlight I am not able to add the logs, Kindly provide support

Case 1:
- App installed with TestFlight with old DB schema and have added the logs data
- Installed a new app from TestFlight on top of it with the new DB schema
- The app is working fine adding new logs and keeping the old data as well

Case 2:
- App installed from Apple App Store with old DB schema and have added the logs data
- Installed a new app from TestFlight on top of it with the new DB schema
- The app is now not working, not able to add previous types of logs as well as new types of logs having new columns data


What have you tried so far?

Tried Solutions:
- Uploaded new DB file with a different version name like "MyDBV1" having new DB schema.
- Add on upgrade method, version number with ALTER table queries in code and push the TestFlight build through GitHub
- Created a custom action to call in 'main.dart' and use it to migrate new schema to add the new type logs as well as the old ones

Did you check FlutterFlow's Documentation for this topic?
Yes
1