SQLObject is an object-relational mapper, i.e., a library that will wrap your database tables in Python classes and your rows in Python instances. It currently supports MySQL through the 'MySQLdb' package, PostgreSQL through the 'psycopg' package, SQLite, Firebird, MaxDB (SAP DB), MS SQL, and Sybase. It should support Python versions back to 2.4.
| Tags | Database Software Development Libraries Python Modules |
|---|---|
| Licenses | LGPL |
| Operating Systems | OS Independent |
| Implementation | Python |
Recent releases


Release Notes: PostgresConnection was optimized. SQLObject now uses INSERT...RETURNING id to get the autoincremented ID in one query instead of two (INSERT + SELECT id) (PostgreSQL 8.2 required). SQLObject now generates NCHAR/NVARCHAR and N''-quoted strings for MS SQL.


Release Notes: A bug was fixed in sqlbuilder.Select.filter - a comparison with SQLTrueClause was removed. A number of tests were fixed.


Release Notes: A bug was fixed in sqlbuilder.Select.filter - a comparison with SQLTrueClause was removed. A number of tests were fixed.


Release Notes: This release fixes a minor bug in PostgreSQL introspection: VIEWs don't have PRIMARY KEYs; sqlmeta.idName is used as the key. It fixes a bug in cache handling while unpickling.


Release Notes: This release fixes a minor bug in PostgreSQL introspection: VIEWs don't have PRIMARY KEYs; sqlmeta.idName is used as the key. It fixes a bug in cache handling while unpickling.