Database Maintenance

📄️ Integrity Check

Verify SQLite database structural health with PRAGMA integrity_check and quick_check.

Rebuild and compact SQLite database files with VACUUM to reclaim space and optimize file layout.

Improve SQLite query planning by collecting table and index statistics with ANALYZE.

Export full SQLite schema and data as SQL text with .dump, then recreate databases from that script.

Create reliable SQLite backups using online and offline methods, then verify backup validity before you need recovery.

Restore SQLite databases from backups safely and verify restored content before resuming application writes.