Project

General

Profile

SQLite

Cleanup of the database

  • You could use vacuum
    sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite "VACUUM;" 
    
  • You can dump the database and import it again. You have to stop quassel(core) for this:
mv ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.config/quassel-irc.org/quassel-storage.sqlite.bak
sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite