Add it to your Download Basket!
Add it to your Watch List!
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.
- LICENSE TYPE:
- LGPL (GNU Lesser General Public License)
- OUR RATING:
- DEVELOPED BY:
- Ian Bicking
- USER RATING:
- ROOT \ Database \ Database APIs
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.
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()
...as well as how you should use the object...
>>> p = Person(fname="John", lname="Doe")
>>> p.mi = 'Q'
>>> p2 = Person.get(1)
>>> 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 Marius Nestor, last updated on January 16th, 2015