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