I'm not using stored procedures but I used too. I have a schema that's quite relational and I don't know if its me or what sometimes orm doesn't always suit. Prolly me thinking more relational than oo at the time the basic schema was made
That said sqlalchemy helps me a lot in both orm and when I need to sql queries for a report or some such. When I started using sqlalchemy it was because of uncertainty of future enviroments the application would be in and what it would have to use as a db. Pylons was chosen in my mind anyway, because there was more python savy employees than java folk in this rag tag gig I find my self in. I was also a bit tired of java at the time. No regrets so far. It was definatly easier to get going quick, in our situation. On Aug 26, 2009 12:00 PM, "Philip Jenvey" <[email protected]> wrote: On Aug 25, 2009, at 7:15 PM, Jamie wrote: > > It seems that most people who adopt a MVC framework... Stored procedures' popularity have mostly waned because they're not portable across dbs ORMs are a different issue entirely. I can understand having issue with ORMs for generating sub-standard schemas and queries. You shouldn't have that problem with SQLAlchemy -- it avoids being too magical and at heart its interests are aligned with yours as a DBA. The marketing material on its web page claiming it's 'dba approved' and 'unopinionated' is really true. It's not just an ORM, it also provides a SQL expression layer. You can generate queries however you like them. You can also always fall back to sending raw SQL through SQLAlchemy, and can even generate mapped objects from their results. Also the core SQLAlchemy ORM follows the data mapper pattern for better separation between the application's object layer and the database layer. If you're not planning to write everything as stored procedures it'll make your life as a DBA easier, not harder -- Philip Jenvey --~--~---------~--~----~------------~-------~--~----~ You received this message because you are sub... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
