Jamie wrote: > It seems that most people who adopt a MVC framework are in love with > the ORM stuff. I'm just wondering if I'm the only one who insists on > hand-writing my queries and sticking them in stored procedures? >
My current project is heavily invested in stored procedures, to the tune of about 10k lines of SQL. Like you, I'm more coming from a DBA/RDBMS standpoint, and find that ORMs never do things properly. > I guess it's because I come from a DBA/RDBMS development background > and tend to make heavier use of the procedural logic available in a > RDBMS, whereas most web developers use the DB purely as a bit bucket. > I've tried to use a few ORMs, but have found them to be "too magical" > and they get in the way of how I'm used to doing things. (In fact the > primary reason I've adopted Pylons is because I can use it without an > ORM). Is there any compelling reason why I should force myself to use > SQLAlchemy? As others have said, see if its other tools fit your needs. If not, then it's not for you. It wasn't for me, so I built Simpycity, which does some nice abstractions entirely using raw queries. The best part about Pylons is, if a component doesn't work for you, you can replace it without much trouble at all. Regards, -- Aurynn Shaw The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103 PostgreSQL Replication, Consulting, Custom Development, 24x7 support [email protected] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
