ANN: PL/Py 0.1 Release



After much hacking, and many liters of caffeinated beverages, it is my
pleasure to announce the first development release of PL/Py, the
PostgresPy Project[1]'s Backend elements for the PostgreSQL ORDBMS.

The very terse project news item can be found here[2].

PL/Py, PostgresPy's Backend Project, is a procedural language extension for
PostgreSQL, and a Python extension module providing Python interfaces to
PostgreSQL internals. It provides a PostgreSQL DBA with the necessary
functionality to create and execute functions written in Python within the
backend.

It has been designed with the principle of separating the embedding
instance from the extension module(interfaces), so as to provide
a very clean implementation.

The PL features the following:
* Set Returning Functions.
* State keeping (think generators, etc, yes even for SRFs!).
* Type system interface (Single dimensional arrays and Composites).
* Direct Database Function Calls.
* Objectified Queries.
* Exception management and interfaces.
* Encoding Choreography (Works with the Database's encoding).
* HeapTuple/TupleDesc interface types.
* Transaction Dictionary.
* Direct Portal interface.
* Internal Subtransactions.
* file like Large Object interface.
* Full tracebacks and exception information in uncaught exceptions.
* Procedure validation (Syntax check on CREATE and Code storage).
* Direct Relation interface (coming soon).
* Boogs. Yes, there are bugs.

For the quickest way to get started, see the Quick Start page[3].

The documentation for this project has yet to be completed. Some doc-strings
exist, so using the sandbox mentioned in the Quick Start is the best way to
discover the features of the PL.

[1] http://python.projects.postgresql.org
[2] http://pgfoundry.org/forum/forum.php?forum_id=449
[3] http://python.projects.postgresql.org/quick.html
.



Relevant Pages

  • Re: gforth webserver, why isnt forth used all over ecommerce?
    ... you can use near any language to program for the web. ... First, you need regular expressions, they're near universal. ... PostgreSQL interface to a Forth language. ...
    (comp.lang.forth)
  • Re: Filemaker/Access Linux alternative
    ... PostgreSQL comes with a built-in CHUI interface. ... for a play-by-email game, Python and PostgreSQL on the back end, PHP ... *can* use the existing CHUI tools, ...
    (comp.os.linux.misc)
  • Re: OT: MySQL book recommendation for a newbie?
    ... I know nothing about databases and I'd like to start somewhere. ... > how to use it and how to interface with it for a project that I need to do, ... This is PostgreSQL, which has transaction support and other very useful ... MySQL and PostgreSQL, so you have to choose which is best for you - ...
    (comp.unix.bsd.openbsd.misc)
  • install_driver(Pg) failed: Cant load Pg.so
    ... I'm getting the following error when attempting to interface through my web browser, immediately after supplying the login information. ...
    (perl.dbi.users)
  • Re: pro- foreign key propaganda?
    ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
    (comp.databases.theory)