Bob responded regarding the use of a perl program to insert emails into
a set of database tables:
I talked to Rias on irc about this. The problem is the database
design. To be blunt, I suck at database design :-) As Rias and I
bounced ideas back and forth, I think the best ideas would be to
enhance mailman to use vfolders, thus allowing a varity of backend
persistent storage (db, mbox, maildir, etc).
I believe there is even a vfolder api for searching, but I did not
research it any further.
I'm not familiar with the vfolder api. It sounds like a nice separation
of logic and would probably work well as a long-term solution/feature.
I'm also not familiar with the exact problem you're having, as I have
been lurking for quite some time. I'll look back at it and maybe I can
give a couple suggestions.
Oh, did you ever roll out that database syslog script I wrote
while at Real Time? I did create a sourceforge project for it, but have
since not done a thing for it.
--
Chad Walstrom <chewie at wookimus.net> | a.k.a. ^chewie
http://www.wookimus.net/ | s.k.a. gunnarr
Key fingerprint = B4AB D627 9CBD 687E 7A31 1950 0CC7 0B18 206C 5AFD
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
Url : http://shadowknight.real-time.com/pipermail/tclug-list/attachments/20011019/055a8199/attachment.pgp