-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Jul 5, 2007, at 6:00 PM, Michael Bayer wrote:
> On Jul 5, 5:46 pm, Barry Warsaw <[EMAIL PROTECTED]> wrote: >> What I mean by that is that Mailman has at least three separate >> related collections of data: mailing lists, users, and messages. It >> should be possible to put each of those three in separate databases >> using three different engine urls. The classic use case is this: say >> my user database lived in my web application, but that web app was >> separate from the mailing list system, and the data for the lists >> lived in a separate database. It should be possible for Mailman to >> get list configuration data from database B and user data from the >> web app's database A. Similarly, you might want to put the message >> storage in database C, say the one that your archiver used. >> >> Of course, this means that you can't design your data model to have >> foreign keys across these three storages, but that's not hard, though >> you have to manage consistency at the application layer. I'm not >> sure such a design is actually feasible with SQLAlchemy though; I >> think it wasn't back when I actually tried to do this ages ago. >> > > its quite feasable, particularly since you are separating concerns at > the table/class level (as opposed to the row level, which is the > "sharding" thing ive been talking about). there are three general > approaches to this: Thanks very much for the information Michael. I'm stashing this message away for a tasty later meal. :) - -Barry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (Darwin) iQCVAwUBRo588XEjvBPtnXfVAQLNfwP/QK1dhl4DmfE9C5jm49aHDn9rjkBc0f/e EiA6ZGF0189soweQHL80zBD+Ug5kIk7DsGKPtG3kZ+O4n25t3jGrdUmUezK2PUet RoxnftZx0sCVKYGWvrG4DdPpKfPi0VgIs3KpFVhCG6auCq6J2B6yw7PoNGa6Blpq g2gqfUy+lYs= =bRN1 -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---