OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Subject: Re: SQL Mail Delivery Options
From: Brad Knowles (blkskynet.be)
Date: Wed Mar 29 2000 - 14:29:50 CST

At 2:17 PM -0600 2000/3/29, Robert Bradman wrote:

> Would anybody on the list be interested in assisting in the creation of an
> SQL local delivery agent? Something that would work along with the SQL
> aliases patch only it would deliver the mail directly to a given table
> inside MySQL.

        My experience with commercial SQL databases is that they do not
handle the storage of BLOBs (Binary Large OBjects) well, and the
storage of the contents of actual e-mail messages would certainly
qualify as BLOBs. I would say that the same is much more true of
MySQL than even commercial SQL databases.

        Go down this road if you like, but IMO you're setting yourself up
for some really major pain in the near future.

        Now, implementing a database to handle the index information of
what contents of what mail message are stored where (and the storage
of the actual mail message contents happens outside of the database),
that's a good idea -- and part of the basis for the proposal I have
made to LISA 2000 for an invited talk. ;-) 

--
   These are my opinions -- not to be taken as official Skynet policy
======================================================================
Brad Knowles, <blkskynet.be>                || Belgacom Skynet SA/NV
Systems Architect, Mail/News/FTP/Proxy Admin || Rue Colonel Bourg, 124
Phone/Fax: +32-2-706.13.11/12.49             || B-1140 Brussels
http://www.skynet.be                         || Belgium