SQLite backup articles.
Practical guides for running SQLite in production, testing restores, and avoiding untested backup optimism.
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.
How to Test Your SQLite Backups
A restore-first checklist for verifying SQLite backups before an outage forces the issue.
Litestream vs Borela
Litestream is excellent SQLite replication. Borela is the managed verification layer around backup freshness, restore drills, and alerts.
SQLite Disaster Recovery Checklist
A practical checklist for small SaaS apps, internal tools, and self-hosted apps running SQLite in production.
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.
What 'Recovery Window' Means When Your Database Is Idle
How point-in-time restore works for low-traffic SQLite apps, why an idle database has a narrow visible window, and how to choose the right timestamp.