Session
Introduction to PL/PHP
Robert Treat, DBA, PostgreSQL Community
Track: PHP
Date: Thursday, July 26
Time: 5:20pm
- 6:05pm
Location: D135
You've heard the talk about custom programming inside the database, but for PHP developers the only way to take advantage of it was through either learning a new database only syntax like PL/SQL or PSM, or by forcing yourself to use some other language like Java. That is until PL/PHP. PL/PHP is a PostgreSQL procedural language that allows you to take advantage of all the power of programming on the database side while sticking to the friendly confines of the PHP language.
This talk will cover everything you need to know to get started with PL/PHP including:
- how to install PL/PHP language into your database
- syntax of creating a simple function
- what untrusted functions are
- writing trigger functions in PL/PHP
- how to query and manipulate other tables inside functions
By the end of the discussion, attendees will have seen many examples of PL/PHP functions and be able to start writing their own functions.