> Backing up the sqlite files was a pain, as it required the application to be halted to get a consisten state of the db files In case you haven't considered it yet, SQLite has [online backup API](https://sqlite.org/backup.html) which makes it possible to back-up the database in small portions, interleaved with other database access, without interrupting the main application.