PHP as a procedural language. yee haw!

Sxooter

For those that don't know, PHP has now been added to the already long list of procedural languages available to PostgreSQL (like tcl, perl, java, C, ruby, and a dozen or so more.)

The home page is here:

http://plphp.commandprompt.com/

And many thanks to Command Prompt for putting forth the labor to do this...

csn

RC1 eh? I'm getting used to plpgsql, but might have to give PHP a try. But isn't plpgsql pretty close to Oracle's plsql (which is probably pretty useful to know)?

I'd never heard of MammothPostgreSQL (lower right corner). Appears to be a replication project/bundle.

Sxooter

Of plphp and plpgsql, plpgsql is by far the more mature of the two, having been written many years ago and thoroughly tested. And yes, it is almost an exact duplicate of Oracle's plsql language. More of a subset really, since I believe there are some minor features it may be missing that Oracle supports.

But you have to admit, the idea of being able to write your stored procs in php (there's a trusted and untrusted version I believe, which runs, of course, the non-safe and safe modes respectively) as well as the front end in the same language is quite appealing.

Mammoth pgsql is command prompts complete pgsql / replication package, all set up and ready to go. And while it costs money, it's a support contract, and there are no licensing limitations (i.e. number of servers or how you use them) put upon the user. pgsq.com has a similar setup.

csn

Originally posted by Sxooter
But you have to admit, the idea of being able to write your stored procs in php (there's a trusted and untrusted version I believe, which runs, of course, the non-safe and safe modes respectively) as well as the front end in the same language is quite appealing.

Absolutely 🙂. I also think it could be a huge selling point for using Postgres instead of Mysql for the PHP/Mysql crowd. Being able to continue using PHP for functions and just having to learn a minimal amount about triggers, etc. will make switching that much more easier.