VACUUM the SQLite database to reclaim disk space and consolidate WAL
name db-vacuum description VACUUM the SQLite database to reclaim disk space and consolidate WAL user_invocable true Run VACUUM on the project's SQLite database to defragment and reclaim unused space. This is especially useful after schema migrations (ALTER TABLE) which can bloat the WAL file. Steps Show current DB and WAL file sizes Run VACUUM via sqlite3 Show file sizes after to confirm reclamation Commands
ls -lh data/rss.db*
sqlite3 data/rss.db "VACUUM;"
ls -lh data/rss.db*