Project

General

Profile

WikiStart » History » Revision 35

Revision 34 (Álvaro Herrera, 10/16/2008 08:36 AM) → Revision 35/49 (Álvaro Herrera, 10/16/2008 08:54 AM)

= PL/php Trac = 

 Welcome to the PL/php Trac site. PL/php This site is designed to help us foster a procedural language add-on for PostgreSQL, which means you can define PHP functions that run inside a PostgreSQL server. community around PL/php. Recently, PL/php has started seeing more development, and we have recently started releasing new versions. 

 == Obtaining PL/php == 

 Please see the [wiki:Downloads] page. Or you can get the latest sources using anonymous svn access: 

 {{{ 
 svn checkout https://projects.commandprompt.com/public/plphp/repo/trunk 
 }}} 

 == 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] 

 === Contributed Documentation === 
 Ribamar Sousa has written a tutorial about installing PL/php on Ubuntu and PostgreSQL 8.3 (in Portuguese): 
 http://pg.ribafs.net/content/view/29/30/ 

 == 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. 


 == Release History == 

 '''10/15/2007''': 

 PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3Beta1 compatibility and named parameters 

 ---- 

 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 is virtually identical to 1.2.    There is has been sitting here for a bug that prevents phpinfo() from working.    It 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. 
 

 ---- 
 

 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. 



 == Obsolete Documentation == 

 [wiki:InstallDocs10 PL/php 1.0 Installation Procedures]