I've started with a simple script to compress Firefox's sqlite databases before creating a backup of my $HOME directory
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: