Dependencies:
sqlite3-bin.tcz
file.tcz
Sample output:
(Note: Output from a system where sqlite databases had already been optimized earlier, hence no difference in numbers. General expectation would be sizes after processing potentially to be much smaller than before)
tc@box:~$ sqltidy01.sh
sqltidy.sh - script to vacuum and reindex sqlite databases
(C) 2013 tinypoodle, distributed under the GPLv2, NO WARRANTY
version 0.1 BETA
Searching for existing sqlite databases in rootfs...
128.0K /home/tc/.config/hv3
4.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/formhistory.sqlite
12.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/signons.sqlite
4.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/cookies.sqlite
140.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/places.sqlite
4.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/permissions.sqlite
4.0K /home/tc/.mozilla/firefox/7tmsczzw.default/search.sqlite
Vacuuming and reindexing...
New size:
128.0K /home/tc/.config/hv3
4.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/formhistory.sqlite
12.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/signons.sqlite
4.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/cookies.sqlite
140.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/places.sqlite
4.0K /home/tc/.mozilla/seamonkey/1ha2ntq3.default/permissions.sqlite
4.0K /home/tc/.mozilla/firefox/7tmsczzw.default/search.sqlite
All done!
tc@box:~$