[Tutor] when is object relational mapping for Python warranted?

Che M pine508 at hotmail.com
Wed Jun 18 21:07:43 CEST 2008

Thank you both to Tim Golden and Jeff Younker for your helpful
responses last week [see archive] about ORMs in Python/SQLite.  Very
helpful, and I'll get around to giving it a try one of these days...


From: pine508 at hotmail.com
To: tutor at python.org
Subject: when is object relational mapping for Python warranted?
Date: Wed, 11 Jun 2008 02:23:13 -0400

(tried to write a descriptive subject line)

I'm curious whether I should consider learning either SQLObject 
or SQLAlchemy, and whether my needs would be worth it.  I am
learning to use SQlite databases for fairly simple storage and later
search, and have only recently learned about object relational
mapping (ORM).  "Fairly simple" = 4-6 tables with no more than
2-10 fields each, 100-5,000 records, with queries doing basic LIKE 
and other matches, nothing fancy.

I'd like to hear opinions on when it is worth it to use these ORM tools
for a Python database application, that is, in terms of the complexity
of the database or queries or the application, or when basic Python 
and SQL is sufficient.  It's a personal preference, I'm sure, but I just 
wanted to get some opinions.  Also, if there is an opinion about either 
of these two ORMs in terms of learning curve, quality, etc.


It’s easy to add contacts from Facebook and other social sites through Windows Live™ Messenger. Learn How.

Need to know now? Get instant answers with Windows Live Messenger.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20080618/cbd50709/attachment.htm>

More information about the Tutor mailing list