Just make sure that no processes are using the file, make a backup of it for safekeeping, and then:
sqlite3 *.db "VACUUM;"
Compare sizes and you’ll see how much you have done!
Very useful to optimize database tables in MyBB with SQLite, among many other purposes :-)