SQLObject 2.1.0

An Open Source and free ORM (Object Relational Manager) application written in Python

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in SQLObject 2.1.0:

  • Minor features:
  • In queries generated with SQLObject's tables columns are sorted in the order they are declared in the table.
  • In queries generated with sqlbuilder's Insert/Update, if values are passed using dictionaries, columns are sorted alphabetically.
Read full changelog
send us
an update
LGPL (GNU Lesser General Public License) 
Ian Bicking
2.4/5 20
ROOT \ Database \ Database APIs
1 SQLObject Screenshot:
SQLObject is a widely used, freely distributed and open source ORM (Object Relational Manager), also known as database wrapper, implemented in Python and designed to be used as an object interface to a database, with tables as classes, columns as attributes and rows as instances.

The software comes with a Python-object-based query language, which will be used by develoopers to provide considerable database independence to all applications, as well as to make SQL more abstract.

Supports all major database servers/engines

Another interesting feature of the SQLObject project, is that it supports all major database servers and database engines, including the well known MySQL, PostgreSQL, Firebird, SQLite, Microsoft SQL Server, MaxDB (SAPDB), and Sybase. It is compatible with both Python 2.6 or 2.7 programming languages.

Mandatory example

The following lines of code will show Python/SQL developers who the SQLObject software works...

>>> from sqlobject import *
>>> sqlhub.processConnection = connectionForURI('sqlite:/:memory:')
>>> class Person(SQLObject):
... fname = StringCol()
... mi = StringCol(length=1, default=None)
... lname = StringCol()
>>> Person.createTable()

...as well as how you should use the object...

>>> p = Person(fname="John", lname="Doe")
>>> p
>>> p.fname

>>> p.mi = 'Q'
>>> p2 = Person.get(1)
>>> p2
>>> p is p2


Runs on any operating system supported by Python

Being written in Python, SQLObject is cross-platform, supported on all operating systems where Python 2.6 and Python 2.7 are available, including all GNU/Linux distributions, as well as the Microsoft Windows and Mac OS X OSes.

It easy easily installable from either its source package, using the ‘sudo python setup.py install’ command in the root folder, or easy_install, using the ‘easy_install -U SQLObject’ command, in a terminal emulator application.

The software has been successfully tested with computers supporting either of the 32 or 64-bit instruction set architectures. For more details, please check its official website (see the homepage link below).

SQLObject was reviewed by , last updated on January 16th, 2015


#Object Relational Manager #object interface #SQL object #ORM #object #relational #manager

Add your review!