Hi, While I find the DBMail idea to be perfect for mail server, I believe it could use the RDBMS backend a little further.
What I am getting at is the fact that it is keeping all sorts of information about a given message in a blob which --if made available-- would help further usefulness. Take, for example, From, Data, Sender, To, CC, Retun Path fields for each message. If DBMail had parsed these fields and stored them in a separate table, a lot of searches could be speeded up. The added table schema could look like something like these: table name: dbmail_address_headers with fields message_idnr field_kind [integers for From, Data, Sender, To, CC, Retun Path] mail_address [single address per entry] and, table name: dbmail_date_headers with fields message_idnr date [send date] One further application I have in mind is tracking or charting email traffic in a corp environment. I hope you will find this good enough to implement. Cheers,
