PostgreSQL

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.

The recipes in this book are practical answers to the kind of problems that real Django applications encounter, sometimes on the first day of a project and sometimes deep into the life of a codebase that has grown well beyond its original design. This book is written to guide you to utilize Django 6.0 capabilities in your apps with ease of implementation.

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.

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.

Turn data into dollars. Learn how modern traders use algorithms to make smart, emotion-free decisions in the markets

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.

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.

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.

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.

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.

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.