What are some good Python ORM solutions

Question

I m evaluating and looking at using CherryPy for a project that s basically a JavaScript front-end from the client-side  browser  that talks to a Python web service on the back-end  So  I really need something fast and lightweight on the back-end that I can implement using Python that then speaks to the PostgreSQL DB via an ORM  JSON to the browser    I m also looking at Django  which I like  since its ORM is built-in  However  I think Django might be a little more than I really need  i e  more features than I really need    slower     Anyone have any experience with different Python ORM solutions that can compare and contrast their features and functionality  speed  efficiency  etc

User · Answer

I d check out SQLAlchemy   It s really easy to use and the models you work with aren t bad at all  Django uses SQLAlchemy for it s ORM but using it by itself lets you use it s full power   Here s a small example on creating and selecting orm objects   gt  gt  gt  ed user   User  ed    Ed Jones    edspassword    gt  gt  gt  session add ed user   gt  gt  gt  our user   session query User  filter by name  ed   first     gt  gt  gt  our user      lt User  ed   Ed Jones    edspassword   gt

User · Answer

This seems to be the canonical reference point for high-level database interaction in Python  http   wiki python org moin HigherLevelDatabaseProgramming  From there  it looks like Dejavu implements Martin Fowler s DataMapper pattern fairly abstractly in Python

User · Answer

SQLAlchemy is very  very powerful  However it is not thread safe make sure you keep that in mind when working with cherrypy in thread-pool mode

User · Answer

SQLAlchemy s declarative extension  which is becoming standard in 0 5  provides an all in one interface very much like that of Django or Storm   It also integrates seamlessly with classes tables configured using the datamapper style   Base   declarative base    class Foo Base         tablename      foos      id   Column Integer  primary key True   class Thing Base         tablename      things       id   Column Integer  primary key True      name   Column Unicode      description   Column Unicode      foo id   Column Integer  ForeignKey  foos id        foo   relation Foo   engine   create engine  sqlite       Base metadata create all engine     issues DDL to create tables  session   sessionmaker bind engine     foo   Foo   session add foo  thing   Thing name  thing1   description  some thing   thing foo   foo    also adds Thing to session session commit

User · Answer

We use Elixir alongside SQLAlchemy and have liked it so far  Elixir puts a layer on top of SQLAlchemy that makes it look more like the  ActiveRecord pattern  counter parts

User · Answer

I think you might look at   Autumn  Storm

User · Answer

SQLAlchemy is more full-featured and powerful  uses the DataMapper pattern    Django ORM has a cleaner syntax and is easier to write for  ActiveRecord pattern    I don t know about performance differences   SQLAlchemy also has a declarative layer that hides some complexity and gives it a ActiveRecord-style syntax more similar to the Django ORM   I wouldn t worry about Django being  too heavy    It s decoupled enough that you can use the ORM if you want without having to import the rest   That said  if I were already using CherryPy for the web layer and just needed an ORM  I d probably opt for SQLAlchemy

User · Answer

I usually use SQLAlchemy   It s pretty powerful and is probably the most mature python ORM   If you re planning on using CherryPy  you might also look into dejavu as it s by Robert Brewer  the guy that is the current CherryPy project leader    I personally haven t used it  but I do know some people that love it   SQLObject is a little bit easier to use ORM than SQLAlchemy  but it s not quite as powerful   Personally  I wouldn t use the Django ORM unless I was planning on writing the entire project in Django  but that s just me

User · Answer

I used Storm   SQLite for a small project  and was pretty happy with it until I added multiprocessing  Trying to use the database from multiple processes resulted in a  Database is locked  exception  I switched to SQLAlchemy  and the same code worked with no problems

User · Answer

If you re looking for lightweight and are already familiar with django-style declarative models  check out peewee   https   github com coleifer peewee  Example   import datetime from peewee import    class Blog Model       name   CharField    class Entry Model       blog   ForeignKeyField Blog      title   CharField       body   TextField       pub date   DateTimeField default datetime datetime now     query it like django Entry filter blog  name  Some great blog      or programmatically for finer-grained control Entry select   join Blog  where Blog name     Some awesome blog     Check the docs for more examples

User · Answer

Storm has arguably the simplest API   from storm locals import    class Foo        storm table      foos      id   Int primary True    class Thing        storm table      things      id   Int primary True      name   Unicode       description   Unicode       foo id   Int       foo   Reference foo id  Foo id   db   create database  sqlite    store   Store db   foo   Foo   store add foo  thing   Thing   thing foo   foo store add thing  store commit     And it makes it painless to drop down into raw SQL when you need to   store execute  UPDATE bars SET bar name   WHERE bar id like          store commit

User · Answer

There is no conceivable way that the unused features in Django will give a performance penalty  Might just come in handy if you ever decide to upscale the project

[python] What are some good Python ORM solutions?

Examples related to python

Examples related to orm