Skip site navigation (1) Skip section navigation (2)

PL/Py 0.1 Development Release

From: James William Pye <x(at)jwp(dot)name>
To: pgsql-announce(at)postgresql(dot)org
Subject: PL/Py 0.1 Development Release
Date: 2005-07-01 01:56:02
Message-ID: 1120182962.833.55.camel@localhost (view raw or whole thread)
Lists: pgsql-announce
After much hacking, and many liters of caffeinated beverages, it is my
to announce the first development release of PL/Py, the PostgresPy
Backend elements for the PostgreSQL ORDBMS.

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

PL/Py, PostgresPy's Backend Project, is a procedural language extension
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

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

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
exist, so using the sandbox mentioned in the Quick Start is the best way
discover the features of the PL.


pgsql-announce by date

Next:From: Marc G. FournierDate: 2005-07-01 03:33:55
Subject: Re: [ANNOUNCE] Language to use with SQL database - Number ONE computer
Previous:From: Al_DevDate: 2005-06-30 16:55:21
Subject: Language to use with SQL database - Number ONE computer language - Language Shootout

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group