I On Aug 26, 3:43 am, Iain Duncan <[email protected]> wrote: > 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? > > thanks! > Iain
Have you ever used an ERD tool like ER/Studio? I've read a number of books on DB fundamentals through the years, but have found playing around with designing schemas using a GUI to be even more valuable. I've learned a lot by studying the code they produce and can now produce much "tighter" models when writing table definitions, triggers, etc. by hand. Almost all ERD apps I've seen are ungodly expensive though. If you aren't lucky enough to be able to expense it to the client you can still learn quite a bit from using a time-limited demo. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
