From owner-freebsd-questions Fri May 11 13:49:26 2001 Delivered-To: freebsd-questions@freebsd.org Received: from mail.freebsd-corp-net-guide.com (mail.freebsd-corp-net-guide.com [206.29.169.15]) by hub.freebsd.org (Postfix) with ESMTP id 4139D37B43C for ; Fri, 11 May 2001 13:49:23 -0700 (PDT) (envelope-from tedm@toybox.placo.com) Received: from tedm.placo.com (nat-rtr.freebsd-corp-net-guide.com [206.29.168.154]) by mail.freebsd-corp-net-guide.com (8.11.1/8.11.1) with SMTP id f4BKnCk31352; Fri, 11 May 2001 13:49:13 -0700 (PDT) (envelope-from tedm@toybox.placo.com) From: "Ted Mittelstaedt" To: "Nathan Vidican" , "FreeBSD Questions" Subject: RE: email to SQL Date: Fri, 11 May 2001 13:49:12 -0700 Message-ID: <003301c0da5b$d58de820$1401a8c0@tedm.placo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 In-reply-to: <001301c0da26$4dc59260$7053cad1@78lb019> Importance: Normal Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Somewhere there are patches to qmail that make it use a SQL server. You might look at that, maybe there is something you can use there. Ted Mittelstaedt tedm@toybox.placo.com Author of: The FreeBSD Corporate Networker's Guide Book website: http://www.freebsd-corp-net-guide.com >-----Original Message----- >From: owner-freebsd-questions@FreeBSD.ORG >[mailto:owner-freebsd-questions@FreeBSD.ORG]On Behalf Of Nathan Vidican >Sent: Friday, May 11, 2001 7:26 AM >To: FreeBSD Questions >Subject: email to SQL > > >Does anyone happen to know of, (or have), some small utility which will >archive email into an SQL table? I'm looking for something that will >retrieve the messages either via direct access to the mail spool, or via >pop3. I know that I could probably just ripoff a portion of some >webmail app >to accomplish this, but to be optimistic I figured someone might have >already done so, and would be willing to share their code. I would >prefer to >use C, but PERL will work too. > I will require the code so-as to allow for an indexing of the emails >from within a website. I want the website to be able to search for messages >based on content and subject. I would prefer not to keep the emails in an >archive file similar to the mail spool format because of performance >reasons. I figure running an SQL query once the system has 10,000+ >emails in >it will be much faster than trying to search a couple hundred >thousand lines >of a text file. > > >Nathan Vidican >Nathan@Vidican.com >http://Nathan.Vidican.com/ > > > > >To Unsubscribe: send mail to majordomo@FreeBSD.org >with "unsubscribe freebsd-questions" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message