Project

General

Profile

WikiStart » History » Version 32

Álvaro Herrera, 10/16/2008 07:53 AM

1 4 Álvaro Herrera
= PL/php Trac =
2 1
3 32 Álvaro Herrera
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:
4
5
{{{
6
svn checkout https://projects.commandprompt.com/public/plphp/repo/trunk
7
}}}
8 1
9 23 Alexey Klyukin
----
10 28 bford -
'''10/15/2007''':
11 25 bford -
12 30 bford -
PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3Beta1 compatibility and named parameters
13 26 bford -
14
----
15 25 bford -
16 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.
17 23 Alexey Klyukin
18
----
19
20 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:
21
22
{{{
23
CREATE OR REPLACE FUNCTION test_func() RETURNS text $$
24
25
RETURN phpinfo();
26
27
$$ LANGUAGE 'plphp';
28
}}}
29
30
It will result in an execution timeout.
31
32
We also do not currently support in/out parameters but it is on the list.
33
34
----
35
36
37 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.
38
39
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.
40 1
41 3 Álvaro Herrera
== Available Documentation ==
42 1
43 14 Álvaro Herrera
Please see the [wiki:InstallDocs PL/php Installation procedures].
44 5 Álvaro Herrera
45 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]).
46
47 1
Usage Documentation: [wiki:Documentation PL/php User Guide]
48
49 31 Alexey Klyukin
== Community Documentation ==
50
Ribamar Sousa has written a tutorial about installing PL/php on Ubuntu and PostgreSQL 8.3 (in Portuguese):
51
http://pg.ribafs.net/content/view/29/30/
52
53 18 Álvaro Herrera
== Gotchas ==
54
55 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].
56 18 Álvaro Herrera
57 15 bford -
== Support == 
58
59 20 bford -
You can join the [http://lists.commandprompt.com/mailman/listinfo/plphp mailing list] .
60 16 bford -
61 17 bford -
Or you can reach us on Freenode at the '''#plphp''' channel.
62 15 bford -
63 1
== Downloads ==
64
65
Please refer to the [wiki:Downloads] page.
66 14 Álvaro Herrera
67
== Obsolete Documentation ==
68
69
[wiki:InstallDocs10 PL/php 1.0 Installation Procedures]