Leanpub Header

Skip to main content

Filters

Category: "Databases"

Books

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

  2. Build AI agents that truly remember, reason, and act—entirely on user devices. Move beyond prompt engineering to create autonomous systems with graph-based memory using SQLite and LibSQL. Learn to implement hypergraphs, metagraphs, and vector search for privacy-first AI that scales to millions of entities. From personal knowledge graphs to production mobile apps, master the three pillars of agent autonomy: tools, memory, and reasoning. Real code, working examples, battle-tested in production. The future of AI is local, private, and in your hands.

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

  4. Moderne Datenzugriffslösungen mit Entity Framework Core 10.0
    Datenbankprogrammierung / Objekt-Relationales Mapping mit C# in .NET 10.0
    Dr. Holger Schwichtenberg

    Dies ist die top-aktuelle Version  dieses Fachbuchs vom 04.03.2026 auf dem Stand .NET 10.0.3 und Entity Framework Core 10.0.3.

  5. Phoenix Product Codex
    Develop and deploy a REST API for Product Data Management with Elixir and Phoenix
    Isaak Tsalicoglou

    Transform chaos into order with Phoenix Product Codex: a thrilling, real-world journey of building a production-ready REST API for product data management using Elixir and Phoenix, born from the requirements of a family-run business facing a government mandate for electronic invoicing. Learn to craft and deploy a thoughtfully-designed, business-driven solution that already serves as the Single Source of Truth for two companies, while also mastering domain modeling, database design, and more in the process. No toy examples or databases here, but actual software that delivers real impact.

  6. High-Performance Java Persistence
    Get the most out of your persistence layer
    Vlad Mihalcea

    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.

  7. Gestion des données spatiales avec DuckDB
    des bases du SQL à l’analytique géospatiale avancée
    Qiusheng Wu

    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.

  8. MonetDB on Ubuntu
    From installation to full power
    Bizkapish

    Learn how to install, configure, and use the MonetDB analytical database on Ubuntu Linux. This practical guide walks through real examples and command-line workflows, helping you quickly understand how MonetDB works and how to use it effectively for analytical SQL workloads.

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

  10. How Query Engines Work
    An Introductory Guide
    Andy Grove

    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.

  11. Truth in People’s Hands
    Designing Enterprise Systems for Mobile Timing and Distributed Responsibility
    Brian J Chavis

    Most organizations do not suffer from a lack of data. They suffer from late data.Mobile and no-code platforms have changed how quickly truth enters enterprise systems—but many experienced IT leaders still feel something important has shifted.This book explains what actually changed, what did not, and how to extend enterprise discipline safely into modern mobile workflows.

  12. PostgreSQL Internals Mastery: A Comprehensive Guide
    Volume I: Foundations & Core Concepts
    Giovanni Martinez

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

  13. Cypher 103 with ladybugdb
    Volodymyr Pavlyshyn

    Learn graph databases the hands-on way — no servers, no setup, no fluff.Hands-On LadybugDB Cypher takes you from your first MATCH to complex recursive queries, shortest-path algorithms, and real-world AI agent graphs — all running locally in under a minute. 27 chapters. One evolving project. Every Cypher concept you need. Start querying graphs today.

  14. MySQL Explained
    Your step-by-step guide to database design
    OSTraining and Andrew Comeau

    The software that's managing your data shouldn't be a mystery. MySQL is the most popular open source database and powers WordPress, Drupal, Joomla, Magento and more. You don't have to be a professional database designer to understand and make use of its tools. MySQL Explained provides a clear and accessible step-by-step tutorial that will enable you to understand how your data is being stored and even design your own custom applications!

  15. 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!