Practical Postgresql, (book/cd-rom)

PostgreSQL is perhaps the most robust and capable of all the open source databases. Authors John C. Worsley and Joshua D. Drake provide this practical guide to using PostgreSQL based on their many years of experience providing PostgreSQL-based solutions to their clients.

Early chapters of Practical PostgreSQL introduce PostgreSQL and take you quickly through the process of obtaining the PostgreSQL software and installing it on your system. Youll learn about psql, the PostgreSQL command-line interface, and all the basic SQL features PostgreSQL supports.

Later chapters take you through advanced topics, such as:

• The use of JDBC to access PostgreSQL databases from Java programs
  
• The use of PL/pgSQL to write triggers and stored functions
  
• The installation, configuration, and use of LXP, a tool designed to facilitate development of content-driven web sites based on PostgreSQL

In addition, youll learn how to back up and recover a PostgreSQL database, how to manage database users, how to create new databases, how to start and stop databases, and a host of other database-management tasks. The book ends with a comprehensive PostgreSQL command reference.

Throughout Practical PostgreSQL, the emphasis is on the practical. John and Joshua dont waste your time with long-winded or overly simplistic explanations. They get right to the point and show you how to successfully use PostgreSQL as a backend database.

Also included is a CD-ROM with Command Prompts PostgreSQL Application Server, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.

John C.Worsley and Joshua D. Drake are co-owners of Command Prompt, Inc., which specializes in advanced web-based application development. The firms primary efforts are in the development of their PostgreSQL Application Server, LXP.

About the Authors
John C. Worsley is the co-founder and lead developer of Command Prompt, Inc, located in idyllic Portland, Oregon. His projects include the LXP Content-Management Apache module, a variety of DocBook-oriented XML utilities, and a host of custom PostgreSQL-based solutions.

Joshua D. Drake is cofounder of Command Prompt, Inc., a PostgreSQL and Linux custom development company. He is also the current author of the Linux Networking HOWTO, Linux PPP HOWTO, and Linux Consultants HOWTO.