|
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 PostgreSQLbased 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 commandline 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 programsThe use of PL/pgSQL to write triggers and stored functionsThe installation, configuration, and use of LXP, a tool designed to facilitate development of contentdriven web sites based on PostgreSQLIn 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 databasemanagement 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 longwinded 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 CDROM 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 coowners of Command Prompt, Inc., which specializes in advanced webbased application development. The firms primary efforts are in the development of their PostgreSQL Application Server, LXP.ABOUT THE AUTHORSJohn C. Worsley is the cofounder and lead developer of Command Prompt, Inc, located in idyllic Portland, Oregon. His projects include the LXP ContentManagement Apache module, a variety of DocBookoriented XML utilities, and a host of custom PostgreSQLbased 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.
|
|
|