PL/php 1.1 released

I'm pleased to announce the release of PL/php version 1.1, the PHP
procedural language for PostgreSQL.


What's in the 1.1 release:

- The build system no longer requires the PHP nor PostgreSQL sources.
  It uses PGXS, making it all much easier to build compared to the
  original 1.0 release.

- Rudimentary SPI support, meaning you can send queries to the server
  and get/process the results.

- Trigger support: you can write trigger functions, including the
  ability to abort or skip an operation, or modifying the tuple before
  insert/update.

- Function validation: PL/php will tell you right away if the function
  you are creating has a syntax error, and abort the creation, so no
  invalid functions make it into the database.

- You will receive any errors and warnings that PHP generates while
  executing your function.

PL/php 1.1 only works with PostgreSQL 8.0 and 8.1.  It has been tested
with PHP 4.4.1 only, but it should work with PHP 5 as well.

PL/php 1.1 can be downloaded from the Trac page.  The documentation
lives there as well, as a Wiki.
http://projects.commandprompt.com/projects/public/plphp


Differences from the original 1.0 release include:

- Error messages and warnings are passed from PHP to Postgres instead of
  being silently dropped.
- No more memory leaks in SPI functions.
- SPI results are now an opaque PHP resource, so it's no longer possible
  to crash the server by modifying it.
- Memory handling has been overhauled.  There are no known memory leaks.
  Huge SPI results can be processed.
- SRF support has been removed.  It will be added again in the next
  release.  The previous version was found to be too buggy and poorly
  thought-out.
- A private symbol table is created for each function, which facilitates
  the process of releasing memory used by the function.  This symbol
  table is cleared after each call.


For a quick glance of (to? into?) our release plan, please have a look
at the Roadmap in our Trac page:
http://projects.commandprompt.com/projects/public/plphp/roadmap


Please report any issues as a Ticket in the Trac page:
http://projects.commandprompt.com/projects/public/plphp/newticket

Expect a 1.2 release shortly, which will include SRF support.

--
Alvaro Herrera                                http://www.PlanetPostgreSQL.org
"I'm always right, but sometimes I'm more right than other times."
                                                  (Linus Torvalds)