New Chapter
This second edition of the book includes a whole new chapter about PostgreSQL Extensions.
Written by the author of the CREATE EXTENSION command!
Second Edition
The Art of PostgreSQL is the new title of “Mastering PostgreSQL in Application Development”, acclaimed one of the very best resources around to learn SQL!
Improved Book Design
Because the first edition of the book has been so well received, the second edition is now available as a redesigned paperback printed format, making it a strong fit for your library!
Learn how to deal with SQL in your developer workflow: versioning, testing, code reviewing, deployment. Best practice and tools are covered.
Learn advanced SQL with practical examples and datasets that help you get the most of the book! Every query solves a practical use case and is given in context.
The book covers (de-)normalisation with simple practical examples to dive into this seemingly complex topic, including Caching and Indexing Strategy.
This book is for developers, covering advanced SQL techniques for data processing. Learn how to get exactly the result set you need in your application’s code!
Writing efficient SQL is easier than it looks, and begins with database modeling and writing clear code. The book teaches you how to write fast queries!
The book comes with open data sets and instructions to get them so that you can run all the SQL queries at home, edit them and learn from them. Advanced psql setup is even included!
Timeless Database Engineering Principles
The Art of PostgreSQL remains highly relevant because it focuses on timeless database design principles, performance thinking, and practical SQL techniques that transcend specific version features.
Practical Skills That Still Apply
While written for PostgreSQL 11, the core architecture, query optimization strategies, indexing approaches, and data modeling practices it teaches continue to apply directly to modern PostgreSQL releases.
Future-Proof Learning Investment
A curated review of new PostgreSQL features is forthcoming to inform a future edition, but this update is not yet scheduled—making the current book an immediately valuable resource for developers who want durable expertise rather than version-specific checklists.
The Art of PostgreSQL comes in a choice of four packages.
From the Standard Edition package onward, all your needs
are covered…
The real deal, 438 pages of advanced SQL teaching, just for you. You get the PDF version, the ePub version, and the MOBI version too. And the SQL queries as separate files too!
PURCHASEThe Full Edition comes with the electronic book package and an archive with a PostgreSQL dump file ready to be restored in your own instance, plus all the 334 queries as separate files for you to run and edit!
PURCHASEA professionally printed paperback of 480 pages, with the same content. You also have the benefits of the Full Edition including the copy/paste friendly content, the queries, and the database to use to replay the queries from the book!
PURCHASEEverything you need for your whole team to master SQL, including a licence to share the electronic version of the book, the database, the 334 query files and a licence to share everything with up to 15 people in your enterprise!
PURCHASEStill not sure what package is best for you? See the chart below for side-by-side comparisons and read the full details below.
⍟ Note that you can add the physical book as an second-step add-on in the checkout process. ⍟
The Book is a 438 pages full of SQL queries. 334 of them actually, all answering a very clear use-case, that is given in plain English. Every query is explained in details.
Interviews from industry veterans who began building web application in the previous century. They’ve been there and have opinions to share about how to approach SQL.
The whole electronic reading kit for all your devices: tablet, phone and desktop computer are covered. The PDF is carefully edited to target modern display formats (try it on your tablet!).
A PostgreSQL instance loaded with all the data from the book, and running a web based application that allows playing with every SQL query from the book!
The datasets from the book with 56 tables already loaded from their Open Data sources. We all learn better with concrete examples. You have 15 datasets available in the docker image.
Share the book and the docker instance with up to 15 people in your enterprise! Yes, you buy once, then share. You may even run each your own container if you prefer that, of course.
We also cover how to design a database model and why as a developer you should care about normalizing it. With practical examples and normalization scripts.
The Enterprise Edition’s docker image also includes the 334 queries as .sql files, plus the code of the sample applications presented in the book.
The application code is available with its SQL Regression Testing suite, using RegreSQL. Check out this tool, you might need it soon…
The Art of PostgreSQL includes interviews from developers and SQL masters. PHP, Java, Python and Django get specific treatment in the book, which targets all application developers, whatever the language in use!
Kris Jenkins
Clojure's YeSQL
+Kris Jenkins, from Clojure’s YeSQL, is a successful startup cofounder, turned freelance functional programmer, and open-source enthusiast. He mostly works building systems in Elm, Haskell & Clojure, improving the world one project at a time.
Yohann Gabory
Django Avancé
+Yohann Gabory, python django’s expert, has published an “Advanced Django” book in France to share his deep knowledge of the publication system with Python developers. The book really is a reference on how to use django to build powerful applications.
Grégoire Hubert
POMM Project
+Grégoire Hubert has been a web developer for about as long as we have web applications, and his favorite web tooling is found in the PHP ecosystem. He wrote http://www.pomm-project.org to help integrate PostgreSQL and PHP better. POMM grants developers with unlimited access to SQL and database features while proposing a high level API over low level drivers.
Markus Winand
Modern SQL
+Markus Winand is the author of the very famous book “SQL Performance Explained” and maintains both http://use-the-index-luke.com and http://modern-sql.com. Markus masters the SQL standard and is a wizard in how to use SQL to enable fast application delivery and solid run-time performances!
Álvaro Hernández Tortosa
ToroDB
+
Craig Kerstiens
Citus Data
+Craig Kerstiens heads up the Cloud team at @citusdata. Citus extends Postgres to be a horizontally scalable distributed database. If you have a database, especially Postgres, that needs to scale beyond a single node (typically at 100GB and up) Craig is always happy to chat and see if Citus can help.
Previously Craig has spent a number of years @heroku, a platform-as-a-service, which takes much of the overhead out of IT and lets developers focus on building features and adding value. The bulk of Craig's time at Heroku was spent running product and marketing for Heroku Data.
Thematic PostgreSQL workshops that turn knowledge into practice are also available: conference-grade PostgreSQL masterclass, delivered in a focused 3-hour format combining expert instruction, live Q&A, and practical exercises. Registration to the masterclass workshop includes The Art of PostgreSQL complete download package (PDF, EPUB, and companion materials), valued at $99.
THE WORKSHOPNot convinced yet? Get a FREE chapter including the full Table of Contents!
