|
Size: 499
Comment:
|
Size: 511
Comment: Disable line numbers
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| {{{#!highlight sh | {{{#!highlight sh numbers=off |
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.
