Project

General

Profile

Edit History

WikiStart » History » Version 40

Álvaro Herrera, 06/22/2010 08:32 AM

1 1 





    2
    38
    Álvaro Herrera
    
h1. PL/php





    3
    1
    
    





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





    5
    39
    Álvaro Herrera
    





    6
    40
    Álvaro Herrera
    
{{>toc}}





    7
    38
    Álvaro Herrera
    





    8
    40
    Álvaro Herrera
    
h1. Obtaining PL/php





    9
    38
    Álvaro Herrera
    





    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
    
    
    
</pre>





    16
    
    
    





    17
    
    
    





    18
    40
    Álvaro Herrera
    
h1. Documentation





    19
    1
    
    





    20
    
    
    





    21
    39
    Álvaro Herrera
    
Please see the [[InstallDocs|PL/php Installation procedure]].





    22
    34
    Álvaro Herrera
    





    23
    39
    Á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
    1
    
    





    25
    39
    Álvaro Herrera
    
Usage Documentation: [[Documentation|PL/php User Guide]]





    26
    1
    
    





    27
    38
    Álvaro Herrera
    





    28
    40
    Álvaro Herrera
    
h2. Contributed Documentation





    29
    38
    Álvaro Herrera
    





    30
    39
    Álvaro Herrera
    
Ribamar Sousa has translated this documentation to Portuguese: http://pg.ribafs.net/content/view/29/30/





    31
    1
    
    





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





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





    34
    
    
    





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





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





    37
    36
    Álvaro Herrera
    





    38
    38
    Álvaro Herrera
    





    39
    40
    Álvaro Herrera
    
h1. Support





    40
    1
    
    
 





    41
    39
    Álvaro Herrera
    
You can join the mailing list: http://lists.commandprompt.com/mailman/listinfo/plphp





    42
    1
    
    





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





    44
    1
    
    





    45
    34
    Álvaro Herrera
    





    46
    40
    Álvaro Herrera
    
h1. Release History





    47
    38
    Álvaro Herrera
    





    48
    1
    
    





    49
    39
    Álvaro Herrera
    
*10/15/2007*





    50
    1
    
    





    51
    39
    Álvaro Herrera
    
PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3 compatibility and named parameters.





    52
    1
    
    





    53
    
    
    
----





    54
    
    
    





    55
    39
    Á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.





    56
    38
    Álvaro Herrera
    





    57
    
    
    
----





    58
    39
    Álvaro Herrera
    





    59
    13
    Á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.





    60
    39
    Álvaro Herrera
    





    61
    3
    Álvaro Herrera
    
----





    62
    39
    Álvaro Herrera
    





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





    64
    39
    Álvaro Herrera
    





    65
    17
    bford -
    
----





    66
    39
    Álvaro Herrera
    





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