Leanpub Header

Skip to main content

Filters

Category: "Databases"

Books

  1. 这个一个用代码手搓数据库的项目。你可以通过这个项目:学习数据库底层原理和计算机基础。提升技术深度。通过实操来锻炼编程技能。获得一个完整的个人项目。可以用在简历、面试中。项目全面实现了几个最重要的部分:KV 储存引擎。SQL 与关系型数据库。索引与数据结构。虽然范围很广,但是被拆分成了多个小步骤。每个步骤都很简单,最多几十行代码。你会发现,复杂的概念可以从简单的概念演变而来,可以说是从0开始发明数据库。 作者网站上精选了一些类似的资源:程序员如何学习底层技术?可以邮件订阅作者网站。

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

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

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

  5. The Apache Ignite book
    The next phase of the distributed systems
    Shamim Bhuiyan

    The complete guide to learning everything you need to know about Apache Ignite

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

  9. Grokking AI Agents
    Career Catalyst
    Sameer Paradkar

    Master AI Agents from Architecture to ProductionBuild autonomous agent systems that actually work in production. This comprehensive guide takes you from understanding ReAct patterns to orchestrating multi-agent systems at scale. What You'll Master: ✅ Agent architectures: When to use agents vs RAG vs fine-tuning ✅ Reasoning patterns: ReAct, Chain-of-Thought, Plan-and-Execute ✅ Multi-agent orchestration with proper coordination protocols ✅ Production deployment with error handling, monitoring, cost optimization ✅ Tool calling, memory systems, and context management Who This Is For: Software engineers (2-7 years) building LLM applications, backend engineers adding agentic capabilities, senior engineers preparing for AI agent interviews at top companies. What Makes This Different: 100+ production-focused scenarios with real architectural trade-offs. Real-world examples from companies shipping agent systems . Stop building chatbots. Start building agents that take action.

  10. Grokking Generative AI
    Career Catalyst
    Sameer Paradkar

    Master Gen AI from Theory to ProductionYou don't learn Gen AI from tutorials — you learn from solving real problems. How does ChatGPT handle context and avoid hallucinations? How does Perplexity build RAG at scale? How does GitHub Copilot generate accurate code? Grokking Gen AI teaches through real-world scenarios and production patterns. 116 scenario-driven case studies covering: ✅ RAG with vector databases and hybrid search ✅ Prompt engineering with Chain-of-Thought reasoning ✅ Document processing with multi-format parsing ✅ Multi-modal AI with vision and audio ✅ Production deployment with monitoring and cost optimization Every scenario includes: production problem, architectural approaches, Gen AI patterns, decision frameworks, tool implementations, and interview-ready explanations. Learn through case studies from OpenAI, Anthropic, Google, Meta, and top AI-companies. Your journey from developer to Gen AI architect begins here — with scenarios you'll face and tools you can deploy.

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

  12. Code a database in 45 steps (Go)
    a serias 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.

  13. Grokking Data Analytics and Machine Learning
    Career Catalyst
    Sameer Paradkar

    Master Data and ML Systems at ScaleYou don't master data platforms from textbooks — you master from solving real problems at petabyte scale.Grokking Data Analytics and Machine Learning teaches through production scenarios and case studies. 100 scenario-driven case studies covering:✅ Lakehouse architecture with Delta Lake, Iceberg, Hudi✅ Real-time pipelines with Kafka, Spark, Flink✅ Feature stores with Feast for training-serving consistency✅ MLOps platforms with MLflow, SageMaker, Airflow✅ Data quality frameworks with Great Expectations✅ Multi-region data sync and model serving at scale Every scenario includes: production challenge, architectural trade-offs, data/ML patterns, decision frameworks, and interview-ready explanations. Learn through real-world case studies from Netflix, Uber, Airbnb, Spotify's petabyte-scale data and ML architectures. Your journey from data engineer to architect begins here — with scenarios you'll face and systems you can build.

  14. Grokking System Design - Advanced
    Career Catalyst
    Sameer Paradkar

    You don't master distributed systems from diagrams — you master from solving complex problems at scale. How does Netflix handle distributed transactions across regions? How does Uber orchestrate sagas for ride workflows? Grokking System Design – Advanced Track teaches through production scenarios and case studies. 124 advanced scenario-driven case studies covering: ✅ Event sourcing, CQRS, saga orchestration ✅ Service mesh with Istio configuration ✅ Distributed tracing with OpenTelemetry ✅ Workflow orchestration with Temporal ✅ Change data capture with Debezium ✅ Multi-region architectures and conflict resolution Every scenario includes: production challenge, architectural trade-offs, advanced patterns, decision frameworks, and interview explanations. Learn through real-world case studies from Google, Netflix, Uber, Meta, and Stripe's planet-scale architectures. Your journey from senior engineer to architect begins here — with scenarios you'll face and patterns you can implement.

  15. Grokking System Design - Foundation
    Career Catalyst
    Sameer Paradkar

    Master System Design from Theory to ProductionYou don't learn system design from textbooks — you learn from solving real problems. How does Netflix handle video streaming at scale? How does Uber route millions of rides? How does Slack deliver messages instantly? Grokking System Design – Foundation Track teaches through real-world scenarios and case studies. 124 scenario-driven case studies covering: ✅ Database design, sharding, replication ✅ Caching with Redis configuration ✅ Microservices with Spring Boot & Kubernetes ✅ Message queues with Kafka ✅ Load balancing with NGINX ✅ Monitoring with Prometheus Every scenario includes: production problem, architectural approaches, design patterns, decision frameworks, tool configurations, and interview-ready explanations. Learn through real-world case studies — from Google, Amazon, Meta, Netflix, and top tech companies. Your journey from developer to designers begins here — with scenarios you'll face and tools you can deploy.