== 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:

{{{#!highlight sh numbers=off
find ~ -name '*.sqlite' -exec sqlite3 '{}' 'VACUUM;' \;
}}}

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

== Other stuff ==

{{{#!highlight sh
# Dump to stdout, w/out headers.
sqlite3 -noheader test.db 'select * from users'
}}}

----
CategoryCheatSheet