git404hub

what is awesome-database-learning fr?

pingcap/awesome-database-learning — explained in plain English

Analysis updated 2026-06-24

10,830Audience · developerComplexity · 1/5Setup · easy

tl;dr

A curated reading list of research papers, university courses, and blog posts covering database internals, from query optimizers and storage engines to distributed consensus and transaction handling.

vibe map

mindmap
  root((repo))
    What It Does
      Reading list
      Database internals
      Academic papers
    Topics
      Query optimization
      Storage engines
      Transactions
      Distributed consensus
    Resources
      Research papers
      University courses
      Blog posts
    Audience
      Backend engineers
      Database builders

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

what do people make with this?

VIBE 1

Follow a structured path from knowing SQL to understanding what the database actually does when your query runs.

VIBE 2

Find the original papers on B-trees, LSM trees, or log-structured storage before implementing your own storage engine.

VIBE 3

Study Volcano and Cascades optimizer frameworks to understand how production databases turn SQL into execution plans.

VIBE 4

Research distributed consensus algorithms like Raft or Paxos from primary academic sources before building a distributed system.

how it stacks up fr

pingcap/awesome-database-learningwickynilliams/headroom.jsphalcon/cphalcon
Stars10,83010,83010,831
LanguageJavaScriptPHP
Setup difficultyeasyeasymoderate
Complexity1/52/53/5
Audiencedeveloperdeveloperdeveloper

Figures from each repo's GitHub metadata at analysis time.

how do i run it?

Difficulty · easy time til it works · 5min
No license information was found in the repository description.

in plain english

This repository is a reading list for people who want to understand how databases work on the inside. It was put together by PingCAP, the company behind the TiDB database, and is aimed at engineers who want to go deeper than just using databases to actually understanding how they are built. The list is organized by topic rather than by difficulty. Each section covers a specific component of a database system, such as query optimization, transaction handling, storage engines, data replication, or consensus algorithms. Within each topic, you will find links to research papers, university course materials, blog posts, and recorded talks. The papers include many classic publications from database conferences going back to the 1970s, alongside more recent work on distributed systems. Some sections are highly technical. Query optimization, for example, covers papers on optimizer frameworks like Volcano and Cascades, which are the architectures that real production databases use to turn a SQL query into an efficient execution plan. The storage section covers data structures like B-trees and log-structured merge trees, which control how data is physically written to disk. There are also sections on concurrency control, network protocols, benchmarking, and formal verification using a specification language called TLA+. There is no code to run in this repository. It is purely a reference collection. A number of links are in Chinese, reflecting the original audience, but many of the papers and course materials are in English. For someone who wants to go from knowing how to write SQL queries to understanding what happens underneath when those queries run, this list provides a structured path through the academic and engineering literature on the subject.

prompts (copy fr)

prompt 1
I want to understand how a SQL query optimizer works from first principles. Based on the papers in awesome-database-learning, what should I read first and in what order?
prompt 2
Explain to me how an LSM tree works and why databases like RocksDB and LevelDB use it instead of a B-tree for write-heavy workloads.
prompt 3
I'm building a simple key-value store in Go. Walk me through the key design decisions for storage, indexing, and crash recovery based on classic database research.
prompt 4
What is the difference between optimistic and pessimistic concurrency control in databases? Give me concrete examples of when each is the right choice.

Frequently asked questions

what is awesome-database-learning fr?

A curated reading list of research papers, university courses, and blog posts covering database internals, from query optimizers and storage engines to distributed consensus and transaction handling.

What license does awesome-database-learning use?

No license information was found in the repository description.

How hard is awesome-database-learning to set up?

Setup difficulty is rated easy, with roughly 5min to a first successful run.

Who is awesome-database-learning for?

Mainly developer.

peek the repo → explain another one

This repo across BitVibe Labs

double-check against the repo, no cap.