Updating an external assets writable db in flutter app

I have a flutter app with an external db that i copy from the assets folder when the app is launched for the first time and it has 3 columns - s.no., description, shown. The column "shown" can be updated when a description is shown to the user. In a future app upgrade, if i want to update the db or add more descriptions to it, how can it be done while making sure that the written data is also persisted? I can do the version controling via shared preferences to check if that db was updated but if i copy the entire db again, it will overwrite the values in the "shown" column.

Read more here: https://stackoverflow.com/questions/67375591/updating-an-external-assets-writable-db-in-flutter-app

Content Attribution

This content was originally published by Priyanshu Goyal at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: