On Wed, 2009-08-26 at 17:12 -0300, Mariano Mara wrote: > > > 2009/8/26 Iain Duncan <[email protected]> > > Hey folks, I'm going to be doing some fairly serious database > refactoring and redesign for a client for whom we are making > Pylons glue > apps to replace a cobbled together set of legacy db apps that > don't talk > to each other. I figure it's time to take my database design > knowledge > to the next level, and I'm hoping the folks who do serious db > application development in Pylons can tell me what to order. > > I've read 'Learning SQL' and 'Essential SQLAlchemy' and a fair > bit of > university db text book, and I intend to order 'Refactoring > Databases' > and likely 'Domain Driven Design'. Any recommendations for > best things > out there to really learn databases from an application > developers > perspective? > > Can you tell us which database will you be using? Every vendor has > certain little tricks that might be useful (and every database has > their own gurus that wrote books). > Besides that, it's not the same to design an OLTP database and a DW > database: you need to know exactly what the databases do to search for > best practices. > Lucky for you, it's a legacy db so you know in advance where you will > have most DML activity (inserts, updates) and you can find bottlenecks > right now and prevent them in the new design.
Thanks Mariano, luckily we are essentially making a new greenfield system that will just get data pushed from the legacy systems until we can replace them bit by bit. So I'm looking for vendor neutral isntruction, though we will likely be using either MySQL ( with InnoDB ) or PostGresql. iain --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
