PostgreSQL

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.

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.

"It’s 3 AM, your database just hit 500 connections, and everything has ground to a halt. Do you know why?"Most database outages aren't mysterious—they are architectural. Stop treating PostgreSQL as a black box and start understanding the mechanical "why" behind the engine. PostgreSQL Internals Mastery: Volume I is a modular deep dive designed for senior engineers who need to bridge the gap between writing SQL and architecting high-performance systems. From the process-per-connection model to the groundbreaking Asynchronous I/O (AIO) features of PostgreSQL 18, learn the internals that separate database architects from administrators. Don't just tune knobs; understand the machine.

Postgres woke you up at three in the morning. Same code. Same hardware. Something changed. This book explains what changed and why, starting from the one idea that makes everything else legible: MVCC.

Most developers treat Hibernate as a black box that turns objects into rows. This book opens the box, shows you exactly what happens inside, and teaches you how to make it work for you at scale.

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 four real mobile apps from scratch — no coding experience required. Claude Code handles the code. You handle the idea.

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 treating PostgreSQL like slightly broken MySQL and start using it the way it was designed.

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.

The problem-first SQL cookbook for analysts. Find your problem, copy the query, get back to work. Tested on PostgreSQL 17.

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.