Re: Mailman-Developers External user database
On 2003-04-30 at 23:32:02 [+0200], mailman-developers-request@python.org wrote:
- External user database. I'm sure you're all aware of the desire of some folks to have this. I found a Wiki document somewhere on the zope.org site that had discussions on this but I believe it was somewhat dated. Have any conclusions been reached with respect to the direction here? I think I read talk of a Zope-specific solution. I'm wondering if this means that we're likely never to see a Mailman that can talk to a MySQL database. I believe this one feature alone would elevate Mailman significantly. How hgh of a priority is this to the development team and what is the status? Are there current discussions on this somewhere other than the list (wiki boards, chats, what-have-you) , and if so, may I take part?
See MemberAdapter in Mailman 2.1.x. As it happens, I'm currently writing an advanced LDAP backend [ yes, I've see the other one :-) ].
We are currently using a generic RDBMS adapter which is available (commercially) from the developer; I assume there are others out there. This is a non-trivial piece of work so I think it may be a while before it is part of core mailman. I cannot recommend using MySQL for this because it will not enforce data integrity which is one of the key reasons for using an RDBMS in my view another being size: our lists are due to get very, very big (100.000 + users) I think Mailman's data store gets pretty bloated on such lists.
Charlie
I think having a choice would be good. Sympa allows the use of a MySQL user database. And while I don't want to get into a Sympa vs. Mailman debate I have to say that the feature is attractive because it presents opportunities for those who want their MLM to be an integrated part of a bigger tool. There is a need for collaborative tools that go beyond the mailing list but I believe the mailing list is the foundation, the glue. And being able to easily integrate a proven MLM such as Mailman into a variety of scenarios would be a Good Thing.
Zope / Plone + Mailman
PHP/MySQL tools (eg Postnuke) + Mailman
whatever-your-heart-desires + Mailman
Cheers, Kevin
At 10:12 PM 01/05/03 +0200, Charlie Clark wrote:
We are currently using a generic RDBMS adapter which is available (commercially) from the developer; I assume there are others out there. This is a non-trivial piece of work so I think it may be a while before it is part of core mailman. I cannot recommend using MySQL for this because it will not enforce data integrity which is one of the key reasons for using an RDBMS in my view another being size: our lists are due to get very, very big (100.000 + users) I think Mailman's data store gets pretty bloated on such lists.
Charlie
On Thu, 2003-05-01 at 16:30, Kevin McCann wrote:
And being able to easily integrate a proven MLM such as Mailman into a variety of scenarios would be a Good Thing.
Zope / Plone + Mailman
PHP/MySQL tools (eg Postnuke) + Mailman
whatever-your-heart-desires + Mailman
You've been peeking in on my dreams, huh? :)
okay-so-they're-boring-ly y'rs, -Barry
On Thu, 2003-05-01 at 16:12, Charlie Clark wrote:
We are currently using a generic RDBMS adapter which is available (commercially) from the developer; I assume there are others out there. This is a non-trivial piece of work so I think it may be a while before it is part of core mailman. I cannot recommend using MySQL for this because it will not enforce data integrity which is one of the key reasons for using an RDBMS in my view another being size: our lists are due to get very, very big (100.000 + users) I think Mailman's data store gets pretty bloated on such lists.
Yep, see my previous posting about the bloat issue. Mailman has to load the entire user database into memory to act on it and this sucks.
The other issue is that updates to the list data and by extension the user data should be transactionally protected. This is possible in Mailman 2.1.2 although it may not be completely obvious. The BerkeleyDB adaptor in cvs utilizes this.
-Barry
participants (3)
-
Barry Warsaw -
Charlie Clark -
Kevin McCann