Books

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.

What really happens between typing a SQL query and getting a result? Build a database engine from the ground up in Rust and find out. You’ll work through storage, indexing, concurrency, recovery and query processing while turning each chapter’s code into one working system.

The Local AI Stack: Building a Sovereign Machine Learning Workstation with Hyper-V, WSL2, and GPU Virtualization Renting GPU time from AWS costs more than the GPU. Every prompt you send to a cloud API is a prompt someone else logs. If your ML work runs on hardware you don't own, on a network you don't control, then you don't own your ML work.

What if you could build a graph database the way SQLite is built to disappear into an application? This book takes you inside the engine, from storage pages and transactions to traversal, queries and crash recovery. With complete working code, you’ll build a fast, durable embedded graph database from the ground up.

Supabase wired into Claude and Cursor over MCP, with RLS designed for agent access, service_role blast radius contained, and ten failure modes diagnosed.

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.

Go beyond the basics and learn how to get the most from RocksDB. This practical guide explains the architecture behind its speed, shows how to tune it for real workloads and helps you solve performance issues with confidence. Packed with code examples and production-focused advice, it is built for developers who need storage that scales.

SQLite is everywhere but running it well in production takes more than flipping a few settings. This book goes beyond the basics to show how SQLite really works, then walks through the patterns, tools and tradeoffs behind reliable, high-performance deployments. Packed with practical examples, it's built for engineers who want confidence in production.

The bugs live in the data. From your first SELECT to migration testing, NoSQL, and GDPR-compliant masking — with exercises all the way.

Ship the NEXUS-1 backend for real: a genuine SQL Server on every test run, a dispatcher proven under a killed process, structured logs with a correlation id, and a CI gate that will not package a red build. Two hundred tests, one Dockerfile, one honest boundary.

Slow SQL queries waste time, increase costs, and limit scalability. Mastering SQL Performance Optimization teaches you how to analyze execution plans, optimize queries and indexes, and solve real-world performance bottlenecks across today's leading database platforms.

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.

Give the tested core a database and a public API — without letting either touch its rules. Build NEXUS-1's Infrastructure and API layers in .NET: EF Core, repositories, the outbox, RFC 7807, JWT. 654 tables, one seam that stays signed — every rule proven by watching it fail.

Every click, online transaction, social media interaction, business operation, healthcare record, mobile application, and connected device generates data. However, raw data alone cannot create value. The real power lies in discovering meaningful patterns, hidden relationships, useful knowledge, future trends, and actionable insights from that data.

84 hand-picked SQL problems, fully solved and explained — from your first SELECT to interview-ready queries. Seven volumes of pure practice: a problem, the data, the answer, and why it works. No theory chapters, no filler, every query tested against a real database. Solve first, read second.