Dear piler users,
perhaps some you you don't really like mysql, and prefer postgresql.
Unfortunately mysql-specific code is hard wired deeply to the logic
of piler, and adding support for another rdbms would duplicate tons
of code.
Not any more. I created a very minimalistic database abstraction for
mysql, and replaced every mysql_* call with a wrapper function in the
code.
It yielded to a somewhat clearer code, even though it's a pretty big
change
under the roof, and I assume it as a beta quality not ready for
production
yet.
However I started to use it on the demo site, trusted all my more than
a
million demo emails to the new daemon, and so far so good.
So to bottomline I would like you to test the new branch: import tons
of
emails, set a very short a few days retention time, try to export them
on a daily basis, and be sure to try the pilerpurge utility as well.
You can get it at https://bitbucket.org/jsuto/piler/get/dbfix.tar.gz
Once again: consider it as beta quality only for testing. It's best to
do a fresh install, and copy some of your emails.
If you find any bug then just let me know.
I'll let it run for a month or so, and if it's stable then start to
work
on postgresql support. You may expect it ~2 months from now.
Thanks for your help,
Janos