[thelist] Majordomo customization?

[Steve Cook]

I've been working lately on creating a database stored archive of posts to
my mailing list. There is support for having everything in ezmlm (the list
manager I use) stored in mySQL, but it wasn't built this way on the box I
use, so I'm stuck with text based.

Anyway, what I did was to write a perl script that has two possible
functions. Firstly it can be run to drop the archive database table and
create a new one, reading the entire text archive and parsing it into
whatever database format I choose. With another command-line switch I can
make it do an incremental parse. In this way I can load the entire archive
into the database and then set a cron job to check the archive every hour
and load any new articles. 

Seems to be working very well for me!

I would suggest that something similar might work for majordomo (though I
have NO experience of the mlm at all!). In ezmlm there's a text based log of
sub and unsubs, it should be pretty straightforward to just parse that every
hour or so.

.steve


----------------------------------
   WapWarp - http://wapwarp.com
 Wap-Dev - http://www.wap-dev.net
 Cookstour - http://cookstour.org
----------------------------------

> -----Original Message-----
> From: CDitty [mailto:mail at redhotsweeps.com]
> Sent: den 13 september 2000 14:10
> To: thelist at lists.evolt.org
> Subject: [thelist] Majordomo customization?
> 
> 
> Has anyone customized Majordomo to use an sql database instead of the 
> standard flat file text database?  On one of my sites, I use mysql to 
> manage my user info.  I figured it would be easier to manage 
> everything if 
> it was all in the same database.
> 
> Opinions?
> 
> CDitty
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>