What about using triggers in postgresql (mysql won't have this until 5.0).. Iwould think this would be IDEAL for message filters.. it would be faster than most any other method as well... I'll play around with some different methods for awhile and see what I come up with.
> Hi, > > I have made up a complex filtering scheme via a PHP script which has to > be called by hand. Added a new table "rules" which contains inbox, > regular expression and outbox fields, at large. > The script just runs over those rules and does MySQL REGEX queries for > each rule. It just has to UPDATE the message's mailbox field where the > messageblks match the regular expression. > Of course you could do that in Perl etc., but PHP is simple and works > fine for me! At our site, it will be a cron job every ten minutes or > so, in the near future. > > > I hope I've given some inspiration ;) > > Martin > > > Am Montag, 18. August 2003 19:50 schrieb Jesse Norell: >> Hello, >> >> There is no filtering in the stock dbmail, but there have been >> a couple patches to do that - check the LMTP/filtering patch on >> the sourceforge page (and maybe test lmtp while you're at it :). Ilja >> was going to try testing/incorporating that patch into the >> main codebase once he's done revamping, and I would certainly >> expect all the filtering mechanisms therein will remain (plus, >> Aaron has done work towards sieve filtering off and on, which >> should be available some day). >> >> >> ---- Original Message ---- >> From: <[email protected]> >> To: <[email protected]> >> Subject: [Dbmail] Mail Filtering w/ dbmail ? >> Sent: Mon, 18 Aug 2003 12:37:29 -0500 (CDT) >> >> > Is it possible to filter mail using dbmail, similar to procmail or >> > courier's mailfilter?? I would mostly like to be able to filter >> > email into different folders based on content, and also use >> > programs like spamassasin. Is this at all possible? >> > >> > >> > _______________________________________________ >> > Dbmail mailing list >> > [email protected] >> > https://mailman.fastxs.nl/mailman/listinfo/dbmail >> >> -- End Original Message -- >> >> >> -- >> Jesse Norell >> jesse (at) kci.net >> >> >> _______________________________________________ >> Dbmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
