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.
The 2nd edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.
Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. Discover the techniques used to scale successful database installations. Avoid the common pitfalls that can slow your system down. Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you’ve learned into a production database environment. Learn best practices culled from years of work scaling PostgreSQL installations to handle demanding applications
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.
Beginning Databases with PostgreSQL, 2nd Edition (Preview)