A Practical Guide to the Advanced Open Source Database
Tell us what's wrong and we'll take a look.
Thanks – we got it. We'll review and follow up if needed.
Thinking of migrating to PostgreSQL? This concise introduction helps you understand and use this open source database system. Not only will you learn about the new enterprise class features in versions 16 to 18, but you'll also discover all that PostgreSQL has to offer--much more than a relational database system. As an open source product, it has hundreds of plug-ins, expanding the capability of PostgreSQL beyond all other database systems.
With examples throughout, this book shows you how to perform tasks that are difficult or impossible in other databases. The revised fourth edition covers the latest features of Postgres, such as ISO-SQL constructs rarely found in other databases, foreign data wrapper (FDW) enhancements, JSON constructs, multirange data types, query parallelization, and replication.
If you're an experienced PostgreSQL user, you'll pick up gems you may have missed before.
Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 30 years of professional experience in various programming languages and database systems, with special focus on spatial databases. Regina has helped develop and contributed to several PostgreSQL extensions and is also a contributor to the core PostgreSQL project, most recently an extension support feature in PostgreSQL 16.
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He teaches a master's course at Tufts University, "DATA-0202-01: Database Design and SQL" and uses PostgreSQL for teaching database concepts in his class. Leo has over 30 years of professional experience developing and thinking about databases for organizations large and small.
Readwise Books is an ebook & audiobook platform that automatically logs how much you and your friends read, making it fun and easy to read more. Learn more →
Enter your email to continue. We'll create your account if you're new here.