The Second Edition, Updated (2026) — now extended through PostgreSQL 18, with a new chapter on pgvector, 56 new figures, and a fully integrated companion lab. Free for everyone who already owns the book.
Sign in with the email you bought with. No password — we send a one-time link.
Or go straight to app.theartofpostgresql.com
No new account, no password, no download code
app.theartofpostgresql.com
The address you
used to purchase
Updated PDF, ePub, and the
online reader are already there
Can't find your account? Email dim@tapoueh.org with the email address from your original order.
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.
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. Already paid for — sign in and it's there.