How to choose between ORMs?

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder4.news.weretis.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<alec.taylor6@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.004
X-Spam-Evidence	'H': 0.99; 'S': 0.00; 'schema': 0.05; 'suggestions,': 0.07; 'keys,': 0.09; 'orm': 0.09; 'subject:How': 0.10; 'postgres,': 0.16; 'sqlalchemy': 0.16; 'sqlite': 0.16; 'subject:between': 0.16; 'twisted': 0.16; 'for?': 0.16; 'widget': 0.19; 'specify': 0.24; 'primary': 0.26; 'message- id:@mail.gmail.com': 0.30; 'there.': 0.32; 'raw': 0.33; 'received:google.com': 0.35; 'thanks': 0.36; 'subject:?': 0.36; 'should': 0.36; 'to:addr:python-list': 0.38; 'sure': 0.39; 'to:addr:python.org': 0.39; 'alec': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:date:message-id:subject:from:to :content-type; bh=9fF5c4/yU1WqPsKvr4ipdieQ1tg78eUe+lQXA5KZltw=; b=wRYKGJ5p6G+dXze/sD3nEjFgk2/Z6q179TaK1vhju7z4umcFjIetd5j1GlNZMwTaJe MwsSyD4tZrTFTV51Cwby7syzDlvD1PCMo673Uh+IFF3/xuv6mSYe0Sv9kEcS/NCKoFxq vIadBOJMvbwC0+68/lRBPTvqjlG2EqfCdpixU/nHSPZH+oi61AD6xi2Edy27xluX8Hie gknbJptmLH79XwCQIytGHh9okk+zGgfyFF3tGofbh0FdwcH6vz/xkeJfXbp8oi0bZmNX DWGrPit6rXFB/1jO+HURXkaLUM+bvH2Zx5YhmbxvsgqTghYw11NwrPf9odhHiNvMqG7O DwBQ==
MIME-Version	1.0
X-Received	by 10.50.222.167 with SMTP id qn7mr243234igc.42.1364969698312; Tue, 02 Apr 2013 23:14:58 -0700 (PDT)
Date	Wed, 3 Apr 2013 17:14:58 +1100
Subject	How to choose between ORMs?
From	Alec Taylor <alec.taylor6@gmail.com>
To	"comp.lang.python" <python-list@python.org>
Content-Type	text/plain; charset=ISO-8859-1
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.35.1364969706.3114.python-list@python.org> (permalink)
Lines	18
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1364969706 news.xs4all.nl 6941 [2001:888:2000:d::a6]:37940
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:42630

Show key headers only | View raw

SQLalchemy and Storm are a few of the popular ORMs out there.

Personally I have been using web2py's DAL.

Other than form generator availability, 'print as raw SQL', multiple
primary keys, widgets*, `check` conditions and compatibility with
OracleDB, Postgres, SQLite and some of the NoSQL systems; what else
should I be looking for?

Thanks for all suggestions,

Alec Taylor

*not sure if widgets should be a requirement; by widgets I mean
annotation of db schema to specify which widget to use with the form
generator

PS: Will likely use this ORM with: Flask, Bottle or Twisted Matrix

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

How to choose between ORMs? Alec Taylor <alec.taylor6@gmail.com> - 2013-04-03 17:14 +1100
  Re: How to choose between ORMs? Roy Smith <roy@panix.com> - 2013-04-03 09:16 -0400

csiph-web