sqlite database optimization

[tinypoodle]

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)

Code: [Select]

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:~$


[coreplayer2]

nice, thankyou

 

[gwalther]

Tried this......found you also need.... sqlite3-bin.tcz ...installed.

[tinypoodle]

Correct, thank you very much for reporting! 

OP adapted accordingly.