This vaccum all database in the home directory

vaccum-maintenance.sh

#!/bin/bash

set -eu

echo "Scanning for sqlite databases..."
find \
  ~\
  
  -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