* The one that purges your Quassel Sqlite Database
What it does
This script comes from a first draft by Enrico '[Enrico]' Tagliavini and a little rewritten by me.
Its goal is to prune your Quassel sqlite database from old entries that you don't need anymore.
Since your sqlite database can grow a lot fast (moreover if you have a lot of chat channels opened), comes useful the possibility to "chop off" your database from old entries that you think you don't need anymore.
So we've written a small script that:
- Create a copy of your database
- Deletes entries older than a selectable timespan (DATE_TO_PRUNE variable)
- Rebuild your database saving a lot of space on your hard drive
- Customizable time-prune span
Little note
As the script will remind you, it's strictly adviced you to stop your quasselcore (or the monolithic build) before running the script.
How to:
Just put the script into ~/.config/quassel-irc.org and execute the script itself.
It will look for quassel-storage.sqlite that should be in that directory.
Please make sure you've adjusted DATE_TO_PRUNE parameter by editing the script itself before just running it.
External tools: sqlite3
Download link:
The script can be easily downloaded here and it's released under GPLv2 license.