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>
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

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