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

  7 min read

  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

  6 min read

  A restore-first checklist for verifying SQLite backups before an outage forces the issue.

• Comparison

  Litestream vs Borela

  5 min read

  Litestream is excellent SQLite replication. Borela is the managed verification layer around backup freshness, restore drills, and alerts.

• Checklist

  SQLite Disaster Recovery Checklist

  6 min read

  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

  5 min read

  SQLite integrity_check is useful, but it is one part of a restore drill, not a full disaster recovery plan.

• Concept

  What 'Recovery Window' Means When Your Database Is Idle

  5 min read

  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.