Re: [Exim] Opinions sought: Exim and MYSQL

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: pkelly
Dátum:  
Címzett: Philip Hazel
CC: Microwave Systems Eximlist Exploder, exim-users
Tárgy: Re: [Exim] Opinions sought: Exim and MYSQL
hi,
  The main reason for not allowing SQL statements in the configure file
was that the code was a modification of the nisplus query style lookup and
i didnt really want to deviate to much from a working query style example.
    Also, you would need to do a lot of error checking on the expanded SQL
statement because any query that returned more than one row of data would
be very difficult to parse into a format that could be used by exim.


> (2) By not including the noise words "select" "from" and "where" in the
> actual query, you keep the queries less verbose.
>
> (3) You don't allow anything other than "select" commands, so you can't
> mess with the database by accident.


good points, maybe a compromise would be a way of overriding a standard
mysql exim lookup and allowing you to write in your own query, this would
provide an easier interface for most people but be flexible enough to
accomodate more advanced queries.

Paul

----------------------------------------------
Paul Kelly        pkelly@???
U-NET Internet Noc    Some day now!