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.
corruption - DevProfit
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.