Gavin Sherry, Alcove Systems Engineering
Date: Tuesday, July 23
Time: 8:45am - 12:15pm
Location: Marina II
PostgreSQL is the most sophisticated open source SQL database in the world, providing to the PHP developer a robust, stable, fast, free and transaction-safe database environment.
Historically, PHP developers have shied away from PostgreSQL, with concerns about performance, complexity and peculiarities in the PostgreSQL PHP interface. In this talk, we will explore these concerns and show why PostgreSQL and PHP will prove to be one of the most important open source software relationships of the future.
In doing so, we will also survey PHP's PostgreSQL interface, looking at the usage of all functions, their arguments and return values tempered by relevant examples for each. We will also look at their rational of using some aspects of the API over others.
The final section of the talk concentrates on advanced use of PHP and PostgreSQL, through two example applications: a full text index search and an application that balances its SQL load across multiple PostgreSQL servers.