Project

General

Profile

WikiStart » History » Revision 39

Revision 38 (Álvaro Herrera, 10/16/2008 11:31 AM) → Revision 39/49 (Álvaro Herrera, 06/22/2010 08:31 AM)

{{>toc}} 

 
 h1. PL/php 


 


 Welcome to the PL/php site. PL/php is a procedural language add-on for PostgreSQL, [[PostgreSQL]], which means you can define PHP functions that run inside a PostgreSQL [[PostgreSQL]] server. 


 


 h2. Obtaining PL/php 


 


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

 <pre> 
 
 svn checkout https://projects.commandprompt.com/public/plphp/repo/trunk 
 </pre> 


 


 h2. Documentation 


 


 Please see the [[InstallDocs|PL/php [[InstallDocs|PLphp Installation procedure]]. procedures]]. 

 Before you can use PL/php, you need to [[CreateLang|create the language]] language] in the database    (In PostgreSQL [[PostgreSQL]] 80 you need [[wikiCreateLang80 [wikiCreateLang80 these instructions instead]]). 

 Usage Documentation: [[Documentation|PL/php [[Documentation|PLphp User Guide]] 


 


 h3. Contributed Documentation 

 


 Ribamar Sousa has also translated this documentation to Portuguese: http://pg.ribafs.net/content/view/29/30/ 

 Ribamar Sousa has also written a tutorial about installing PL/php on Ubuntu and [[PostgreSQL]] 8.3 (in Portuguese): 
 http://pg.ribafs.net/content/view/27/30/ 

 Santiago Zárate has documented the installation for Ubuntu in Spanish: 
 http://blog.santiago.zarate.net.ve/archives/1-Como-instalar-plphp-en-ubuntu-7.04-y-7.10 


 


 h2. Support 
 
 
 

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

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


 


 h2. Release History 


 *10/15/2007* 


 *10/15/2007*: 

 PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3 [[PostgreSQL]] 8.3Beta1 compatibility and named parameters. 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 [[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 [[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 a bug that prevents phpinfo() from working.    It does not 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 [[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.