Product Description

The second 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.

Product Details

• Amazon Sales Rank: #301437 in Books
• Published on: 2005-08-25
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1032 pages

From the Back Cover

The second 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.

About the Author
Korry Douglas is the Director of Research and Development for Appx Software. Over the last two decades he has worked on the design and implementation of an umber of high-level languages and development environments, and his work with a variety of database products (Oracle, Sybase, SQL Server, PostgreSQL, MySQL and mSQL) given him a unique understanding of the commonalities of, and differences between, databases.

Customer Reviews

Very very good
It's a big book. In my experience that either means daunting, or brilliant. This is the latter. Very well written, everything's well explained, and it's easy to skip bits. I've been looking for a kick towards professional database design, (I'd call myself intermediate) from hacked db's in access and mysql - and this is it.

This would help a beginner, (except for the short section on installing it) get used to the basics of sql and databases in general, as well as providing a guide for practical, efficient / effective design. For the expert, this book seemingly covers every individual publicised feature of pgsql, and gives information on extending /customising postgresql from the source for ultimate performance etc.

Unlike my review, the book is extremely well written! Highly recommended. Especially for such a potentially complex topic.

Brilliant!
If you have to do any work involving postgres I cannot recommend this book highly enough!

As a 4th year software engineering student I found this book invaluable in completing my honours dissertation.

As the previous reviewer said, it is very well written and starts with the real basics through to the most complicated issues. However, each chapter is reasonably independent of the last, so it is very easy to jump around different parts of the book without getting lost.

In particular the chapters on accessing postgres using different programming languages such as C, java, and perl are entirely self-contained and are well explained using several examples.

In summary, this is a perfect book for beginners right through to experts, buy it now!

Next to useless
This book is nearly 1,000 pages long and more than 1/2 of this covers "Programming with PostgresSQL". I would have expected more on important database issues such as backup and recovery, performance monitoring and improvement than the few pages on these topics in this book. If you want chapters on how your Perl program (or Python, or PHP, in fact any number of different program types) can connect to a postgres database and do simple data manipulations then this book would he useful. But if your main interest is installing, administration and managing a postgres installation - i.e. you are a DBA, then much of this book is of limited use. The book should have been entitled "PostgresSQL for Developers".