Compacting SQLite databases

On occasion SQLite databases need to be compacted. Data contained within a database may be much smaller than the file's actual disk usage (this can occur in certain situations where many rows are deleted). To compact all SQLite databases in your home directory:

find ~ -name '*.sqlite' -exec sqlite3 '{}' 'VACUUM;' \;

Many applications are now using SQLite for storing data, such as Amarok, Firefox, etc.

Other stuff

   1 # Dump to stdout, w/out headers.
   2 sqlite3 -noheader test.db 'select * from users'

CategoryCheatSheet