Leanpub Header

Skip to main content

Filters

Category: "Databases"

Books

  1. AI-Driven Database Query Optimization
    AI-Driven Database Query Optimization
    From Cost Models to Neural Optimizers — A Practical Engineering Guide
    Steve Publications

    What happens when AI starts making the decisions behind your database queries? This practical guide explores how modern optimizers work, then shows how machine learning and reinforcement learning can improve them. Learn to build, test and deploy AI-driven optimization systems that deliver real performance gains.

  2. Reverse Engineering Databases and Storage Formats
    Reverse Engineering Databases and Storage Formats
    From Binary Bytes to Complete Understanding
    Steve Publications

    What really happens inside a database file? Learn to read binary data like a map, uncover hidden structures and turn raw bytes into a working understanding of how storage engines work. With hands-on examples from SQLite, PostgreSQL, InnoDB and more, this book shows you how to reverse engineer unfamiliar formats from the ground up.

  3. Building Database Engines from Scratch
    Building Database Engines from Scratch
    A Hands-On Guide to Storage, Concurrency, Query Processing, and Reliability in Systems Programming
    Steve Publications

    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.

  4. Deep dive into a SQL query
    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. A Data Engineer's Manual
    A Data Engineer's Manual
    Joseph W. Clark, Ph.D.

    Data engineers are the unsung heroes who make analytics and data-driven applications possible.  This handbook introduces the fundamentals of what it's like to work with data, and the skills and concepts needed to develop "data products" in the real world.

  6. Lift the Elephant
    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.

  7. Rust Projects - Write a Redis Clone
    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!

  8. Database Engine Level Thinking
    Database Engine Level Thinking
    Building a mental model of PostgreSQL internals — written while learning
    Kareem Ashraf

    Stop only using databases — start understanding them. A living study of PostgreSQL internals for backend engineers: how pages, indexes, and WAL actually work, written clearly while learning, not after mastery.

  9. Data Warehousing Concepts For Data Professionals
    No Description Available
  10. Thinking in PostgreSQL
    Thinking in PostgreSQL
    A field guide to PostgreSQL for MySQL engineers
    Nick Vyzas

    Stop treating PostgreSQL like slightly broken MySQL and start using it the way it was designed.

  11. Design Driven Data Engineering
    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.

  12. Datenbanken
    Datenbanken
    Skalierung, Datenmodelle, Cloud
    Christine Koppelt, Lucas Dohmen, INNOQ, Marco Steinke, and Robert Glaser

    Entwickler:innen haben heute eine Vielzahl von Optionen, wenn es um die Wahl einer Datenbank für ihre Anwendung geht. Dieses Buch gibt einen Überblick über Datenmodelle, Konzepte zur Skalierung und Betriebsformen – von relationalen Systemen über dokumenten- und graphbasierte Ansätze bis hin zu Zeitreihen- und Vektordatenbanken. Es bietet Hilfestellung bei der Auswahl und Einordnung für unterschiedliche Anwendungsszenarien.

  13. Discrete Mathematical Algorithm, and Data Structure
    Discrete Mathematical Algorithm, and Data Structure
    Major Components of Mathematics, and Computer Science Explained with the help of C, C++, PHP, Java, C#, Python, and Dart
    Sanjib Sinha

    Readers will learn discrete mathematical abstracts as well as its implementation in algorithm and data structures shown in various programming languages, such as C, C++, PHP, Java, C#, Python and Dart. This book combines two major components of Mathematics and Computer Science under one roof.

  14. Software Development Axioms, 2nd Edition
    Software Development Axioms, 2nd Edition
    Simple Rules for Higher Quality
    John "g$" Gmutza

    The software landscape is more crowed than ever! New frameworks seem to arrive weekly.  There are tons of books out there about mastering specific frameworks, but here is one to help you master the one constant factor, no matter where you are:  constructing the source code. Build great things in any programming notation; the rules are inside...

  15. System Design Engineering Handbook
    System Design Engineering Handbook
    A Practical Field Manual for Designing, Reviewing, and Operating Production Software Systems
    Fadi Al-Najar

    Master practical system design with 62 parts covering distributed systems, scalability, databases, security, and production architecture. A comprehensive engineering handbook with real-world examples, diagrams, and decision frameworks.