Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
Practical PostgreSQL Paperback – January 17, 2002
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
Customers Who Bought This Item Also Bought
Top Customer Reviews
Just wanted to warn about one thing here:
The absolute worst part of this book is the index (which is a _very_ important part of any tech book). The one listing they have under the letter K: "keywords". What about keys? A SQL book that doesn't have an index entry for keys? There's not even any "H" listing... hashes?
The 'stored procedure' (PL/pgSQL) chapter was for me the only interesting part of this book for me.
When I bought this I was hoping for the PostgreSQL 'Bible', but it was a big dissapointment.
My advice for improvement for the next release:
- much better index
- drop LXP chapter
- chapter about how to tune (not just SQL statements, but the postgreSQL server itself) and benchmark PostgreSQL.
- a chapter about 'schema' and when to use them.
- extend PL/pgSQL chapter with some 'real world' examples and how to do PL/pgSQL trouble shooting, PL/Perl(?)
- general advice how to manage PostgreSQL on 'day to day' basis
- maybe have a chapter about the SLONY replication add-on
- Postgresql 8.0 features
I cannot recommend this book.
more than practical postgreSQL from Bruce.It's a sheer waste of your money.
Speaking of the index, it is surely the poorest one I've encountered in any O'Reilly or other computer reference book I've ever seen or considered buying. It fills only 3 pages front and back. This is a 600+ page book mind you. Because of the poor index you will probably spend more time flipping through pages or using the table of contents which is rather scant as well.
It is too bad that I bought this book by mail order because if I had been able to inspect it in a bookstore, I would've never bought it. The documentation that comes with PostgreSQL is more than adequate to get it installed and working. If you are looking to use Perl as your front-end language, your time and money would probably be better spent on "Programming the Perl DBI" by O'Reilly.
RE LXP, while obscurity is certainly no reason to discount something, I see no reason to go so deep into coverage of this language, when things like PHP are so much more widely used for such purposes. A far better use of those pages would have been a small discussion on DB structure and logic, and general guidelines on how to set things up efficiently. That, and a more specific description of the configuration variables before compiling the DB, preferrably going over when you would need to use those options.
This book has a problem that I guess most SQL books suffer from. It has a very long introduction to SQL itself. Which is not bad if you are a complete beginner. The book is somewhat boring to read, without that additional value because of which you buy a book. It lacks additional information on advanced PostgreSQL features, programming in PL/pgsql, replication, administration and some other interesting topics. On the other hand it's not that "practical" but rather a PostgreSQL reference.
All in all this book has too much reference which makes it hard to read. With that and the fact it is somewhat outdated, you might want to decide on skipping it.
Most Recent Customer Reviews
Pretty sad, really. Rather than go to the time and trouble of releasing a new edition for PostgreSQL 9, O'Reilly tries pawning off an ebook version of a *10 year* old book -... Read morePublished on June 20, 2012 by Monte Milanuk
Like most of what O'Reilly publishes, this book is no exception.
Very good clear explanations, even better examples, and useful appendix. Read more
I wanted to buy this book a few months ago, but after reading the reviews I relented. Finally, a few weeks ago I needed a book on PostgreSQL and it was the only one available, so I... Read morePublished on June 18, 2003 by Stephane Larochelle
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... Read morePublished on April 26, 2003 by Jason Sheets
I am using PostgreSQL after having used MySQL for years. Even though PostgreSQL has some nice advance features (ACID, Transaction, Foreign Key), it lacks basic and simple features... Read morePublished on December 30, 2002 by L. Maestracci
I use a Postgresql database since march 2002. I bought this book in may 2002 and the book hasn't turned out the practical guide it claims to be. Read morePublished on November 9, 2002 by Jos Deuling