Preserving Sqlite Database File During Updates

[EricTurnerDev]

I am developing a Nextron app that stores data in a SQLite database file. When a user installs an updated version of my app, the database file is deleted and a new one is created, so any previous data in the database is lost. I would like to prevent that file from being deleted during an upgrade.

Right now in main/background.ts I create the database file in the current directory (e.g. ./mydatabase.db) on startup if the file doesn't already exist.

I think there are two options here:

1. Create the database file somewhere else on the user's system. Where should this be on each platform? Should I let the user choose the location during installation, and if so, how do I do that in Nextron?
2. Prevent the Electron installer from deleting the database file. I found this pull request in the electron-builder that adds a customRemoveFiles property to the electron uninstaller, but I'm unsure how to use it, or even if it could be used in a Nextron app.

Any suggestions? Thanks!