Brian Martinez writes:
We are in the process of moving a fair portion of our users' preferences over to MySQL. However, one thing that is not clear to me is this nagging question about putting .mailfilter files into SQL. Is that even possible?
Everything is possible, if you write the code to do it. As it is now, maildrop has no support for reading mail filters from anywhere other than a plain file.
Furthermore, mail filter rules are not a two-dimensional set of records that one can just dump into a database. They are scripts, not data records. They can't exactly be mapped to some database schema. And there is no clear benefit from just putting the whole script as a single BLOB. Great! You've done that. Now what? Reading the blob now takes ten times slower than opening and reading the same file. You now have an extra point of failure, and your performance is in the doghouse.
Sounds like a prime candidate for a feature article on http://www.thedailywtf.com, to me.
pgpCaUgcviGjR.pgp
Description: PGP signature
------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
