Books

What really happens when PostgreSQL executes your query? Follow a SQL statement through every stage of PostgreSQL's internal pipeline—from raw text to returned results—and gain the deep understanding that transforms how you write, tune, and debug database applications.

A high-performance data access layer must resonate with the underlying database system. Knowing the inner workings of a relational database and the data access frameworks in use can make the difference between a high-performance enterprise application and one that barely crawls.

Build four real mobile apps from scratch — no coding experience required. Claude Code handles the code. You handle the idea.

Master PostgreSQL administration with a practical guide to deploying, securing, optimizing, and operating production databases. Covering PostgreSQL 17 and 18, this book combines real-world examples, hands-on labs, and proven best practices for reliable, high-performance systems.

When your database outgrows simple optimizations, it's time to think bigger. Lift the Elephant goes beyond query tuning to reveal actionable strategies for scaling PostgreSQL, from partitioning to high-availability architectures. Built on lessons from scaling Hubstaff, this is your playbook for navigating the challenges of database growth.

Stop only using databases — start understanding them. A living study of PostgreSQL internals for backend engineers: how pages, indexes, and WAL actually work, written clearly while learning, not after mastery.

Get started quickly, creating applications for the Model Context Protocol (MCP) using the official MCP SDKs for Python, Java 21, and Node.js. Quickly master, all of the concepts needed in order to build MCP servers, including transport protocols, tools, resources, prompts, roots, and sampling. Learn how to get familiar with popular MCP client applications such as, Claude Desktop, Postman, and the MCP Inspector.

If you are a database developer and you put performance as goal to achieve with your DB design...then using PL/PGSQL functions is your excellent tool.

Build six complete Django projects, plus a final case study, with the latest Django and Python: PostgreSQL, full-text and semantic search, HTMX, background jobs, multi-tenancy, tests, Docker and deployment. Every result in the book was produced by actually running the code.

Build a real document management system from scratch to production: OCR, keyword and semantic search, an AI assistant that cites its sources, sharing and approvals, Docker, Nginx and private HTTPS.

PostgreSQL Under Load shows what really happens when production gets busy. Learn how connections, transactions, MVCC, locks, WAL and autovacuum interact under pressure, then use that knowledge to diagnose incidents, tune PostgreSQL and build systems that stay reliable when concurrency spikes.

Build real-world web applications faster with Claude Code by your side. This hands-on guide takes you from web development fundamentals to production-ready full-stack engineering with React, Next.js, TypeScript and PostgreSQL. Learn practical AI-assisted workflows while building, testing, securing and deploying applications that are ready for real users.

Your query planner doesn't know how many rows will match. It guesses. This book shows you exactly how — and why it's sometimes wrong.

A hands-on guide to running PostgreSQL in production, from schema design and indexing to replication and disaster recovery. Build three real systems: a multi-tenant SaaS app, an analytics warehouse, and a real-time event pipeline. For developers ready to move beyond the basics.

It's a practical book. We're going to build something real together, a University API, and we're going to grow it chapter by chapter until it looks like a system you'd be proud to deploy. We'll start with a few endpoints, give it databases, make it concurrent, lock it down with authentication, wrap it in containers, and finally split it into cooperating services that talk over the network.