Practical PostgreSQL for Developers

Start with the foundation

The book is your entry point to a complete PostgreSQL system. Learn the fundamentals, practice with real data, then apply advanced techniques in production.

Fair Pricing Available

SQL is a system design tool

Replace complexity with clarity

What you'll learn

From queries to production thinking

Better queries

Write clear, correct, and efficient SQL

Performance

Read query plans and optimize with confidence

Schema design

Build production-ready data models

Index strategy

Use indexes effectively, know when and why

Real-world SQL

Apply in production systems, not tutorials

Practice lab

Apply what you learn with real datasets

The Art of PostgreSQL — Second Edition
Get the Book — $89
2026 Update

Second Edition — Now Available

The 2026 update modernises the book from PostgreSQL 11 to the 17/18 landscape, adds a new chapter on vector search with pgvector, introduces 56 new figures, and a fully integrated companion lab.

Already have the book? Everyone who purchased the book receives this update free of charge. Log into your ThriveCart account, open the lesson, and download the updated PDF and ePub files directly.

Start here, then go further

The first step in a complete learning path

Book

Foundation & reference

Course

Structured learning

Workshop

Live deep dives

Lab

Hands-on practice

The book gives you the foundation. Everything else builds on it.

Trusted by developers

Used in real systems

  • "This book is on a higher level than generic software books. It explains the how's and why's of using Postgres's many feature. It is an excellent companion to the official Postgres documentation."

    Bruce Momjian, PostgreSQL core team
  • "At last the definitive Postgres book for app developers is out, and from the amazing @tapoueh no less. Go get it!"

    Peter van Hardenberg
  • "Full edition of The Art of PostgreSQL is BRILLIANT! Not just best PG resource ever but best tech-learning package I've ever seen!"

    Derek Sivers
  • "Thanks for your fantastic book. It's helped me immensely in my current job. Technical books can often be a bore and hard to digest, but The Art of PostgreSQL was a pleasure to read."

    Ben Davies

Continue after the book

Structured learning, deeper mastery

Most readers continue with the course. It reinforces the book's concepts with structured lessons and hands-on practice.

Go further with expert guidance

Advanced topics, live sessions

Workshops are for experienced users who want to go deeper on specific topics with real-time Q&A.

Accessible worldwide

Choose a fair price

Fair pricing means you decide what the book is worth to you. Pay what you can afford — the same content for everyone.

Start with the book

Build real PostgreSQL skills

The book is where it starts. From there, the course, workshops, and lab build on what you learn — creating a complete system for mastering PostgreSQL.

Not convinced yet? Get a FREE chapter including the full Table of Contents!