Re: SQLObject or SQLAlchemy?


John Salerno wrote:
Are there any major differences between these two? It seems they can
both be used with TurboGears, and SQLAlchemy with Django. I'm just
wondering what everyone's preference is, and why, and if there are even
more choices for ORM.

I just finished surfing both websites last night myself and here is
what I glean

-- I dont see why SQLObject could not be used with Django

-- SQLAlchemy is not just an ORM. It can be used that way. I dont know
why you have to explicitly tell it about related tables twice though.
You do it the first time when defining table metadata:
http://www.sqlalchemy.org/docs/tutorial.myt#tutorial_schemasql_table_relationships

but when you have to make a call to relation as well:
http://www.sqlalchemy.org/docs/tutorial.myt#tutorial_orm_relationships

It would seem that one or the other is enough and having to do both is
redundant... continuing with the comparison

-- SQLObject makes it clear that it only has support for tables with a
single-column primary key

-- tha can both do self-joins

-- SQLAlchemy has support for connection pooling

-- ORMS get slow when you need to load a lot of records. SQLAlchemy has
usage modes to load massive data sets when the job calls for it.


Thanks.

Just my 2 cents.

.

Relevant Pages

  • Re: python question?
    ... I use pyQT and Geany. ... I also often use SQLAlchemy, Django, ... scipy, kate,and Elixir. ...
    (Ubuntu)
  • Re: SQLObject or SQLAlchemy?
    ... both be used with TurboGears, and SQLAlchemy with Django. ... wondering what everyone's preference is, and why, and if there are even ...
    (comp.lang.python)
  • SQLObject or SQLAlchemy?
    ... It seems they can both be used with TurboGears, and SQLAlchemy with Django. ... I'm just wondering what everyone's preference is, and why, and if there are even more choices for ORM. ...
    (comp.lang.python)
  • Re: Frameworks
    ... uses sqlalchemy as ORM and jinja2 (others can be used ... I have been searching through the vast array of python frameworks ... ever want to use an alternate DB layer or templating system. ... Note that Django's ORM, while already pretty good and constently improving, ...
    (comp.lang.python)
  • Re: Is there something easier than ORM?
    ... SqlAlchemy and ORMs in general than I am. Granted, ... My boss and I were both very comfortable with SQL and were happy ... unlike other orm solutions it doesn't force you to use orm. ... programatically constructing sql commands that would be a nightmare to ...
    (comp.lang.python)