What are some good Python ORM solutions?

Question :

What are some good Python ORM solutions?,

Answer :

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?).

Read More  How do I find records added to my database table in the past 24 hours?

Anyone have any experience with different Python ORM solutions that can compare and contrast their features and functionality, speed, efficiency, etc.?


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

Read More  How to stop NTFS volume auto-mounting on OS X?

That said, if I were already using CherryPy for the web layer and just needed an ORM, I’d probably opt for SQLAlchemy.

That’s the answer What are some good Python ORM solutions?, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you

Read More  Instrumenting a UI