VACUUM INTO: The SQLite Backup Command Most People Skip
VACUUM INTO is the safest way to back up and compact a SQLite database while it is running. Here is how it works, when it fails, and why I use it over file copies.
database - DevProfit
Scheduled SQLite Backups With a systemd Timer: The 10-Minute Setup
A daily SQLite backup you never have to think about: a systemd timer running VACUUM INTO, plus retention and a restore-test hook. Real config included.
When Your SQLite Data Outgrows a File: The Managed Postgres Middle Ground
The honest path between 'keep it in SQLite' and 'run your own Postgres': move the part that needs it to a managed database and keep the rest in the file.
PRAGMA integrity_check: What It Catches and What It Completely Misses
I corrupted SQLite databases on purpose and integrity_check passed on one that was actually broken. Here is the verified boundary of what this check can and cannot see.
Indexes in SQLite: What Actually Makes Your Queries Fast
A practical look at SQLite indexes: when they help, when they hurt, and how to find the queries that actually need one.
Exporting SQLite Data: JSON and CSV Without Losing Your Mind
The clean ways to get data out of SQLite — JSON via sqlite3 CLI, CSV with proper headers, and the escaping traps that corrupt exports.
SQLite Durability Settings: WAL, synchronous, and When to Use FULL
The tradeoff between speed and durability in SQLite: what WAL and synchronous=NORMAL actually mean, and when FULL is the right call.
SQLite vs MySQL: When a File Beats a Server
A calm comparison between SQLite and MySQL from someone who runs both: when the zero-ops file wins, when you need a database server, and the honest middle.
The Checklist I Run Before Touching a Production Database
Every database incident I have caused traces back to skipping one of these steps. Stop, back up, work on a copy, verify, swap — the ritual that prevents disasters.
How to Recover a Corrupted SQLite Database: A Real-World Walkthrough
A verified, step-by-step recovery of a corrupted SQLite database using VACUUM INTO, integrity_check, and backups — including what SQLite's integrity check can and cannot catch.