PostgreSQL

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.

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.

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

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.