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.
Mariano --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
