PostgreSQL: Introduction and Concepts

By Bruce Momjian

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... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0201703319
• ISBN13: 9780201703313
• Release Date: December 2000
• Publisher: Addison-Wesley
• Length: 462 Pages
• Weight: 1.66 lbs.
• Dimensions: 8.8" x 1.0" x 7.0"

Customer Reviews

Better than the reviews suggest!

This book took me from being a SQL novice (let alone a PostgreSQL novice) to being able to being able to use PostgreSQL for business apps.I'm not quite sure why some reviewers knocked it. It has much more content than the FAQ, good examples and a reference section. One reviewer knocked the reference section, claiming the book was half full of appendices... in fact the reference section is what you most often go to the book for after you've worked through the basic concepts in the first section.I think the layout is slightly odd - the examples of commands and their results are grouped together in sections that are usually a page or two ahead of the text that explains them. So you spend a bit of time flicking pages to see examples. But once you get the hang of this style it's not exactly the biggest pain in the world.I think it's a very good book, one that took me from being a SQL beginner yet is still useful as a day to day reference.Lee

Just what we needed...

We are involved in CF, vb and php projects and needed an alternative to another Oracle license. We turned to PostgreSQL and soon discovered we were making heavy going of the online docs. This book has quickly answered our functional questions, helping us with transactions, sequences etc. So far everything we've needed we've found right away.I wish they were more specific about field max sizes - oracle for example is very clera and very constrained (4k limits on inmserts to varchar fields for example). These limits appear to be arbritarily large as we have tested without overrunning them.ALso we have of course the source files for postgres, so questions like that can be answered with some familiarity with the code. Postgres isn't Oracle and it certainly wont scale like Oracle, but for web projects witha few thousand records and a few dozen simultaneous users it, and this book, are perfect.

A First Class Introduction to PostgreSQL

This is book is pretty well a "must" for immigrants from the world of DOS and Win* and the aggravations of MSAccess. The volume offers a first class tutorial and introduction to running postgreSQL from the command line. There is essentially no discussion about any of the GUI front ends available, such as the pgaccess interface in KDE (nine sentences in three paragraphs at the end of Chapter 16). However, the fact, which becomes obvious working through the book, is that GUI interfaces are really unnecessary to use the program. The book reflects some *nix idiosyncracies that would be ex-users of DOS and Win* will find puzzling, if not outright baffling. These oddities - to DOS and Win* users - have more to do with the Linux platform and *nix traditions in general, than with PostgreSQL per se. One of these is that there is no discussion of formatting printed or screen-displayed reports, which in the DOS / Win* world are the normal end products of queries. This reflects, by total neglect of the topic, the author's expectation that a postgreSQL user will be capturing output and processing it with other programs. This is a historical characteristic of *nix, but quite alien thinking to other systems.This is where the overly brief discussion of using 10 different programing languages as front and back end interfaces to postgreSQL comes in, and for ex-DOS/Win* users more discussion would be incredibly useful. More often than not we have been used to employing the monolithic utility of programs such as Access or dBASE from data input through querying, data quality control, and reporting. There is also a clear opportunity here for some aspiring open-source or even shareware author to produce a handy, stand alone report formatter. Half of the book is contained in appendices and includes a very useful reference manual in Appendix D. Were I the author, I would be shuffling appendices so that D became A in the next incarnation of this book.All in all, this book is a must-read for those of us migrating to Linux and postgreSQL.

A great overview of Postgres

It's an odd commentary on the open source movement that, while open source code seems sophisticated and reliable -- as a result of the many hands working on it -- open source documentation, as a general rule, sucks. I believe that this book is the _first_ printed book on PostgreSQL. As such, the author is to be commended for his effort at collecting a great deal of useful Postgres info in one place, helping readers find the essential knowledge buried in the sea of online documentation.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.

Great first book on PostgreSQL

This is the first book I've seen on PostgreSQL. It's been in progress for sometime, and had been available in electronic form. However, the print version is sure to be a gem. It contains information needed by anyone trying to get a handle on PostgreSQL, beginner or advanced. The folks starting to use PostgreSQL will have alot of examples on standard SQL for database access, including transaction support. The more advanced users will appreciate the level of detail including how PostgreSQL differs from standard SQL (Good news is that this isn't by much) and integration with other tools. It also has good information about transaction requirements and ways they are implemented within the context of PostgreSQL, as well as how to increase performance. I gave it four stars out of five only because I thought it could have used more administration details and hints. Though the administration section in the book is still a good read, and it is clearly a topic that can take another book to complete. In short, I highly recommend the book for those wanting to learn more about this open-source database.