Project

General

Profile

Edit History

WikiStart » History » Version 38

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

1 1 





    2
    38
    Álvaro Herrera
    
h1. PL/php





    3
    1
    
    





    4
    
    
    





    5
    38
    Á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.





    6
    1
    
    





    7
    38
    Álvaro Herrera
    





    8
    
    
    
h2. Obtaining PL/php





    9
    
    
    





    10
    
    
    





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





    12
    
    
    





    13
    
    
    
<pre>





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





    15
    38
    Álvaro Herrera
    
</pre>





    16
    1
    
    





    17
    
    
    





    18
    38
    Álvaro Herrera
    
h2. Documentation





    19
    1
    
    





    20
    34
    Álvaro Herrera
    





    21
    38
    Álvaro Herrera
    
Please see the [[InstallDocs|PLphp Installation procedures]].





    22
    34
    Álvaro Herrera
    





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





    24
    36
    Álvaro Herrera
    





    25
    38
    Álvaro Herrera
    
Usage Documentation: [[Documentation|PLphp User Guide]]





    26
    
    
    





    27
    
    
    





    28
    
    
    
h3. Contributed Documentation





    29
    
    
    





    30
    
    
    





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





    32
    
    
    





    33
    38
    Álvaro Herrera
    
Ribamar Sousa has written a tutorial about installing PL/php on Ubuntu and [[PostgreSQL]] 8.3 (in Portuguese):





    34
    1
    
    
http://pg.ribafs.net/content/view/27/30/





    35
    
    
    





    36
    
    
    
Santiago Zárate has documented the installation for Ubuntu in Spanish:





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





    38
    
    
    





    39
    36
    Álvaro Herrera
    





    40
    38
    Álvaro Herrera
    
h2. Support





    41
    
    
    
 





    42
    34
    Álvaro Herrera
    





    43
    38
    Álvaro Herrera
    
You can join the "mailing list":http://lists.commandprompt.com/mailman/listinfo/plphp.





    44
    1
    
    





    45
    38
    Álvaro Herrera
    
Or you can reach us on Freenode at the *#plphp* channel.





    46
    34
    Álvaro Herrera
    





    47
    
    
    





    48
    38
    Álvaro Herrera
    
h2. Release History





    49
    34
    Álvaro Herrera
    





    50
    38
    Álvaro Herrera
    





    51
    
    
    
*10/15/2007*:





    52
    
    
    





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





    54
    
    
    





    55
    13
    Álvaro Herrera
    
----





    56
    
    
    





    57
    38
    Álvaro Herrera
    
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.





    58
    3
    Álvaro Herrera
    





    59
    34
    Álvaro Herrera
    
----





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





    61
    16
    bford -
    
----





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





    63
    34
    Álvaro Herrera
    
----





    64
    38
    Álvaro Herrera
    
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.