On Tue, 2019-06-25 at 11:09 -0500, David B Funk wrote: > that's way overthinking it. > David & David,
I agree, now that there's a configurable OSS dnsbl server available, that using it is the obvious choice for dealing with a standalone list, but the OP did ask specifically about using database queries to implement a blacklist, so I thought it was worthwhile to tell him what's involved in doing that. I've been running a whitelist off my mail archive for around a decade now. My archive contains both incoming and outgoing messages and is held in a PostgreSQL database. My SA plugin whitelists anybody who I've sent mail to, so provides a very low maintenance whitelist since it automatically sees new outgoing messages as well as the effect of archive maintenance. For all I know the OP either has a similar archive or is intending to implement one: searching for a specific message with a database tool is a *lot* faster than ferreting through a set of very large mail folders with your MUA, though of course the effort of creating and maintaining the database, mail loader, query tools and SA plugin is non trivial. Martin
