- Paperback: 234 pages
- Publisher: O'Reilly Media; 2 edition (December 28, 2014)
- Language: English
- ISBN-10: 1449373194
- ISBN-13: 978-1449373191
- Product Dimensions: 7 x 0.5 x 9.2 inches
- Shipping Weight: 11.2 ounces (View shipping rates and policies)
- Average Customer Review: 16 customer reviews
- Amazon Best Sellers Rank: #359,422 in Books (See Top 100 in Books)
Enter your mobile number or email address 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.
To get the free app, enter your mobile phone number.
PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
A Practical Guide to the Advanced Open Source Database
About the Author
Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
However, in teaching PostgreSQL administration, I find that there are still quite a few individuals who like a comprehensive introduction to a topic. Quite a few of these individuals like that comprehensive introduction to be in book form. This is a good resource for those individuals.
WHAT I LIKE:
1) The authors are active in using PostgreSQL
It is obvious from the tone in which the book is written. Small things, like knowing that Amazon's Redshift is a fork of a PostgreSQL fork . . . aren't monumental, but give the authors credibility in my mind since I use Postgres in its community, EnterpriseDB, and Redshift flavors.
2) Concise, quick tips for administrators
There is more to PostgreSQL administration than configuration of the pg_hba.conf, postgresql.conf, and pg_ident.conf files. However, a solid understanding of these will help a new PostgreSQL user troubleshoot 80% of the issues they will likely encounter. A good but brief coverage of these files' formats, psql, and interactive/non-interactive administration are the best reasons for a new admin to buy this book.
3) Datatype discussion, including new JSON types
There has been a lot of buzz in the community regarding the newer JSON data types that some feel make PostgreSQL a serious competitor in both the relational DB world as well as the unstructured data (MongoDB, Cassandra, etc) world. This book gives a great overview of all existing datatypes as well as the new ones available in 9.4.
WHAT I DON'T LIKE:
1) My preference, but I think the treatment of the PgAdmin tool is too extensive. But my default preference for almost all systems is all command line, all the time.
2) DBAs will always ask about replication. I think the chapter on replication is a VERY light treatment of the subject. So, don't buy this book if you expect a step-by-step guide with hints regarding possible problems, workarounds, tests, etc.
Overall, I'm pleased with this purchase. I bought this book to evaluate how appropriate it would be to give to my students as a reference manual. I like it for that and I wish I had something like this when I was new to PostgreSQL. If you're an active PostgreSQL DBA or power user, it might be an interesting read, but nothing amazing.
I have a few minor gripes. At times, I wanted more detailed explanations. For example, the flags for using pg_dump are complicated. An example used –C –F –b –v –f, but I had to look up each flag separately in an appendix. Knowing that this creates a ‘single, compressed database backup’ isn’t enough.
A second gripe was that references to more detailed articles by the authors were given as ‘bit.ly’ URLs which are annoying to type in. Surely they could have taken the trouble to create user-friendly pages on WordPress or, at the cost of a few dollars, put them onto a website dedicated to the book.
Overall, however, I would thoroughly recommend this book to anybody (except a novice in SQL) who wants to learn more about this powerful object relational database application.
If you want a giant, ponderous tome that goes into excruciating detail, this is not the book for you. I went through this book in an afternoon and had a much better idea of what I had been missing in PG. There are even nice tips about how to use PG to improve your app (like setting the search_path to $user, and naming your schema(s) after each user, you achieve a much cleaner separation of concerns than just throwing all data into single tables).
If you really want to see Obe & Hsu pull out The Big Guns, go look at PostGIS in Action. This book has some of the most in-depth coverage of PG ever, and it is not even primarily about Postgres.
If you are in Bend, OR, I ordered both these books thru the public library, and they are available there if you want to try before you buy.