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