Re: php with postgres

Added to TODO:

o Add PL/PHP (Joe, Jan)

---------------------------------------------------------------------------

Joe Conway wrote:
> Jan Wieck wrote:
> > I had been briefly talking with Marcus Boerger (included in CC) from the
> > PHP team about it. He knows the PHP5 SAPI embed well. Can you include
> > him into the team (if not already)?
>
> Sure!
>
> > From what I know about this SAPI I think the PL/Tcl implementation
> > would be a good point to start from, as it looks very similar with
> > respect to the possibilities.
>
> I was going to start from PL/R, which is a descendent of PL/Tcl --
> reason being, in PL/R I've already got SRF/table-function support and
> polymorphic argument/return-type support working. Also, I've done a fair
> amount of work to preserve arrays and composite types as they move
> back-and-forth.
>
> My plan is to add a few missing things to PL/R over the next couple (or
> so) weeks, and then start PL/PHP from that:
> 1) Cache lookup based on function oid and argument signature ala the
> patch I recently sent in (and improved by Tom) for PL/pgSQL -- this
> is needed to properly support polymorphic arguments.
> 2) Trigger support -- just haven't needed this so far, but we'll want it
> in PL/PHP, so I may as well add it to PL/R too.
> 3) Re-add nested error handling -- I removed this from PL/R early on
> just to simplify life. Should be easy to drop back in.
>
> I've read some examples posted regarding the PHP embed SAPI, and it
> looks very similar to the R interpreter also. It should be fairly easy
> to drop the PHP embed calls in for the libR calls. The bulk of the work
> will be in modifying the data conversion functions that map Postgres
> composite types and arrays to similar structures in PHP.
>
> Help on the PHP side of things would be most appreciated, because that's
> the part I'm least familiar with.
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073