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.
backup - 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.
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.
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.
SQLite in Production: 5 Mistakes That Corrupt Your Database
Five real mistakes that damage SQLite databases in production, learned the hard way — and the backup and integrity discipline that catches them before they become disasters.