Now extended through PostgreSQL 18 — with a new chapter on pgvector, 56 new figures, and a fully integrated companion lab.
Not sure yet? Read the free sample first — no card, no password.
Already own it? Your update is free →
The Preface plus hand-picked chapters across every part
Create a free account and connect to the app's dashboard — sample chapters, sample course modules, and the interactive book reader. One email, no password, no credit card.
Ready to read it all? Get the 2026 edition — $89
The most significant revision since first publication
PostgreSQL 12–18 Coverage
Full coverage of every major PostgreSQL release from 12 to 18 — partitioning improvements, logical replication, generated columns, MERGE, JSON_TABLE, uuidv7(), and more, applied to real-world scenarios throughout the book.
New chapter: vector search with pgvector
A complete new chapter on building semantic search, storing embeddings, and running AI-augmented queries — directly inside PostgreSQL, using the same SQL you already know.
56 new figures + integrated lab
56 new diagrams illustrating query plans, data models, and execution internals, plus an integrated companion lab: docker compose up starts PostgreSQL with all datasets and a query UI at localhost:8042 — no install required.
Learn → Practice → Apply → Master
Foundation & reference — 590 pages, 15 real-world datasets. Second Edition, Updated (2026).
Get the Book — $89Free for everyone. docker compose up starts PostgreSQL with all datasets and a Query UI at localhost:8042 — no install required.
Structured learning across three tiers — Core, Advanced, Architect. Hands-on labs, exercises, and direct input on the curriculum. The complete path from SQL basics to production-grade data systems.
Explore the CourseLive 3-hour deep dives with the author. Real datasets, real-time Q&A. Pick one session or the full curriculum.
See the MasterclassThe lab is free for everyone. Start there.
The foundation for everything else
590 pages covering PostgreSQL 10–18. Practical SQL techniques, 15 real-world datasets, and the new pgvector chapter — all in one PDF and ePub you keep forever, with all future updates included.
No-questions-asked refund
649 pages in print — the same complete content, formatted for the page. Includes the full digital edition (PDF + ePub) at no extra cost.
No-questions-asked refund
Pay what reflects your local economy.
The course is the next step.
The course takes you from solid SQL to production-grade data systems. Three tiers — Core, Advanced, Architect — each building on the previous one with deeper capabilities, structured exercises, and real database engineering challenges.
Core
Master SQL correctness and the full query toolkit — window functions, CTEs, aggregates, joins, data types. Everything you need to stop writing Python around your database.
Advanced
Query optimization, indexing strategy, EXPLAIN plans, concurrency, and data modeling. Write SQL that performs at production scale.
Architect
Extensions, denormalization trade-offs, and database-centered software architecture. Design systems where PostgreSQL does the heavy lifting.
Deep-dive sessions with the author
Six 3-hour live sessions, foundations to mastery — buy one or the whole curriculum.
Yes — the update is free for all existing purchasers. Sign in at app.theartofpostgresql.com with the email address you used to purchase, and click the sign-in link that arrives in your inbox — no password. The updated PDF, ePub, and online reading experience are there automatically. If you have trouble, email dim@tapoueh.org with your original order email.
New coverage from PostgreSQL 12 through 18, a new chapter on vector search with pgvector,
56 new figures illustrating query plans and data models, and an integrated companion lab
(docker compose up → PostgreSQL + query UI at localhost:8042).
See the full changelog for the complete list.
Yes — and for precisely that reason. AI-generated SQL breaks in ways that are hard to catch without understanding what the query actually does. The book gives you the mental model to read, evaluate, and fix what AI produces. More on that here.
No. There isn't even watermarking on the PDF. You own what you buy.
30-day no-questions-asked refund on all digital purchases. Email dim@tapoueh.org with your order number.
8 parts, 53 chapters, 437 SQL queries across 15 real-world datasets — from SQL fundamentals to window functions, recursive CTEs, data modeling, ACID concurrency, and PostgreSQL extensions including the new pgvector chapter. See the full table of contents with showcase queries for each part.
590 pages. 15 real-world datasets. PostgreSQL 10–18. Free for existing purchasers — available now for everyone else.
Not ready yet? Read the free sample first.