PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database

Description:

About this item:

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.

With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.

If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before.

  • Learn basic administration tasks such as role management, database creation, backup, and restore
  • Apply the psql command-line utility and the pgAdmin graphical administration tool
  • Explore PostgreSQL tables, constraints, and indexes
  • Learn powerful SQL constructs not generally found in other databases
  • Use several different languages to write database functions
  • Tune your queries to run as fast as your hardware will allow
  • Query external and variegated data sources with foreign data wrappers
  • Learn how to use built-in replication to replicate data

Editorial Reviews

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.

Review:

3.7 out of 5

73.85% of customers are satisfied

5.0 out of 5 stars Very good book if you're familiar with SQL databases and want to migrate to Postgres

U. · October 28, 2017

This is for the Kindle version of 3rd edition. I had the first edition of the book in paperback but the font is very small and hard to read. I imagine that the . The 3rd edition in Kindle format is very good though, and has been updated for Postgres 9.6 with some tips about features from 10.0.I've tried many other Postgres books but they are mostly written poorly and seem like they never passed through an editor, at least not an English-speaking one. The 3rd edition of this book is written much better than the others, including the 1st edition.One thing that I found a bit strange and doesn't really belong in a database programming/administration book was the examples in the Full Text Search section:"If you type in the search term _lots of steamy sex scenes_, you might end up with nothing...""For example, if you're interested in viewing movies where sex is depicted with smoking, you could search for the two words _sex_ and _smoking_""_And so they smoked after sex_"And few more mentions of the word "sex" in that section.I am really not a prude. I just think that they could have come up with some more appropriate examples. Also, smoking is really bad for you!

5.0 out of 5 stars IRS uses postgresql

C.C.C. · December 29, 2023

IRS my office need some bkgrd

4.0 out of 5 stars Great content, poor print quality

r. · February 5, 2020

The contents and writing are at least 4 stars.I bought this book first on Kindle, but I found the subject matter difficult to enjoy as an ebook; so I purchased the print edition.To my tremendous disappointment, the print copy’s images are surprisingly illegible. The images are in grayscale (not in color as in the e-book version), very faint and with very low contrast (almost faded looking), and quite grainy, lacking clear definition. I had expected the images to be sharp and colorful, like those in the ebook.Bolo, do any of your copies of this book have better images? Did I get a bad print?

5.0 out of 5 stars For when you need to fully utilize PostgreSQL

T. · November 24, 2020

I'm at a place where I no longer use ORMs but straight SQL, and need to utiliez every feature of a DB instead of replicating it in code. This results in much less code, and a much faster app. This book helped (and is still helping) me learn Postgres features and how it all works. Keen for the 4th edition.

5.0 out of 5 stars Great intro to features and capabilities of Postgres

B.T. · December 9, 2019

The first book on PG I read. Really helped me undersrand the landscape. If you have decided to deploy and manage a Postgre database, I would highly this book.

4.0 out of 5 stars Essential Book

A.E. · February 7, 2021

I am old fashioned. I read books. Books like this allows you to ramp up quickly. If I were to try to ramp postgres by online searches, I will be proceeding at 1/10 the pace. After reading a few pages in chapter 1, the objects displayed by pgAdmin no longer seem like gibberish to me.

2.0 out of 5 stars Does not cover Postgres Internals

K. · May 19, 2020

Does not cover internals or concepts like using XMIN. I was hoping to at least get diagrams and an intro into how Postgres was designed.

1.0 out of 5 stars This book uses the End-of-Life (EOF) version 9.x and EOF v10 to teach PostgreSQL. Not good !!!

A.C. · October 24, 2023

** Be careful , This book is OUTDATED*** This book uses the End-of-Life (EOF) version 9.x and EOF v10 to teach PostgreSQL. Not good, both versions are TOO OLD !!! It is of utmost importance for any book reader, enthusiast, or professional to be aware of the critical implications of using outdated PostgreSQL versions of PostgreSQL software in this book "PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database", especially when it comes to something as vital as database management. Purchasing a book that focuses on PostgreSQL 9.5 or 10.x can lead to a multitude of issues and concerns that are not to be taken lightly. First and foremost, relying on End-of-Life (EOL) software such as PostgreSQL 9.5 or 10.x poses significant dangers. These versions have reached the end of their official support and development cycles, which means they are no longer receiving updates, bug fixes, or security patches from the developers. As a result, several critical problems emerge when using them. One of the most pressing issues is that these outdated versions lack the latest features and improvements introduced in newer PostgreSQL releases. This can translate to a substantial waste of time and effort, as users grapple with improper configurations and outdated practices that have since been optimized in newer releases. Keeping up with the rapid advancements in database technology is essential for efficiency and productivity. Another major concern is the heightened security risk associated with EOL software. With no security updates being provided, users are left vulnerable to known and potentially exploitable vulnerabilities. In an era where data breaches and cyber threats are rampant, neglecting software security can have severe consequences, both in terms of data integrity and legal repercussions. Moreover, relying on outdated PostgreSQL versions means missing out on essential new features that have been introduced to enhance database performance, scalability, and functionality. These features are designed to streamline operations, improve query optimization, and facilitate more efficient data management. By sticking with EOL versions, users limit their ability to harness these advancements. It is crucial to recognize the dangers associated with outdated software, it can lead to improper configurations, heightened security risks, and missed opportunities for improved efficiency and functionality. To stay competitive and secure in the ever-evolving world of database management, it is strongly recommended to invest in resources that cover the latest, supported PostgreSQL releases. Your data and your peace of mind will thank you. *** This book is NOT RECOMMENDED ***

Practical? More like just a reference book

n. · March 29, 2021

Even as a reference book, this is just not what you'd want to read, I would have returned this book if I had the patience to do that.To give you a perspective, one of the things you'd use a lot in Postgres is inner join. I could not find any explanation of how that works anywhere in the book at all. That's just one example.

Livro muito bom para iniciantes em postgresql

G. · February 6, 2021

Se vc está aprendendo sobre postgresql esse é um excelente livro. Esse livro não detalha nenhum aspecto da arquitetura do banco porém é um bom livro para iniciantes.

A struggle to follow the book.

P. · August 27, 2020

Unfortunately the book is written in a way that makes it hard to follow.The examples are rushed and poorly designed and there are almost no parallels to the real world.The backup/recovery chapter is also just a simple copy/paste from the official pg_dump, pg_restore syntax with very little punctual explanations.

Onesta panoramica di PostgreSQL

F. · September 2, 2019

Il libro è un'onesta panoramica delle caratteristiche di PostgreSQL, con riferimenti alle novità introdotte nelle ultime release.Tutto però è trattato senza approfondimenti, rimandati a pagine di cui viene fornita la URL abbreviata, senza dire quando si sta linkando il manuale di PostgreSQL, quando articoli tecnici.

True to the Title

:. · October 10, 2019

Like all O'Reilly books, this one has a standard it keeps. A good resource on PostgreSQL after doing the newbie tutorial from one of the resources on PostgreSQL.org. Good practical examples on explaining how database features can be applied.

PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database

4.4

BHD28122

Quantity:

|

Order today to get by

Free delivery on orders over BHD 20

Return and refund policies

Product origin: United States

Electrical items shipped from the US are by default considered to be 120v, unless stated otherwise in the product description. Contact Bolo support for voltage information of specific products. A step-up transformer is required to convert from 120v to 240v. All heating electrical items of 120v will be automatically cancelled.

All product information listed on the site are from 3rd party sources, including images and reviews. bolo.bh is not liable for any claims or promotions mentioned on the product description or images with textual content. For detailed product information, please contact the manufacturer or Bolo support by logging into your account. Unless stated otherwise during checkout, all import taxes and duty are included in the price mentioned on the product page. bolo.bh follows the rules and regulations of sale in Bahrain and will cancel items in an order that are illegal for sale in Bahrain. We take all the necessary steps to ensure only products for sale in Bahrain are displayed. Product stock and delivery estimate may change with the seller even after placing the order. All items are shipped by air and items marked “Dangerous Goods (DG)” by the IATA will be cancelled from orders. We strive to process your order as soon as it is finalized.

Similar suggestions by Bolo

More from this brand

Similar items from “Databases & Big Data”