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.

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.

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.

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

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

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.

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

In this book, you and I will build a sample book-selling application that evolves as you progress. You'll start by setting up Rust, Cargo, and Leptos in VS Code, compiling your first WebAssembly bundle, and watching "Hello, LibroCommerce!" light up your browser. You'll design a microservice-inspired architecture, model data with Serde-annotated structs, implement CRUD operations, secure every endpoint, then broadcast channels, and finally you get to write Playwright end-to-end tests that spin up headless browsers, place orders, and assert live status updates, all inside your continuous integration pipeline.

In today’s project-based, SCRUM “infested” web development work scene you are either a Junior starting out or a Senior who lacks in-depth knowledge. There seems to be no in-between! After reading this book you will be a Medior PHP Developer who can deliver a fully-fledged API from start to finish!

PostgreSQL to potężna, wszechstronna baza danych, a ta książka to Twój kompletny przewodnik po jej możliwościach. Od podstaw – tworzenia tabel i operowania danymi – po zaawansowane techniki optymalizacji, bezpieczeństwa i integracji z aplikacjami. Zdobędziesz praktyczne umiejętności w zakresie relacji między tabelami, indeksowania, transakcji oraz analizy zapytań. Książka zawiera liczne przykłady i projekty, dzięki którym nauczysz się budować systemy bazodanowe od podstaw oraz optymalizować ich wydajność. Niezależnie od tego, czy dopiero zaczynasz, czy chcesz udoskonalić swoje umiejętności, znajdziesz tu wszystko, czego potrzebujesz do efektywnej pracy z PostgreSQL.