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.