[Mailman-Developers] Want to Code... need some feedback

J C Lawrence claw@kanga.nu
Thu, 05 Jul 2001 12:22:29 -0700

On Thu, 05 Jul 2001 11:55:03 -0700 
Charles Iliya Krempeaux <tnt@linux.ca> wrote:

>      To do this, I think that e-mail messages should be dumped
> into a database.  (Since I have MySQL and PostgreSQL at my
> disposal, those are what I'll be able to support myself.)

I have some early proof of concepts done on having MHonArc generate
scripts which when executed insert their respective message contents
into PostgresQL with the appropriate threading links.  The code is
based off the PHP and templated based archiving I already do at
Kanga.Nu, merely taking the already products PHP variable
assignments in the current system and insteaf having the back end
use them as the values to insert into the DB.

It works.  Kinda.  Its not pretty.  The reliance on PHP as an
intermediate layer should be removed (slightly messy as MHonArc
insists on inserting HTML-style comments), Proper thread handling
and generation needs to be improved (Shouldn't reluy on MHonArc but
should be dynamically generated).  etc.

J C Lawrence                                             claw@kanga.nu
---------(*)                                http://www.kanga.nu/~claw/
I never claimed to be human.