Re: white-black-ignore list entry syntax

On Sat, 5 Mar 2005, Sergio P. Cesar wrote:

> > I am afraid I don't see the point of using a database to store regex
> > patterns.  Don't you have to match any incoming message against all
> > patterns anyway ?

> Not really, If we properly build a set of queries to check the
> possibilities, I think the database could be faster in an setup with LOTS
> of entries in the list (ie: global company white/black list), regex would
> have to check all entries and a db query should return a single response.
> (yes || no)
> At the moment I can think of 3 queries only in this order:
> 1- an exact match on a wildcard domain, *.domain.name
> 2- word or frase match anywhere in the subject line.
> 3- Exact macth on an email address
>
> With a database we only need a single indexed entry for an address for all
> users and all domains hosted. The individual user list will have a single
> index hopefully smaller in lenght and faster to search.

I am not sure I understand... do you want to give up part of the
expressive power of regular expressions, replacing it by a simpler
pattern matching scheme, in order to be able to implement it using a
database ?

That seems interesting even if it looks like a feature removal at
first sight. After all, there are probably not many people out there
using very complex pattern matching rules.

On the other hand, for simple and not CPU-limited setups, built-in and
pre-installed regular python regular expressions will always be much
easier to setup than using a database.

Cheers,

Marc.

-- 
So einfach wie möglich. Aber nicht einfacher -- Albert Einstein





-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click