Date: Fri, 11 May 2001 10:26:00 -0400 From: "Nathan Vidican" <nathan@vidican.com> To: "FreeBSD Questions" <questions@freebsd.org> Subject: email to SQL Message-ID: <001301c0da26$4dc59260$7053cad1@78lb019>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?001301c0da26$4dc59260$7053cad1>