object-relational mappers

Jarek Zgoda jzgoda at o2.usun.pl
Thu Apr 3 09:56:01 EDT 2008


Bruno Desthuilliers napisał(a):

> Now my own experience is that whenever I tried this approach for
> anything non-trivial, I ended up building an "ad-hoc,
> informally-specified bug-ridden slow implementation of half of "
> SQLAlchemy. Which BTW is not strictly an ORM, but primarily an attempt
> at a better integration of SQL into Python. So while it may feel like
> learning the inner complexities of SQLALchemy (or Django's ORM which is
> not that bad either) is "wasting brain cells", MVHO is that it's worth
> the time spent. But YMMV of course - IOW, do what works best for you.

I like OR mappers, they save me lot of work. The problem is, all of them
are very resource hungry, processing resultset of 300k objects one by
one can effectively kill most of commodity systems. This is where raw
SQL comes in handy.

-- 
Jarek Zgoda
Skype: jzgoda | GTalk: zgoda at jabber.aster.pl | voice: +48228430101

"We read Knuth so you don't have to." (Tim Peters)



More information about the Python-list mailing list