Handling DB migrations for desktop app sqlite db
Hi all,
I'm working on an app rn where my plan is to store data in a sqlite db in the user's local data directory (.local/share/ or %LOCALAPPDATA%). I'm wondering if anyone had some guidance on how to handle db migrations in this scenario. I have a couple of ideas but just wanted to see if anyone had any other experience doing something like this.
My current plan is to pack the migrations along with my app with a date stamp in each, and apply them on startup if necessary. This would be checked by looking at another state file that has the most recent migration version.
I'm working on an app rn where my plan is to store data in a sqlite db in the user's local data directory (.local/share/ or %LOCALAPPDATA%). I'm wondering if anyone had some guidance on how to handle db migrations in this scenario. I have a couple of ideas but just wanted to see if anyone had any other experience doing something like this.
My current plan is to pack the migrations along with my app with a date stamp in each, and apply them on startup if necessary. This would be checked by looking at another state file that has the most recent migration version.
