On 26/08/2009, at 12:15 PM, 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? A major part of the difference tends to come from use of commercial vs open source RDBMS. I find that use of stored procedures is much more popular with people who use (or come from a background of using) Oracle or MS SQL as opposed to PostgreSQL or MySQL. I work beside a group of .NET developers who prefer stored procedures. My preference is to keep model logic in the application layer (with or without ORM) as that is just what I "grew up" with. > > 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? There's certainly no compelling reason to use SQLAlchemy's ORM layer if it doesn't help your development. However, it is worth pointing out that SQLAlchemy provides an excellent database connection pool management layer and SQL query construction toolkit, both of which can be used without touching the ORM stuff. So I suggest that even if you ignore the ORM layer (which is perfectly reasonable) you look at the rest of what SQLAlchemy provides. Cheers, Chris --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
