From owner-freebsd-questions Fri May 11 7:31:36 2001 Delivered-To: freebsd-questions@freebsd.org Received: from mail.ipsnetwork.net (mail.ipsnetwork.net [209.202.83.5]) by hub.freebsd.org (Postfix) with ESMTP id BDC0D37B43C for ; Fri, 11 May 2001 07:31:34 -0700 (PDT) (envelope-from nathan@vidican.com) Received: from 78lb019 (112-83.209-tic.ipsnetwork.net [209.202.83.112] (may be forged)) by mail.ipsnetwork.net (8.11.1/8.11.1) with SMTP id f4C2cU812957 for ; Fri, 11 May 2001 22:38:31 -0400 (EDT) (envelope-from nathan@vidican.com) Message-ID: <001301c0da26$4dc59260$7053cad1@78lb019> From: "Nathan Vidican" To: "FreeBSD Questions" Subject: email to SQL Date: Fri, 11 May 2001 10:26:00 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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