Sacramento Linux Users Group (SacLUG)  

   Aug 8, 2000 Meeting Notes   

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.

   Reference Links   
[perl.org]* the glue of the internet.
[cpan.org]* CPAN: Comprehensive Perl Archive Network
[mysql.com]* a small and very fast database
[sourceforge.net]* a code repository for open ssource projects

[CVS source info goes here, when I get back from LinuxWorld]
   Previous Meeting Notes