Jonathan Ellis wrote:
I'm presenting on databases and python at a user group, and it
belatedly occurred to me to get the list's input on this: what's your
favorite feature of sqlalchemy? If you've used similar tools, why did
you switch?
I switched to SQLAlchemy for several reasons:
Philosophy - "SQL databases behave less and less like object collections the
more size and performance start to matter; object collections behave less and
less like tables and rows the more abstraction starts to matter. SQLAlchemy aims
to accommodate both of these principles." - this is important to my current app
as it has a complex data model, some of which maps easily to an object model,
some not so easily, I need flexibility.
Documentation - even at the first release stage the doco was better than
most, if not all, similar projects.
Comprehensibility - the approach is conceptually fairly simple and it is
possible to read and understand most of the code w/o too much difficulty (there
are some fairly gnarly areas (read as: guru required) though!)
I'm staying with SQLAlchemy for the above reasons and:
Responsiveness - the support from Mike has been nothing short of amazing
Performance - excellent!
I switched from SQLObject because my frustration levels with it got too high,
I'm mostly working on this project in my spare time (which due to external
factors is extremely limited) and whenever I hadn't touched it for a while and I
had to do some ORM-related changes or additions there was often much gnashing of
teeth while I tried to get SQLObject to do what I wanted - invariably I ended up
dropping back to straight SQL just to make forward progress. One day, after
trying for some time to do something I thought should have been easy, I snapped
and started looking for something else. As fate would have it, that same day,
Mike announced SQLAlchemy, I read about it, initially thought it would probably
be too raw to work with, so I tried one or two others. For various reasons, they
were not suitable, so I had a closer look at SQLAlchemy, liked what I saw,
prototyped a few things with it and made the decision to switch.
I think my favourite feature of SQLAlchemy is its flexibility - given that this
project is a large, evolving beast that is very important to me.
Robert
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
