Projects / SQLObject

SQLObject

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
Licenses
Operating Systems
Implementation

RSS Recent releases

  •  18 May 2013 11:04

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.

  •  20 Oct 2012 11:23

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

  •  20 Oct 2012 11:23

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

  •  25 May 2012 21:53

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.

  •  25 May 2012 21:53

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.

Screenshot

Project Spotlight

slackroll

A package or upgrade manager for Slackware Linux.

Screenshot

Project Spotlight

Jodd

A general-purpose Java library.