Databases

Build a working SQL database engine in C++20 -- from raw pages to a realquery executor -- one compilable, measured challenge at a time. Everyperformance claim is a benchmark you run yourself; every unit ends with areal bug, caught red-handed and fixed. Nothing asserted. Everythingdemonstrated.

Master distributed systems through visual diagrams — from clock drift and CAP to Paxos, Raft, and distributed transactions, explained with clear illustrations instead of dense academic papers.

Learn databases from the bottom up by coding your own, in small steps, and with simple Go code (language agnostic).Atomicity & durability. A DB is more than files!Persist data with fsync.Crash recovery.KV store based on B-tree.Disk-based data structures.Space management with a free list.Relational DB on top of KV.Learn how tables and indexes are related to B-trees.SQL-like query language; parser & interpreter.Concurrent transactions with copy-on-write data structures.

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.

You know how to code, but everyone else seems to "just get it" while you secretly Google and ChatGPT everything. The Software Realm DECODED is the patient mentor conversation you've been searching for, Peter asks the questions you're afraid to ask, and the Ultra Senior Developer explains what bootcamps skip and seniors assume you know. By the final chapter, the imposter syndrome disappears and systems finally make sense.

This book provides an introduction to the high-level concepts behind query engines and walks through all aspects of building a fully working SQL query engine in Kotlin.

STOP building fragile AI wrappers. START designing resilient AI systems. Lots of companies are trying to make their small AI experiments into big products, but they don't have a good plan. Engineers need a practical guide to build these new AI systems the right way - so they can handle scale, be reliable, and won't cost too much. This book is that guide. It explains how to design systems that use AI models. This book breaks down the architecture of real AI applications, like an AI-powered code editor or a smart learning app. It gives you a deep, practical look at the real-world challenges and solutions for building these systems. It discusses system design concepts for systems that use LLMs.

RAG, Agent Bricks, the Multi-Agent Supervisor with MCP, Lakebase, MLflow 3, Lakehouse Monitoring, Feature Store, Vector Search. Every AI surface Databricks shipped at GA in 2025 and 2026, taught by a practitioner, current to 2026. What you will learn - Build RAG pipelines with Vector Search, embedding models, and citation grounding- Ship Agent Bricks for classification and information extraction- Orchestrate specialist agents with the Multi-Agent Supervisor and MCP- Use Lakebase as the operational Postgres layer for AI apps and agents- Detect data and model drift with Lakehouse Monitoring; wire alerts to retraining- Manage the ML lifecycle with MLflow 3 and the UC Model Registry- Govern features across training and serving with Feature Store (offline + online)- Serve foundation and custom models with AI Gateway controls Who this book is for Data engineers, ML engineers, and AI/ML architects who know PySpark and the Databricks platform and now need to ship production AI. Volume 3 is the recommended prerequisite. Table of Contents 1. Databricks SQL in Production. Warehouses, materialized views, three latency signals (admission, compilation, execution), the full dashboard backend wiring.2. External BI: Tableau, Power BI, dbt. Performance tips that take a dashboard from sluggish to instant, dbt configuration at incremental scale, the seam between BI and the lakehouse.3. AI/BI Dashboards. Anatomy of a Lakeview dashboard, draft vs published flow, the Dashboard Agent's reliable patterns, the five-grant permission model.4. Genie: Natural-Language Analytics. Grounding sources, the priority rule, the SQL Genie actually writes, the questions Genie answers cleanly versus the ones that confuse it.5. AI SQL Functions. ai_query, ai_parse_document, ai_extract for PDFs and HTML, univariate forecasts, the daily cost math for production AI SQL pipelines.6. Model Serving. Endpoints, the three fields that decide capacity and cost, the chat-completion payload, the five moving pieces of a production recommender.7. Foundation Models. Five major providers, the External Models config, the vendor-swap pattern (Claude to Gemini in hours, not weeks), the three habits that keep swap cost low.8. Vector Search and RAG. Six delta-sync arguments, three chunking strategies compared, the RAG function your app imports, end-to-end answer evaluation with traces.9. MLflow 3 and UC Model Registry. Versions, aliases, tags (and what each is not for), five tracking calls and what each one writes, the experiment-to-production lifecycle.10. Feature Store. Why SDP is the right producer, the six-file project layout, four parity-failure classes between offline and online stores and what causes each.11. MLOps as a Practice. Seven sources every incident reads from, three deploy patterns (canary, shadow, blue-green), three retrain strategies, five golden signals for an ML endpoint.12. Lakehouse Monitoring: Drift Detection. Six monitor parameters, the loop from drift alert to retraining, what to do when the baseline table is missing.13. Distributed Deep Learning. Three signals that force distributed training, picking the flavor (data, model, hybrid) from the bottleneck, four pieces of GPU memory worked out for a 7B model.14. Agent Bricks. Declarative classification and information-extraction agents, eval-set ingredients, the pre-compute pattern that makes small seed sets work.15. Multi-Agent Supervisor and MCP. The supervisor build, synthetic-turn evaluation, three real conversations end to end, the auth-passthrough chain across child agents.16. Lakebase: Operational Postgres for AI. Five alternatives compared, sub-10ms reads for AI apps, the lineage from Delta source through SDP into Postgres and onward to the endpoint.17. Capstone: Retail Intelligence App. Ten stages, each anchored to an earlier chapter. The smoke test that confirms every stage of the platform is reachable, the new-data path through the recommender.18. Certification and What's Next. The certification paths that actually map to the book, and the reading list the on-call team uses when something breaks.

Build real-world software by coding a Redis server from scratch.Network programming. The next level of programming is programming for multiple machines. Think HTTP servers, RPCs, databases, distributed systems.Data structures. Redis is the best example of applying data structures to real-world problems. Why stop at theoretical, textbook-level knowledge when you can learn from production software?Low-level C. C was, is, and will be widely used for systems programming and infrastructure software. It’s a gateway to many low-level projects.From scratch. A quote from Richard Feynman: “What I cannot create, I do not understand”. You should test your learning with real-world projects!

Go from your first SQL query to solving real database problems with confidence. This hands-on guide covers everything from SQL fundamentals and data analysis to advanced queries, optimization and production best practices, with practical examples that work across today’s major database systems.

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.

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

Libérez la puissance de DuckDB pour l’analytique géospatiale moderne. Ce guide pratique aide les professionnels du SIG à maîtriser une gestion efficace des données spatiales, en transformant d’énormes jeux de données réels en informations exploitables grâce au SQL, à Python et à l’extension spatiale de DuckDB. Une édition papier couleur est disponible sur Amazon.

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.

Explore the power of Rust with "Rust Projects: Write a Redis Clone". This hands-on guide takes you through building a Redis-inspired database from the ground up, introducing key programming concepts like TCP connections, the RESP protocol, and concurrency. Following the CodeCrafters challenge, this book gradually builds your skills, making complex topics accessible. Whether you're new to Rust or looking to deepen your understanding, this project-based journey offers practical, real-world insights into modern systems programming. The book contains 40% discount code for CodeCrafters.io!