[ANN] SQLObject 0.6.1

Ian Bicking ianb at colorstudy.com
Wed Jan 26 00:55:21 EST 2005

SQLObject 0.6.1

Version 0.6.1 is a bug fix release for 0.6.  Most of the work on this
release has been thanks to the contributions of Oleg Broytmann.
Thanks Oleg!

A brief list of changes:

* All class methods take a connection argument.
* "DISTINCT" option for select results.
* Connection objects have a new module attribute, to get access to the
   connection's exceptions.
* New UnicodeCol() for encoding and decoding values from the database.
* Added Indexing (patch from Jeremy Fitzhardinge).
* Database connections explicitly closed, instead of just letting them
   be garbage collected.
* selectBy can take be called with instances instead of only IDs for
   foreign key columns.
* DBMConnection was removed (it's been broken a long time).

What Is SQLObject?

SQLObject is an Object-Relational Mapper.  Basically it makes your
database rows feel like (relatively) normal Python objects: Tables are
classes, rows are instances, columns are attributes.

SQLObject both allows you to define your classes in Python, and
SQLObject will create the tables on your behalf, or SQLObject may use
database reflection to dynamically create a class given a table name.
SQLObject portably supports a variety of database backends: MySQL,
PostgreSQL, SQLite, Firebird, MaxDB/SAPDB, and SyBase.

SQLObject is being used in a variety of external projects:
ezSQLObject, sqlo for Zope 3, and Subway (a Ruby on Rails clone),
among others.

Where Is SQLObject?

Subversion repository:
Mailing list:

Ian Bicking  /  ianb at colorstudy.com  / http://blog.ianbicking.org

More information about the Python-list mailing list