Storm vs. SQLAlchemy
Gustavo Niemeyer
gustavo at niemeyer.net
Wed Jul 11 05:56:29 BST 2007
Hey Karl,
> SQLAlchemy and Storm seem to be really similar at the first look. Did
> anyone take the time to compare the two? The only comparison I could
> find was the discussion on reddit:
(...)
Nope.. there are no good comparisons so far. Considering that they
take such a different approach, I'm interested in seeing people
talking about their experiences on real world projects, rather than
just a superficial bullet-point-like approach.
There are main obvious conceptual comparison points that are
noticeable, even then:
- Storm doesn't need the schema to be declared on the Python side.
That's a side-effect of the fact that in Canonical we like to
do schema management with SQL.
- Because of that and the way that Storm is put together, building
backends is much simpler.
- It also means that Storm doesn't handle schema management.
- Storm's API is a lot more lightweight. Most operations are done
with a few methods in the Store, and the ResultSet.
These are important bottom line aspects. Comparisons which are
too fine-grained will probably not be so valuable, since features
might be ported from one ORM to the other with certain ease.
--
Gustavo Niemeyer
http://niemeyer.net
More information about the storm
mailing list