Mike Machado and Brian Lavender gave a talk about email to database.
Sean-Paul Reese had asked about converting email messages to a database in a thread on the lug-nuts list.
(you can search the list in the search box on the top of this page). They used a few different techniques to
accomplish this task.
The first thing would be to convert the data from a mbox format to a database. Brian used a couple of
perl modules and some mysql commands to do this. We stepped through the lines of code as Brian explained
what was happening, and why. After he had successfully parsed the string into sections it was easy to
insert each mail message into the database. Brian used Carp, CGI, and DBI (to interface with mySql).
Mike Machado took over the presentation and continued with a web interface of the database in perl.
This had the real possibility of becoming a sourceforge application.
original post
Brian Lavendar (our fearless leader) is a perl and oracle hacker. He has written
a Oracle on linux paper as well as helped numerous people with perl scripts.
Mike Machado currently working for Innercite (a local ISP) has [GnuDip], and
[My Admin] (a web based administration of mySQL) to his
credit. This pair of speakers should produce an interesting mix of information, zealotry (is that a word?) and enjoyable entertainment.