PostgreSQL Essential Reference by Barry Stinson, Paperback | Barnes & Noble
PostgreSQL Essential Reference

PostgreSQL Essential Reference

4.0 1
by Barry Stinson
     
 

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL.
The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a

Overview

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL.
The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product.
An added advantage to this book is that provides all reference material in two ways; alphabetically and by task. This is important because readers of the book will be looking for this information by both methods.

Editorial Reviews

bn.com
The Barnes & Noble Review
PostgreSQL is gaining momentum as a powerful, speedy open-source database alternative for a wide range of applications, Web and otherwise. Of course, every database worth its salt needs a detailed reference -- and PostgreSQL now has one: PostgreSQL Essential Reference by Barry Stinson.

Designed for every PostgreSQL database developer and system administrator, this book assumes you've already picked up the fundamentals of databases and SQL somewhere and focuses on helping you leverage your knowledge in the PostgreSQL environment.

This concise, complete book is organized for rapid access. All reference material is organized alphabetically and by task. Stinson begins with a complete SQL reference, describing how PostgreSQL's variant of SQL supports the SQL-92 standard -- and how it doesn't. For each SQL command, Stinson presents syntax, options, examples, and any specific issues you need to know about in migrating to PostgreSQL from your existing database environment. In some cases, PostgreSQL has SQL commands that have no direct counterpart in the standard: here, Stinson points you to the nearest equivalent.

Part II of PostgreSQL Essential Reference moves on to several key features of the PostgreSQL database implementation. Data types, operators, and functions are all covered systematically. Stinson then moves on to several concepts and features that are unique to PostgreSQL -- notably, the use of arrays in fields, inheritance, object identifiers, and Multiversion Concurrency Control (MVCC), as well as PostgreSQL's approach to indexing.

In Part III, Stinson moves on to database administration. The book includes detailed chapters on user executable files; system executable files; system configuration files and libraries; and database and log files. You'll walk through compilation and installation; creating users and assigning rights to them; day-to-day maintenance; backups and restores; and, finally, performance tuning.

The book's final section is targeted directly at database programmers. You'll find authoritative coverage of server-side and client-side programming, creating custom functions, and even some advanced programming techniques you might not expect. But then, we did say tgreSQL Essential Reference was complete, didn't we? (Bill Camarda)

Bill Camarda is a consultant, writer, and web/multimedia content developer with nearly 20 years' experience in helping technology companies deploy and market advanced software, computing, and networking products and services. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.

Product Details

ISBN-13:
9780735711211
Publisher:
Sams
Publication date:
10/28/2001
Series:
Essential Reference
Edition description:
1ST
Pages:
400
Product dimensions:
5.80(w) x 8.80(h) x 1.00(d)

Related Subjects

Meet the Author

Barry Stinson , a charter member of his local LUG (lafix.org), is an active participant in the open source community. He is a day-to-day developer for PostgreSQL and he is currently the lead developer on the qikFax project, a linux fax server product, at sourceforge, (qikfax.sourceforge.net). Barry currently runs his own consulting company, Silicon Consulting Company, in Louisiana. His local clients include law firms, doctor offices, and various finance companies. Recently, he was given the task of replacing an existing database system, Microsoft's SQL Server, with PostgreSQL. Since the migration was completed over a year ago, there has been a marked improvement in system stability and the reduction of downtime.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >