Using snapshots for SQLite backups?

Questions / Help
,
1

For now, I want to save money and not use PostgreSQL.

So, I want a single volume with SQLite inside and its multiple backups in different regions. Backups need to be as secure as the app itself is.

First, I don’t see “restore” or similar command at fly volumes snapshots · Fly Docs - docs bug?

Second, can I make a snapshot in one region and restore it in another one?

Does snapshot size count towards volume used space (decreasing the free space on the volume)?

What could you advice to automate backups, better than running from Cron on my PC?

2

hey, for sqlite, I’d recommend running something like litestream: https://litestream.io/

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.