I appreciate the feedback, David.

A Berkley DB hash should be fine for this purpose.  I do have existing
greylist lookup/manipulation functions that I can reverse-engineer to get
the jist of what I'm looking for.  (Unfortunately, I'm not a strong perl
guy, and the gent that wrote our greylist functions has since moved on to
"other career opportunities").

Ken

-----Original Message-----
From: David F. Skoll [mailto:dfs@roaringpenguin.com] 
Sent: Friday, June 17, 2005 2:29 PM
To: mimedefang@lists.roaringpenguin.com
Subject: Re: [Mimedefang] Using a db for subject lines to block


Cormack, Ken wrote:

> Does anyone on the list use anything in sub filter_begin, to lookup
$Subject
> in a database?

Not $Subject, specifically, but our CanIt product is almost completely
database-driven.  We use a PostgreSQL database, but for what you
want, any SQL database would probably be fine, or even just Berkeley DB
with a tied hash.

If you go the SQL route, just create a table of subjects, with an index
for speedy lookup, and you should be fine.

Regards,

David.
_______________________________________________
Visit http://www.mimedefang.org and http://www.roaringpenguin.com
MIMEDefang mailing list
MIMEDefang@lists.roaringpenguin.com
http://lists.roaringpenguin.com/mailman/listinfo/mimedefang

