Most important is that that local SQLite gets proper backups, so a restore goes without issues

Gets proper backups if you back it up the right way https://sqlite.org/backup.html