Script to vacuum all sqlite database on my system

vacuum-maintenance.sh

#!/bin/bash

set -eu

echo "Scanning for sqlite databases..."
find \
  ~/Library\
  ~/Pictures/\
  -type f '(' -iname '*.sqlite' -o -iname '*.db' ')' \
  -print0 | while read -r -d $'\0' filename; do
  filetype=$(file "${filename}")
  if [[ "${filetype}" =~ 'SQLite 3' ]]; then
    oldsize=$(stat -c %s "${filename}")
    nice sqlite3 "${filename}" vacuum
    newsize=$(stat -c %s "${filename}")
    if [[ $oldsize -ne $newsize ]]; then
      change=$(( 100 - (100 * $newsize) / $oldsize ))
      echo "${filename}: ${change}% "
    fi
  fi
done

# EOF

I don’t use Thunderbird nor do I use this script anymore.

The echo is what prints the file name and percent change.