Database Backup

[kellpossible]

Use SQLITE online backup

Perhaps using one of the following services to sync/store backups:

• https://github.com/benbjohnson/litestream
• https://github.com/minio/minio
• https://github.com/prasmussen/gdrive
• https://www.rsync.net/resources/howto/snapshots.html
  • https://rclone.org/

I think we'll probably go with something similar to https://litestream.io/alternatives/cron/ perhaps using the VACUUM INTO command and an S3 sdk upload along with something like https://deadmanssnitch.com/ to be notified if backups stop working.

[kellpossible]

I think I'd like to go with an S3 based approach as there are multiple open source implementations of that API. It seems best to do this with an API that is under a compile flag, so it doesn't affect debug builds which don't need it.

• https://github.com/paolobarbolini/rusty-s3 fast to compile
• https://github.com/awslabs/aws-sdk-rust/tree/726ec869eb7d263b158e4da77966e4ca9c68004a/sdk/s3 official API
• https://github.com/durch/rust-s3 async

[kellpossible]

Completed. Will implement restore later.