I am the author of direct-sqlite, which is the layer underneath sqlite-simple. I think it would be very little work to add support for SQLite3's online-backup API to both these projects. Then, as long as we store everything in the database (except for configuration, which properly belongs outside it for ops reasons), we can easily create self-contained backups of everything.
What is our backup strategy?
I am the author of direct-sqlite, which is the layer underneath sqlite-simple. I think it would be very little work to add support for SQLite3's online-backup API to both these projects. Then, as long as we store everything in the database (except for configuration, which properly belongs outside it for ops reasons), we can easily create self-contained backups of everything.