$ ls -lh places.sqlite
-rw------- 1 martin martin 1.2M Sep  8 07:24 places.sqlite

$ sqlite3 places.sqlite
SQLite version 3.7.13 2012-06-11 02:05:22
sqlite> .tables
moz_anno_attributes  moz_favicons         moz_items_annos
moz_annos            moz_historyvisits    moz_keywords
moz_bookmarks        moz_hosts            moz_places
moz_bookmarks_roots  moz_inputhistory

sqlite> .output dump.sqlite
sqlite> .dump

$ ls -lh
total 1.2M
-rw------- 1 martin martin  39K Sep  8 19:01 dump.sqlite
-rw------- 1 martin martin 1.2M Sep  8 07:24 places.sqlite

sqlite> vacuum;
Successful lookaside attempts:       3690
Lookaside failures due to size:      913
Lookaside failures due to OOM:       0

sqlite> vacuum full;
Successful lookaside attempts:       6509
Lookaside failures due to size:      1621
Lookaside failures due to OOM:       0

analyze;
select * from sqlite_stat1;