Beginning PHP and PostgreSQL 8 delves into some of the most popular open-source web development technologies, the PostgreSQL 8 database server and PHP 5 scripting language. You’ll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. This is an ideal read if you are a web designer, programmer, hobbyist, or novice who wants to create applications with PHP 5 and PostgreSQL 8.
The PHP language and PostgreSQL database server have long offered an ideal blend of practicality and power for both the novice and experienced programmer alike. Yet the continued evolution of both technologies makes them better suited to drive enterprise-class applications than ever before.
PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing you to create location-aware queries with just a few lines of SQL code, and provides a back-end for mapping applications with minimal effort.
How to implement PostgreSQL features for reliability and performance, How to use the latest PostgreSQL 9.0 features, Summaries to help DBAs with experience of other database systems, Advanced technical tips and scripts for experienced users, Best practice for planning and designing live databases, How and when to VACUUM your databases, Selecting and implementing robust backup techniques, Concise and clear guidance on replication and high availability.
PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world’s most popular server databases with an enviable reputation for performance and stability and an enormous range of advanced features.