Clean SQLite databases (using VACUUM command)

cleanSQLiteDB.sh

#!/usr/bin/env zsh

for i in **/*.(db|db3|apdb|alfdb|sqlite|sqlite3|dsidx|gcdata|xcindexdb)(.D); do
	if [[ -z "$(file $i | grep SQLite)" ]]; then
		continue
	fi;
	local -i initialSize="$(du "$i" | cut -f1)"
	sqlite3 "$i" "VACUUM;" 2> /dev/null
	[ $? -ne 0 ] && echo "\\033[31mProblem with: $i\\033[0m" && continue
	local -i newSize="$(du $i | cut -f1)"
	local -i gain="$((initialSize-newSize))"
	[ $gain -gt 0 ] && echo "\\033[32m$i: -$((initialSize-newSize)) KB" && continue
	[ $gain -eq 0 ] && echo "\\033[30m$i: $((initialSize-newSize)) KB" && continue
	[ $gain -lt 0 ] && echo "\\033[31m$i: +$((newSize-initialSize)) KB" && continue
	echo -ne "\\033[0m"
done