Extend PostgreSQL and integrate the database layer into your development framework
Learn how to work with PostgreSQL as if you spent the last decade working on it. PostgreSQL is capable of providing you with all of the options that you have in your favourite development language and then extending that right on to the database server. With this knowledge in hand, you will be able to more » respond to the current demand for advanced PostgreSQL skills in a lucrative and booming market.
PostgreSQL Server Programming will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery and a host of other features that the PostgreSQL engine provides. « less
A Practical Guide to the Advanced Open Source Database
If you're thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL's unique features. Not only will you learn about the enterprise class features in the 9.2 release, you'll also discover that PostgeSQL more » is more than just a database system - itэs also an impressive application platform.
With numerous examples throughout this book, you'll learn how to achieve tasks that are difficult or impossible in other databases. If you're an existing PostgreSQL user, you'll pick up gems you may have missed along the way. « less
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.
PostGIS in Action teaches readers more » of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-based GIS and then quickly moves into analyzing, viewing, and mapping data. « less
Over 80 recipes to help you run an efficient PostgreSQL 9.0 database
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 more » and when to VACUUM your databases; Selecting and implementing robust backup techniques; Concise and clear guidance on replication and high availability. « less
Accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down
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; more » 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 « less
From Novice to Professional
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. more » 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. « less
From Novice to Professional
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.
Each chapter more » is devoted to a specific new feature. You'll learn how to build an online product catalog complete with pagination features, shopping cart, checkout mechanism, product search feature, product recommendations, administrative features, customer accounts, an order-management system, and more. « less
From Novice to Professional
Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn more » all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity.
The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. « less
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 more » 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. « less
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world more » guide to understanding and working with this complex yet essential system. « less