Litestream
Litestream is a disaster recovery tool running in the background for SQLite databases. It copies database changes incrementally to another file or to remote storage areas such as S3. SQLite maintains database integrity by communicating via API and uses a temporary lock table within the database for equalization coordination.
benbjohnson · Backup & Recovery
Common commercial products in this category: Veeam, Acronis, Backblaze
- You copy changes to your SQLite database incrementally to S3 or a different file.
- With the background process running on the database, you automate data backup operations.
- SQLite This tool, which works compatible with API, eliminates the risk of database files being corrupted.
- • NeutralHacker News
Why I Built Litestream
“I've wanted to move a small, Postgres-backed web app (written in Go) to SQLite, but one of the hurdles is that we deploy to Heroku (which famously has an ephemeral filesystem). Since the web app runs on a single, always-on dyno, seems like it may work to use Litestream to (1)…”
- • NeutralHacker News
Litestream: Revamped
“Very cool! This is so clever and makes deploying it so simple. I just wasn't able to use it yet because we'd have (many) thousands of SQLite DBs to backup. I quickly hacked something together using fanotify + SQLite's Backup API to have some copies at least, but I'm going to try…”
My note
Alternative pages
More in: Backup & Recovery
- Duplicati★ 15,174 · today
- Kopia★ 14,537 · today
- BorgBackup★ 13,897 · yesterday
- databasus★ 9,217 · 6 days ago
- elasticsearch-dump★ 7,944 · yesterday
- ludusavi★ 6,507 · 13 days ago