Deliver toUnited Arab Emirates
PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database

Description:

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.

Reviews:

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 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!

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 IRS uses postgresql

C.C.C. · December 29, 2023

IRS my office need some bkgrd

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.

4.0 out of 5 stars The book is well written, needs to go into a little more detail on installation best practices

D. · February 23, 2021

I enjoyed the book and it was well written, (even for beginning users), the only reason why I didn't give it 5 stars is it lacked examples of best practices for fine-tuning during and after the installation process. For me I wished it would have walked through that process, especially for newer users. Overall a good book and worth purchasing.

Excellent - readable and a good learning experience

O. · March 3, 2020

A unique style, well written and easily readable. Postgres is not a small topic, so this book condenses a lot of information into a small space. Do not expect this to be your only learning tool. You need more (well I did). I found myself enjoying the read and at the same time using the internet to fill in gaps.Worthwhile. Recommended.

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.

Excellent overview of PostgreSQL and what’s new in PostgreSQL 10

r. · November 24, 2017

Excellent overview of PostgreSQL and what’s new in PostgreSQL 10.Succinct - not padded out with bumpf you can find elsewhere.Covers the key concepts and things you need to know to get started and introductory information on other interesting topics that you can then delve into elsewhere.Recommended introduction to PostgreSQL and up-to-date.

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.

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

Product ID: U1491963417
Condition: New

4.4

AED29926

Price includes VAT & Import Duties
Type: Paperback
Availability: In Stock

Quantity:

|

Order today to get by 7-14 business days

This item qualifies for free delivery

Returns & Warranty policies

Imported From: United States

At BOLO, we work hard to ensure the products you receive are new, genuine, and sourced from reputable suppliers.

BOLO is not an authorized or official retailer for most brands, nor are we affiliated with manufacturers unless specifically stated on a product page. Instead, we source verified sellers, authorized distributors or directly from the manufacturer.

Each product undergoes thorough inspection and verification at our consolidation and fulfilment centers to ensure it meets our strict authenticity and quality standards before being shipped and delivered to you.

If you ever have concerns regarding the authenticity of a product purchased from us, please contact Bolo Support. We will review your inquiry promptly and, if necessary, provide documentation verifying authenticity or offer a suitable resolution.

Your trust is our top priority, and we are committed to maintaining transparency and integrity in every transaction.

All product information, images, descriptions, and reviews originate from the manufacturer or from trusted sellers overseas. BOLO is not affiliated with, endorsed by, or an authorized retailer for most brands listed on our website unless stated otherwise.

While we strive to display accurate information, variations in packaging, labeling, instructions, or formulation may occasionally occur due to regional differences or supplier updates. For detailed or manufacturer-specific information, please contact the brand directly or reach out to BOLO Support for assistance.

Unless otherwise stated, all prices displayed on the product page include applicable taxes and import duties.

BOLO operates in accordance with the laws and regulations of United Arab Emirates. Any items found to be restricted or prohibited for sale within the UAE will be cancelled prior to shipment. We take proactive measures to ensure that only products permitted for sale in United Arab Emirates are listed on our website.

All items are shipped by air, and any products classified as “Dangerous Goods (DG)” under IATA regulations will be removed from the order and cancelled.

All orders are processed manually, and we make every effort to process them promptly once confirmed. Products cancelled due to the above reasons will be permanently removed from listings across the website.

Similar suggestions by Bolo

More from this brand

Similar items from “SQL”

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

Product ID: U1491963417
Condition: New

4.4

PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database-0
Type: Paperback

AED29926

Price includes VAT & Import Duties
Availability: In Stock

Quantity:

|

Order today to get by 7-14 business days

This item qualifies for free delivery

Returns & Warranty policies

Imported From: United States

At BOLO, we work hard to ensure the products you receive are new, genuine, and sourced from reputable suppliers.

BOLO is not an authorized or official retailer for most brands, nor are we affiliated with manufacturers unless specifically stated on a product page. Instead, we source verified sellers, authorized distributors or directly from the manufacturer.

Each product undergoes thorough inspection and verification at our consolidation and fulfilment centers to ensure it meets our strict authenticity and quality standards before being shipped and delivered to you.

If you ever have concerns regarding the authenticity of a product purchased from us, please contact Bolo Support. We will review your inquiry promptly and, if necessary, provide documentation verifying authenticity or offer a suitable resolution.

Your trust is our top priority, and we are committed to maintaining transparency and integrity in every transaction.

All product information, images, descriptions, and reviews originate from the manufacturer or from trusted sellers overseas. BOLO is not affiliated with, endorsed by, or an authorized retailer for most brands listed on our website unless stated otherwise.

While we strive to display accurate information, variations in packaging, labeling, instructions, or formulation may occasionally occur due to regional differences or supplier updates. For detailed or manufacturer-specific information, please contact the brand directly or reach out to BOLO Support for assistance.

Unless otherwise stated, all prices displayed on the product page include applicable taxes and import duties.

BOLO operates in accordance with the laws and regulations of United Arab Emirates. Any items found to be restricted or prohibited for sale within the UAE will be cancelled prior to shipment. We take proactive measures to ensure that only products permitted for sale in United Arab Emirates are listed on our website.

All items are shipped by air, and any products classified as “Dangerous Goods (DG)” under IATA regulations will be removed from the order and cancelled.

All orders are processed manually, and we make every effort to process them promptly once confirmed. Products cancelled due to the above reasons will be permanently removed from listings across the website.

Description:

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.

Reviews:

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 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!

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 IRS uses postgresql

C.C.C. · December 29, 2023

IRS my office need some bkgrd

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.

4.0 out of 5 stars The book is well written, needs to go into a little more detail on installation best practices

D. · February 23, 2021

I enjoyed the book and it was well written, (even for beginning users), the only reason why I didn't give it 5 stars is it lacked examples of best practices for fine-tuning during and after the installation process. For me I wished it would have walked through that process, especially for newer users. Overall a good book and worth purchasing.

Excellent - readable and a good learning experience

O. · March 3, 2020

A unique style, well written and easily readable. Postgres is not a small topic, so this book condenses a lot of information into a small space. Do not expect this to be your only learning tool. You need more (well I did). I found myself enjoying the read and at the same time using the internet to fill in gaps.Worthwhile. Recommended.

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.

Excellent overview of PostgreSQL and what’s new in PostgreSQL 10

r. · November 24, 2017

Excellent overview of PostgreSQL and what’s new in PostgreSQL 10.Succinct - not padded out with bumpf you can find elsewhere.Covers the key concepts and things you need to know to get started and introductory information on other interesting topics that you can then delve into elsewhere.Recommended introduction to PostgreSQL and up-to-date.

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.

Similar suggestions by Bolo

More from this brand

Similar items from “SQL”