Re: Managing a Personal Email Archive

[Corion]

I don't know about the status of Mark Overmeers mail program, but he developed the Mail::Box suite to deal with email in its various forms of existence for a mail reader program written in Perl/Tk.

As for your idea to store all your mails in a database, this can be a curse and a blessing - you lose the tool/skillset associated with Unix, mostly grep and Perl to deal with mailfiles, but you gain (given a good table design) the SQL toolset to search and manipulate your mails.

perl -MHTTP::Daemon -MHTTP::Response -MLWP::Simple -e ' ;    # The  
$d = new HTTP::Daemon and fork and getprint $d->url and exit;#spider
($c = $d->accept())->get_request(); $c->send_response( new   #in the
HTTP::Response(200,$_,$_,qq(Just another Perl hacker\n))); ' #  web

[oubiwann]

I've actually written code with Mail::Box. It was pretty strange getting used to - but not because of the module; because of the mail!

I had to do something almost identical to what you are doing, but it was for filling out timesheets (dread!). I had it suck in my mail, dump the parts of the header and the body into different fields, and then run that against the tasks I had in bugzilla...

I can't tell you how great this module is. Go for it! If you want to email me at work, I can try to dig up that code. I never polished it up, so it might be kind of messy... let me know:

d m c g r e g g o r
(a t)
g e n p h y s i c s
(d o t)
c o m