Practical PostgreSQL (O'Reilly Unix)

Features

• Cover Type: Paperback with 636 pages
• Published by: O'Reilly Media, Inc.; Pap/Cdr edition January 2002
• Written in: English
• ISBN 10 Number: 1565928466
• ISBN 13 Number: 978-1565928466
• Book Dimensions: 9.2 x 7.1 x 1.2 inches
• Weighs: 2 pounds

Book Description
Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage. This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft. Also included is a CD-ROM with Command Prompt's PostgreSQL Application Server, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.

Book Info
Comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. Discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft. Softcover. CD-ROM included.

Reader Reviews
This is an excellent book to begin learning about the most advanced open source database available, it covers the theory and history of PostgreSQL and includes instructions on installing the database server. The authors clearly explain the topics covered in the book, I've given the book to several co-workers who were interested in the book and they also view it favorably. I recommend this book to the person interested in learning more about PostgreSQL or the person who has never used a database server before. This book does not get into the advanced features of PostgreSQL but all in all this is a quality reference and handbook, perhaps better named as Learning PostgreSQL. Comment | | (Report this)