Project

General

Profile

Edit History

WikiStart » History » Version 31

Alexey Klyukin, 07/24/2008 06:15 AM
Added community documentation section.

1 4 Álvaro Herrera 
= PL/php Trac =
2 1 





    3
    29
    bford -
    
Welcome to the PL/php Trac site. This site is designed to help us foster a community around PL/php. Recently, PL/php has started seeing more development, and we have recently started releasing new versions.  Please see the [wiki:Downloads] page. You can get the latest sources using anonymous svn access from https://projects.commandprompt.com/public/plphp/repo





    4
    1
    
    





    5
    23
    Alexey Klyukin
    
----





    6
    28
    bford -
    
'''10/15/2007''':





    7
    25
    bford -
    





    8
    30
    bford -
    
PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3Beta1 compatibility and named parameters





    9
    26
    bford -
    





    10
    
    
    
----





    11
    25
    bford -
    





    12
    24
    Alexey Klyukin
    
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.





    13
    23
    Alexey Klyukin
    





    14
    
    
    
----





    15
    
    
    





    16
    19
    bford -
    
PL/php 1.3 was released on 2006-07-14. It has been sitting here for a while and works pretty well. The following we know does not work:





    17
    
    
    





    18
    
    
    
{{{





    19
    
    
    
CREATE OR REPLACE FUNCTION test_func() RETURNS text $$





    20
    
    
    





    21
    
    
    
RETURN phpinfo();





    22
    
    
    





    23
    
    
    
$$ LANGUAGE 'plphp';





    24
    
    
    
}}}





    25
    
    
    





    26
    
    
    
It will result in an execution timeout.





    27
    
    
    





    28
    
    
    
We also do not currently support in/out parameters but it is on the list.





    29
    
    
    





    30
    
    
    
----





    31
    
    
    





    32
    
    
    





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





    34
    
    
    





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





    36
    1
    
    





    37
    3
    Álvaro Herrera
    
== Available Documentation ==





    38
    1
    
    





    39
    14
    Álvaro Herrera
    
Please see the [wiki:InstallDocs PL/php Installation procedures].





    40
    5
    Álvaro Herrera
    





    41
    9
    Álvaro Herrera
    
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]).





    42
    
    
    





    43
    1
    
    
Usage Documentation: [wiki:Documentation PL/php User Guide]





    44
    
    
    





    45
    31
    Alexey Klyukin
    
== Community Documentation ==





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





    47
    
    
    
http://pg.ribafs.net/content/view/29/30/





    48
    
    
    





    49
    18
    Álvaro Herrera
    
== Gotchas ==





    50
    
    
    





    51
    21
    bford -
    
The current design of PL/php is not really very portable, as it depends on the Apache PHP SAPI.  In practice, this means that PL/php is not very likely to compile or run on non-Linux platforms, or even on non-stock Linux platforms.  Please see the [http://lists.commandprompt.com/pipermail/plphp/ mailing list archives].





    52
    18
    Álvaro Herrera
    





    53
    15
    bford -
    
== Support == 





    54
    
    
    





    55
    20
    bford -
    
You can join the [http://lists.commandprompt.com/mailman/listinfo/plphp mailing list] .





    56
    16
    bford -
    





    57
    17
    bford -
    
Or you can reach us on Freenode at the '''#plphp''' channel.





    58
    15
    bford -
    





    59
    1
    
    
== Downloads ==





    60
    
    
    





    61
    
    
    
Please refer to the [wiki:Downloads] page.





    62
    14
    Álvaro Herrera
    





    63
    
    
    
== Obsolete Documentation ==





    64
    
    
    





    65
    
    
    
[wiki:InstallDocs10 PL/php 1.0 Installation Procedures]