Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

eMail Database

by amearse (Sexton)
on Mar 12, 2002 at 23:03 UTC ( #151260=perlquestion: print w/replies, xml ) Need Help??

amearse has asked for the wisdom of the Perl Monks concerning the following question:

Does anybody know of a mailserver designed to recieve email mail via sendmail and create a mysql entry for each individual email. If no one has created such a thing, do you think it would be feasible and how would you start an application like that? The ultimate goal would be to have a very fast, searchable inbox that would work in coordination with a cgi to track and group emails by assigning them to different catergories and what not. Any sound off would be a great help. -amearse

Replies are listed 'Best First'.
Re: eMail Database
by mpeppler (Vicar) on Mar 12, 2002 at 23:33 UTC
    Stuffing the headers (or the entire message) into the database should be reasonably straightforward. I use mailagent to filter incoming mail. That would probably be overkill to parse incoming mail and stuff it in a database, though. Something like MailTools might come in handy.

    That said the major issue is creating the appropriate categorization when the emails get inserted so that you can query the database easily afterwards. I think you'll find that to be the tricky part, because categorizing on the fly based on some values in the Subject, From, Cc fields, or in the body of the message will become slower and slower as the database grows.

    It's an interesting project, though :-)

    Michael

Re: eMail Database
by PrimeLord (Pilgrim) on Mar 12, 2002 at 23:12 UTC
    A quick search on Freshmeat returned spmail. It may be similar to what you are looking for. A little more thorough search on Freshmeat will probably turn up a few more hits.
Re: eMail Database, See Also This Thread
by dave_aiello (Pilgrim) on Mar 13, 2002 at 21:48 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://151260]
Approved by root
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (2)
As of 2022-10-02 06:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My preferred way to holiday/vacation is:











    Results (7 votes). Check out past polls.

    Notices?