PL/php

= PL/php Trac =

Welcome to the PL/php Trac site. This site is designed to help us foster a community around PL/php. Recently, PL/php has started seeing more development, and we have recently started releasing new versions. Please see the [wiki:Downloads] page. You can get the latest sources using anonymous svn access from http://projects.commandprompt.com/public/plphp/repo

---

PL/php 1.3.3 addresses the previous phpinfo() issue as well as a bunch of others, particulary improper handling of columns with numeric names, random backend crashes etc. This is the first PL/php version with PostgreSQL 8.2 support, and autoconf/configure scripts replacing the need to edit the project's Makefile directly. It still has issues with threaded PHP build, so I recommend not using --enable-maintainer-zts when configuring your PHP library. Except for this it successfully passed all regression tests with PostgreSQL 8.2 and PHP 5.

---

PL/php 1.3 was released on 2006-07-14. It has been sitting here for a while and works pretty well. The following we know does not work:

{{{
CREATE OR REPLACE FUNCTION test_func() RETURNS text $$

RETURN phpinfo();

$$ LANGUAGE 'plphp';
}}}

It will result in an execution timeout.

We also do not currently support in/out parameters but it is on the list.

---

PL/php 1.2 was released on 2005-12-13. This version adds SRF (Set-Returning Function) support. It is also an attempt to make the build system a bit more independent of your actual setup. In order to build it, you need to have the apxs program somewhere in your path. Please report any incompatibility.

PL/php 1.1 was released on 2005-12-05. This version is much cooler than the previous one because you don't have to patch PostgreSQL nor PHP sources -- actually, you don't even need those sources, so it's much easier to install than the previous 1.0 version. This is the first release since I (Ãlvaro Herrera) took maintainership of PL/php.

Available Documentation

Please see the [wiki:InstallDocs PL/php Installation procedures].

Before you can use PL/php, you need to [wiki:CreateLang create the language] in the database. (In PostgreSQL 8.0 you need [wiki:CreateLang80 these instructions instead]).

Usage Documentation: [wiki:Documentation PL/php User Guide]

Gotchas

The current design of PL/php is not really very portable, as it depends on the Apache PHP SAPI. In practice, this means that PL/php is not very likely to compile or run on non-Linux platforms, or even on non-stock Linux platforms. Please see the [http://lists.commandprompt.com/pipermail/plphp/ mailing list archives].

Support

You can join the [http://lists.commandprompt.com/mailman/listinfo/plphp mailing list] .

Or you can reach us on Freenode at the '''#plphp''' channel.

Downloads

Please refer to the [wiki:Downloads] page.

Obsolete Documentation

[wiki:InstallDocs10 PL/php 1.0 Installation Procedures]