A Bolt.cm Git pre-commit hook to clear the `bolt_log` upon commit. I use Git for deployment purposes and so storing the database in Git makes this a little easier.

pre-commit

#!/bin/bash -e

# Clear up the log of any database added to the index before committing it.
git diff-index --name-only --cached HEAD \
| grep -e "database/.*\.db" \
| while read DB; do
	echo "Truncating log table in database: $DB"
	sqlite3 "$DB" "DELETE FROM bolt_log; VACUUM;"
	git add "$DB"
done