PostgreSQL

The problem-first SQL cookbook for analysts. Find your problem, copy the query, get back to work. Tested on PostgreSQL 17.

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.

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.

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.

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.

This book is written by a Raspberry Pi enthusiast, so, it could be hopefully interesting for other Raspberry Pi enthusiasts. Also, as it is about enterprise development, it can be eventually useful for any IT specialist dealing with enterprise applications and services.