My app is in production and I want to manage user data when user updates the app without loss of their data, how can I achieve this with sqflite
. Explicitly I want to add a column and delete another.
You can probably add a column using raw sql, but sqlite (and thus sqflite) doesn't support dropping a column. For that you would need to do the following:
onUpgrade
copy the old database columns to a temporary tableSorry, this isn't a full answer, but it is the direction I would go if I were in your situation.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With