How to choose between ORMs?

2013-04-03 Thread Alec Taylor
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


Re: How to choose between ORMs?

2013-04-03 Thread Roy Smith
In article mailman.35.1364969706.3114.python-l...@python.org,
 Alec Taylor alec.tayl...@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?

Depending on what you're doing, schema discovery (aka introspection, 
reflection, etc) may or may not be important to you.

And it should come with a nice shrubbery.
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: How to choose between ORMs?

2013-04-03 Thread Rodrick Brown
Pick the one you learn and know.

Sent from my iPhone

On Apr 3, 2013, at 2:17 AM, Alec Taylor alec.tayl...@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
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: How to choose between ORMs?

2013-04-03 Thread Alec Taylor
I know None.

Currently I use web2py's; which is a DAL not an ORM.

On Thu, Apr 4, 2013 at 4:05 AM, Rodrick Brown rodrick.br...@gmail.com wrote:
 Pick the one you learn and know.

 Sent from my iPhone

 On Apr 3, 2013, at 2:17 AM, Alec Taylor alec.tayl...@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
-- 
http://mail.python.org/mailman/listinfo/python-list