PostgreSQL: Introduction and Concepts Paperback – 4 Dec 2000
Customers Who Viewed This Item Also Viewed
Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Back Cover
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system.
Assuming no previous knowledge of database systems, the book establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's more advanced and innovative capabilities. It leads you step-by-step from your first database query through the complex queries needed to solve real-world database problems. The author not only presents proper query syntax, he goes beyond the mechanics to explore the value and use of these commands in working database applications.
You will read about such important topics as:
- Basic SQL commands for manipulating and updating a database
- Customizing queries
- SQL aggregates
- Joining tables
- Combining SELECTs and subqueries
- Importing and exporting data
- Database query tools, including PSQL and PGACCESS
- PostgreSQL interfaces to C, C++, ODBC, JDBC, Perl, TCL/TK, and more
- Server-side programming and multi-user control
- Extending PostgreSQL with C
- PostgreSQL administration, including backups, troubleshooting, and access configuration
- Features unique to PostgreSQL
Throughout, the author highlights common pitfalls, offers tips to save you time and trouble, and provides many examples--all garnered from his extensive experience and inside knowledge. In addition, this resource-rich guide provides a copy of the official PostgreSQL reference manual. A companion web site, www.postgresql.org/docs/awbook.html, will contain updates, corrections, and links to other material.
About the Author
Bruce Momjian is a founding member of the PostgreSQL Global Development Team. He is currently a senior consultant with Wilson Technology Associates in Newtown Square, Pennsylvania, designing and developing relational database applications for some of the largest law firms nationwide.
Top Customer Reviews
Chapter 2, first page.
At this point, the book makes the following assumptions:
You have installed Postgresql ...
.... .... .....
You have a database called test.
If not, see Appendix B"
Appendix B tells you very little, and sends you to chapter 20 (the last chapter in the book)
Most Helpful Customer Reviews on Amazon.com (beta)
The book's title says "Introduction and Concepts", letting you know this isn't an advanced treatise on Postgres. The first half of the book handily summarizes SQL and then dives into hands-on PostgreSQL, run interactively via the psql interactive utility. This is a nice way to give readers direct experience with Postgres, but it is also automatically limiting because readers never learn how to use Postgres in the context of an application. There is a chapter on programming interfaces, but it covers ten languages in ten pages, which isn't enough to impart any practical Postgres programming skills.
The second half of the book is a verbatim replica of the SQL Commands reference from the official Postgres user's guide. It's handy to have in the book, but it's hard to give the author any credit for simply pouring this stuff into his book unchanged. I would have liked to see some useful annotations from the author, reflecting his obviously considerable experience with Postgres.
I gave the book four stars in part because the author is breaking new ground by carving out a niche with publishers for future PostgreSQL books. I'm hoping a second edition of his book comes soon, replacing (or augmenting) those 250 pages of reference material with concrete programming examples in a variety of languages and interesting comments on usage. In the meantime, this book is a very nice primer for our new employees who have to come up to speed on PostgreSQL quickly.
Considering the title, it should at least give some direction about how to install/configure, list the gotcha's, do's, don't's, etc. But this book starts with the assumption that you already have the database installed and ready to run, server and all.
I'm not kidding, it's actually listed in one of the first sections in the book that a running server is required to read this book. How does this match the "Introduction and Concepts" title???
A little pointer to the author if he's reading this, in his next book or second edition of this book, he should: 1. Explain where PostgreSQL fits in modern distributed architectures 2. Why would I want to use PostgreSQL instead of MySQL if I'm developing a J2EE application, how about CORBA? 3. How do I take advantage of the OO features of PostgreSQL to shorten the development time
If you plan to program in PostgreSQL or modify the PostgreSQL program, you must buy this book. Also highly recommended is the somewhat obscure paper: "Enhacement of the ANSI SQL Implementation of PostgreSQL" by Gottlob & Seyr.
PostgreSQL is the ONLY fully functional SQL implementation with a TRULY open license. I hope to see more fine efforts like this in the future.