I've started with a simple script to compress Firefox's sqlite databases before creating a backup of my $HOME directory
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | alex@xubuntu:~$ cat bin /vacuumFirefox .sh #!/bin/bash [ -n "$(pidof firefox)" ] && { echo "ERROR: firefox is still running, close it first!" exit 1 } counterBefore=0 counterAfter=0 for i in ~/.mozilla /firefox/ */*.sqlite; do fileSizeBefore=$( du -b $i| awk '{ print $1 }' ) counterBefore=$((counterBefore + fileSizeBefore)) sqlite3 "$i" vacuum fileSizeAfter=$( du -b $i| awk '{ print $1 }' ) counterAfter=$((counterAfter + fileSizeAfter)) echo "$fileSizeBefore $fileSizeAfter - $(basename $i)" done echo "Bytes saved: $(( counterBefore - counterAfter ))" |
Here is a sample output: