SQLite backup articles.
Practical guides for running SQLite in production, testing restores, and avoiding untested backup optimism.
Guide
How to Back Up SQLite in Production
A practical SQLite backup guide for production apps: WAL mode, continuous replication, off-server storage, restore drills, alerts, and retention.
Checklist
How to Test Your SQLite Backups
A restore-first checklist for verifying SQLite backups before an outage forces the issue.
Comparison
Litestream vs Borela
Litestream is excellent SQLite replication. Borela is the managed verification layer around backup freshness, restore drills, and alerts.
Checklist
SQLite Disaster Recovery Checklist
A practical checklist for small SaaS apps, internal tools, and self-hosted apps running SQLite in production.
Explainer
What PRAGMA integrity_check Does and Does Not Prove
SQLite integrity_check is useful, but it is one part of a restore drill, not a full disaster recovery plan.