ANN: PyORQ 0.1 - A Python Object-Relational binding

Roeland Rengelink roeland.rengelink@chello.nl
Mon, 21 Jun 2004 14:11:32 +0200


I am pleased to anounce the release of PyORQ 0.1

PyORQ (Python Object Relational binding with Queries) implements 
persistence for Python objects using a relational database (PostgreSQL, 
MySQL, SQLite) for storage.

With PyORQ you can use Python expressions to write queries which are 
automatically translated into SQL and executed by the backend. This 
leverages the search capabilities of RDBMSs in an object-oriented 
programming environment.

PyORQ 0.1 is a technology demo. It's purpose is to demonstrate the 
possibility to translate python expressions into SQL queries and to 
solicit feedback on this approach and its implementation

PyORQ 0.1 features:

o A notation for describing persistent objects, based on Python properties.
o Automatic creation of tables, based on the persistent object definition.
o A native Python notation to describe queries.
o Support for OO-programming (inheritance, encapsulation, polymorphism).
    - Persistent objects may refer to other persistent objects and queries
      understand this.
    - References to objects of a particular type may also refer to
      subclasses of that type.
    - Queries on a type, may return subclasses of that type.
o Interfaces to several SQL backends:
    - PostgreSQL, based on pyPgSQL by Billy G. Allie.
    - MySQL, based on MySQL-Python by Andy Dustman.
    - SQLite, based on PySQLite by Michael Owens and Gerhard Haring
o Bugs (undoubtedly)


PyORQ is hosted on sourceforge and is distributed under a MIT license

Download, tutorial, documentation and implementation notes can be found 
on the PyORQ web site:

http://pyorq.sourceforge.net/

Roeland Rengelink