Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder1.xlned.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <rodrick.brown@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.007
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; 'cc:addr:python-list': 0.11; 'message-id:@unknownmsgid': 0.16; 'postgres,': 0.16; 'sqlalchemy': 0.16; 'sqlite': 0.16; 'subject:between': 0.16; 'twisted': 0.16; 'for?': 0.16; 'wrote:': 0.18; 'widget': 0.19; 'cc:addr:python.org': 0.22; 'specify': 0.24; 'cc:2**0': 0.24; 'primary': 0.26; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; 'url:mailman': 0.30; 'there.': 0.32; 'know.': 0.32; 'url:python': 0.33; 'raw': 0.33; 'received:google.com': 0.35; 'url:listinfo': 0.36; 'thanks': 0.36; 'subject:?': 0.36; 'url:org': 0.36; 'should': 0.36; 'sure': 0.39; 'url:mail': 0.40; 'pick': 0.64; 'iphone': 0.65; 'to:addr:gmail.com': 0.65; 'alec': 0.84; 'received:mail-ob0-x22f.google.com': 0.84; '2013,': 0.91
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:references:from:mime-version:in-reply-to:date:message-id :subject:to:cc:content-type; bh=FQYeHLSnjoMAYZM+XM2ckJvce+1zQF4sdMQJYHQ64gg=; b=G2+pKcmtGqnAt4rp430Dc1WJNATsgqzNPaBJnyLpsHEurxDY7zr8yEBptU64riW5O0 41FvwtpPYxkztF9waZbJ2t8IPNxaKlxWvsPpOUQLDpxcJsIWLJ4o3XJAskS/G1GzzRgC myU/z1kLwdwYNz8JjIoFgxUp3ARjC56F0ZmSJP5n2FxCzmXkQKydRbxi3copHMazeYzd PklZmwFGHPPoOIRdxCwHkeAuZD+a1HMb42gwd0qZuDph+VJwI//j6cHPhgQ1rdaGJQfV 7tbhRyhuiAu3FhFrwfbuNdhqIAq6zkyXHhYzI8UMUj10++ETJ5WpccFO38x/bqiZEFCG Fo7Q==
X-Received: by 10.60.29.72 with SMTP id i8mr1581655oeh.93.1365008746953; Wed, 03 Apr 2013 10:05:46 -0700 (PDT)
References: <CAO+9iGd2hAjpouFm852hpC9865-NYv5qxkV+CeFPySejvv5q=Q@mail.gmail.com>
From: Rodrick Brown <rodrick.brown@gmail.com>
Mime-Version: 1.0 (1.0)
In-Reply-To: <CAO+9iGd2hAjpouFm852hpC9865-NYv5qxkV+CeFPySejvv5q=Q@mail.gmail.com>
Date: Wed, 3 Apr 2013 13:05:30 -0400
Subject: Re: How to choose between ORMs?
To: Alec Taylor <alec.taylor6@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Cc: "comp.lang.python" <python-list@python.org>
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.68.1365009096.3114.python-list@python.org>
Lines: 26
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1365009096 news.xs4all.nl 6873 [2001:888:2000:d::a6]:57777
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:42687

Pick the one you learn and know.

Sent from my iPhone

On Apr 3, 2013, at 2:17 AM, Alec Taylor <alec.taylor6@gmail.com> wrote:

> 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
> --
> http://mail.python.org/mailman/listinfo/python-list