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.

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.

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.

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.

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

Analytics Patterns for Intelligent Decision Systems shows how to move beyond dashboards into analytics systems that explain, predict, recommend, optimize, and improve business outcomes.Packed with SQL patterns, KPI frameworks, forecasting models, recommendation logic, and decision intelligence templates, this book gives data professionals a practical blueprint for modern analytics.Build systems that do more than report the past — build systems that help decide what should happen next.

This book is for anyone who wants to feel more confident. Over eleven chapters, we put together a single sample application, and we watch it grow from a simple table used by one employee into a more complex system that's divided into different parts, has backups, is secure using OAuth, and is audited.

Most analytics books teach tools first and thinking later. Data Analytics Foundations reverses that order — building the judgment, technical skills, and communication discipline required to transform raw data into trusted decisions. From spreadsheets and SQL to data quality, visualization, and analytical reasoning, this book equips readers with a complete foundation for professional analytical practice.

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.

¿Qué ocurre realmente cuando PostgreSQL ejecuta tu consulta? Sigue una sentencia SQL a través de cada etapa del pipeline interno de PostgreSQL —desde el texto sin procesar hasta los resultados devueltos— y adquiere ese conocimiento profundo que transformará la forma en que escribes, optimizas y depuras aplicaciones de bases de datos.

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.

Go beyond basic CRUD. Bridge the gap between .NET abstractions and PostgreSQL internals to architect resilient, high-scale enterprise systems that handle 10k+ TPS.