← Graph

How do you handle backups with SQLite?

question 3 connections

Audience question about backup strategy. Answer: two layers. (1) Litestream continuously replicates every change (once per second) to Cloudflare R2, giving an essentially live copy and point-in-time recovery within the last 48 hours — also used to replicate production/staging into the dev environment with one command. (2) A cron-scheduled daily script runs SQLite's built-in `sqlite3 backup` command and uploads the resulting backup-format file to S3/R2 as a separate full dump.

answer_summary
Litestream streams WAL changes to Cloudflare R2 every second (48h PITR, easy dev replication) plus a daily cron running sqlite3 backup to S3.
question How do you handle backups with SQLite?
about
Litestream tool
Primary backup mechanism discussed.
question How do you handle backups with SQLite?
about
Storage destination for the backups.
question How do you handle backups with SQLite?
asked_at
Audience Q&A.

Provenance

Read by
1 extraction