Philip Jenvey wrote: > > On Aug 25, 2009, at 7:15 PM, Jamie wrote: > >> 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? > > 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
Having recently switched to SQLAlchemy, I'll chime in with my $.02. I don't use the orm parts of it since I'm using my db as a blob store. I guess that puts me in the bitbucket category. Still, I rolled my own sql generation module and it soon grew fairly unwieldy. I switched to using SQLAlchemy's sql expression layer a few months back and things have been simplified a lot. I still use my own solution to map blob actions to sql operations, but the queries are generated through SQLAlchemy. It works very effectively, I've only had to replace a couple of queries with hand-generated ones. At first it seemed awkward to have the schema definition in my application, but I've found it to be easier to migrate between schema versions. - kochhar --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
