Project

General

Profile

Edit History

WikiStart » History » Version 37

Álvaro Herrera, 10/16/2008 11:31 AM

1 36 Álvaro Herrera 
= PL/php =
2 1 





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





    4
    1
    
    





    5
    34
    Álvaro Herrera
    
== Obtaining PL/php ==





    6
    
    
    





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





    8
    
    
    





    9
    32
    Álvaro Herrera
    
{{{





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





    11
    1
    
    
}}}





    12
    
    
    





    13
    34
    Álvaro Herrera
    
== Documentation ==





    14
    
    
    





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





    16
    
    
    





    17
    
    
    
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]).





    18
    
    
    





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





    20
    1
    
    





    21
    
    
    
=== Contributed Documentation ===





    22
    36
    Álvaro Herrera
    





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





    24
    
    
    





    25
    1
    
    
Ribamar Sousa has written a tutorial about installing PL/php on Ubuntu and PostgreSQL 8.3 (in Portuguese):





    26
    36
    Álvaro Herrera
    
http://pg.ribafs.net/content/view/27/30/





    27
    1
    
    





    28
    36
    Álvaro Herrera
    
Santiago Zárate has documented the installation for Ubuntu in Spanish:





    29
    
    
    
http://blog.santiago.zarate.net.ve/archives/1-Como-instalar-plphp-en-ubuntu-7.04-y-7.10





    30
    
    
    





    31
    34
    Álvaro Herrera
    
== Support == 





    32
    
    
    





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





    34
    
    
    





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





    36
    
    
    





    37
    
    
    
== Release History ==





    38
    
    
    





    39
    30
    bford -
    
'''10/15/2007''':





    40
    26
    bford -
    





    41
    19
    bford -
    
PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3Beta1 compatibility and named parameters





    42
    13
    Álvaro Herrera
    





    43
    
    
    
----





    44
    
    
    





    45
    1
    
    
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.





    46
    3
    Álvaro Herrera
    





    47
    34
    Álvaro Herrera
    
----





    48
    35
    Álvaro Herrera
    
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.





    49
    16
    bford -
    
----





    50
    17
    bford -
    
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.





    51
    34
    Álvaro Herrera
    
----





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