| |
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 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 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. ISBN 9788173663925
|
| |
Pages : 642
|