Date: Fri, 11 May 2001 13:49:12 -0700 From: "Ted Mittelstaedt" <tedm@toybox.placo.com> To: "Nathan Vidican" <nathan@vidican.com>, "FreeBSD Questions" <questions@FreeBSD.ORG> Subject: RE: email to SQL Message-ID: <003301c0da5b$d58de820$1401a8c0@tedm.placo.com> In-Reply-To: <001301c0da26$4dc59260$7053cad1@78lb019>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?003301c0da5b$d58de820$1401a8c0>