Hello
The best way of making backups of anything is by copying the files completely and placing them on a different disk, or in a synced folder. A JSON export is less reliable for this purpose because it involves additional application code with potential for error. That is, a bug in the app can lead to such backups being incomplete or just not importable.
The backup by copying files
In terms of implementation, this can very easily be done on Linux systems via bash and cron. On Windows it’s also possible to write a backup script like https://stackoverflow.com/a/11280801/1456844 and automatically run it with the Task Scheduler like so Run a batch file with Windows task scheduler - Stack Overflow
The benefits of this approach are
- It isn’t affected by possible bugs in the app
- It is general-purpose, so you can use it to backup for all kinds of things, like other apps
- Restoring to an older database is just a matter of replacing files
Regarding the changing of the database location, please see Change storage location in sqlite base under windows - #2 by Andrei
Hope this is helpful.