PostgreSQL

Your ORM works until it doesn't: a query returns ten thousand duplicated rows, a migration refuses a partitioned table, or the feature the product needs is one PostgreSQL has had for years. Twenty-one chapters that close the gap — LINQ translation, query plans, JSONB, full-text search, PostGIS and pgvector, then auditing, multi-tenancy and deployment. Every listing run against a live database. Every output captured, never typed.

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.

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.

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.

Stop treating PostgreSQL like slightly broken MySQL and start using it the way it was designed.

I've always wanted to write a technical book. My interest in AI and Spring led me to explore, take notes, and contribute to the Spring AI project. This journey naturally progressed into sharing my knowledge through a book as my notes expanded. Spring AI for Your Organization offers a clear guide for integrating Spring AI with Google Vertex AI. It's ideal for both seasoned backend developers and newcomers, aiming to enhance your skills and understanding of AI in development. The book covers a range of topics from chatbots to advanced AI features, providing step-by-step instructions for using GCP Vertex AI. Dive into this comprehensive guide and start building smarter Spring applications today.

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 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.