Leanpub Header

Skip to main content

Filters

Category: "Databases"

Books

  1. System Design for the LLM Era
    Patterns and Principles for Production-Grade AI Architecture
    Sampriti Mitra

    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.

  2. Build a SQL Database Engine in C++
    Through Challenges --- Storage and Query Processing (Parts I & II)
    Hatem M.

    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.

  3. Northwind Elixir Traders
    Learn Elixir and database modeling with Ecto and SQLite, all in one project
    Isaak Tsalicoglou

    Built for the curious, this isn’t your average programming book—it’s nearly 500 pages of hands-on mentorship beyond coding, fusing core skills in Elixir, Ecto, and SQLite with business experience and R&D tenacity. Think of it as a $500 course distilled into one powerhouse resource, with tons of learning-by-doing, in a single project. Acquire hard skills in Elixir and database modeling with Ecto's migrations, changesets, and more, re-imagining a classic database that millions around the world have used before for learning. By fearlessly ditching the "happy path", this immersive, exploratory, memorable, project-based tutorial helps you confidently tackle real-world projects with Elixir and Ecto.

  4. Deep dive into a SQL query
    A Journey Through PostgreSQL's Query Processing
    Jesús Espino

    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.

  5. Code a database in 45 steps (Go)
    a series of test-driven small coding puzzles
    Lowram Eepson

    This series of test-driven small coding puzzles lets you code a database from scratch (no dependencies).We'll cover KV storage engines, LSM-Tree indexes, SQL, concurrent transactions, ACID, etc.

  6. Build Your Own Database in Go From Scratch
    From B+tree to SQL in 3000 lines
    build-your-own.org

    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.

  7. Metagraph for AI Agents
    Volodymyr Pavlyshyn

    Metagraphs for Agentic AI: Beyond Triples, Beyond HypergraphsFrom Knowledge Graphs to Knowledge ArchitecturesThe triple is not enough.Every AI engineer building agent memory hits the same wall. You model a meeting as a knowledge graph triple — and immediately lose the fact that five people were in the room, a decision was made, and that decision caused three downstream actions. You reify. You flatten. You create workarounds. And your "knowledge graph" becomes a tangle of auxiliary nodes that machines can traverse but no human can reason about.This book shows you the way out. What You'll Learn Metagraphs are graph structures where edges connect sets of nodes to sets of nodes — and where edges themselves can be referenced as first-class nodes. They are the missing data structure for AI agents that need to remember, reason, and coordinate like humans do.This book takes you on a complete journey:Hypergraphs first. You'll learn what they are, why they matter, and where they break down. You'll implement them three ways — in SQL, in LadybugDB (Cypher), and in TypeDB — so you understand the tradeoffs viscerally, not just theoretically.Then metagraphs. You'll see how metagraphs solve the fundamental hypergraph problem (edges that can't be nodes), explore RDF named graphs as a lightweight metagraph, and implement full metagraphs in the same three database paradigms with production-ready, commented code.Then the big ideas. Semantic Spacetime. Holonic systems. Human cognitive architecture mapped to graph structures. Multi-agent coordination. Promise Theory for autonomous AI networks. This is where metagraphs stop being a data structure and become an architecture for intelligence. Who This Book Is For You're a software engineer, AI researcher, or knowledge graph practitioner who builds real systems. You've used Neo4j or RDF stores. You've built RAG pipelines. You've felt the limits. You want to know what comes next.No PhD required. Every concept comes with working code in SQL, Cypher, TypeQL, SPARQL, and Python. What Makes This Book Different This isn't a theoretical monograph. It's the distillation of two and a half years of research, 130+ published articles, and hands-on implementation at the intersection of knowledge graphs and agentic AI.Every chapter bridges theory and practice. You'll read about Basu and Blanning's formal metagraph definition — and then build the schema in PostgreSQL. You'll learn Mark Burgess's Promise Theory — and then model a multi-agent coordination protocol as a six-layer promise graph. You'll understand why labeled property graphs are secretly metagraphs — and what that means for your Neo4j deployment today. 18 Chapters. Three Parts. One Argument. Part I — The Hypergraph Foundation (7 chapters): From the knowledge representation crisis through hypergraph theory to three complete database implementations.Part II — The Metagraph Solution (5 chapters): Metagraphs as the answer, RDF named graphs as a bridge, and three full metagraph implementations with detailed commentary.Part III — Theory Meets Practice (6 chapters): Semantic Spacetime, labeled property graphs, AI memory and human cognition, holonic systems, agent-to-agent interaction, and Promise Graphs for network-of-networks coordination. The Core Thesis If you want AI agents that reason like humans, you need knowledge structures that capture how humans actually organize knowledge — not as flat collections of facts, but as nested, hierarchical, context-rich, temporally-aware structures where relationships themselves carry meaning and can be the subject of further reasoning.Metagraphs are that structure. This book shows you why, and how to build with them.

  8. Build Your Own Redis with C/C++
    Network programming, data structures, and low-level C.
    build-your-own.org

    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!

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

  10. The DuckDB Handbook
    A Comprehensive Guide to In-Memory Analytical Processing
    Steve Publications

    DuckDB has changed how people work with data by bringing fast analytical queries to a lightweight embedded database. Whether you are exploring Parquet files, building data pipelines or embedding analytics into your application, this handbook shows you how to get the most out of DuckDB with practical examples and real-world techniques.

  11. SQL Mastery Series
    A Problem-Solving Workbook — 84 Solved SQL Challenges from Beginner to Interview-Ready
    Hatem M.

    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.

  12. Rust Projects - Write a Redis Clone
    Explore asynchronous programming with the actor model using Rust and Tokio
    Leonardo Giordani

    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!

  13. Lift the Elephant
    Scaling PostgreSQL Beyond Query Optimization
    Alex Yarotsky

    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.

  14. Design Driven Data Engineering
    Design-Driven Data Engineering: From Business Domain Models to Production Data Systems
    Kevin Languedoc

    Most data engineering projects fail not because of technology—but because of design.Design-Driven Data Engineering reveals a powerful new approach: start with business design, shape clarity through information modeling, and only then build systems that scale. This book gives you the frameworks, blueprints, and real-world patterns to design architectures aligned with business value, analytics needs, and modern AI-era requirements. Whether you’re an engineer, architect, analyst, or technical lead, this guide shows you how to turn complexity into clarity—and build data systems that actually work.

  15. Modelación de base de datos relacional.Normalización y documentación de base de datos.Programación DDL en MySQL, Oracle y SQL Server.