# dunwu/db-tutorial

📚 后端程序员应该掌握的主流数据库知识

Repository: https://github.com/dunwu/db-tutorial
Canonical: https://ross.abutalabs.com/products/db-tutorial
Homepage: https://dunwu.github.io/db-tutorial/
Language: Java
License: CC-BY-SA-4.0
License Family: other
Topics: database, sql, nosql, mysql, db, mongodb, elasticsearch, redis, hbase
Last push: 2024-10-08T23:22:25+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3312, "days_push": 694, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 5363, forks 650 (observed 2026-08-28T04:09:16.061145+00:00)

## What it is
A Chinese-language open-source database tutorial covering relational databases (MySQL, PostgreSQL), NoSQL systems (Redis, MongoDB, HBase, Elasticsearch), and distributed storage theory. It is published as an online ebook via GitHub Pages and includes interview summaries and practical guides.

## Use cases
- learn mysql internals like transactions, locks, and indexes
- prepare for backend database interview questions
- understand redis data types, persistence, and clustering
- study distributed systems concepts like raft consensus and sharding
- get a mongodb tutorial covering crud, aggregation, and sharding
- learn sql syntax from basics to advanced features
- compare nosql database options for a project

## When to choose
- you want a comprehensive, free reference on mainstream databases
- you are a backend developer preparing for interviews
- you need Chinese-language database learning material
- you want both theory (distributed consensus) and practical guides in one place

## When to avoid
- you need official, version-specific product documentation
- you require English-language tutorials
- you want hands-on interactive exercises rather than reading material

## Facets
- artifact type: learning-resource
- maturity: active
- function: database, documentation, developer-tools
- domain: databases, tutorials, developer-tools, backend
- platform: cross-platform
- tags: mysql, redis, mongodb, elasticsearch, nosql, sql, distributed-systems, interview-prep, chinese-language, web-server

## Member repositories
- dunwu/db-tutorial (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:16.061145+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:58:44.595206+00:00, confidence not recorded.
  - readme: https://github.com/dunwu/db-tutorial (fetched 2026-08-28T04:09:16.061145+00:00, sha dda0e5bd751f)
  - homepage: https://dunwu.github.io/db-tutorial/ (fetched 2026-08-29T08:52:55.245516+00:00, sha 1688f672b7bb)
- Data as of 2026-08-30T08:39:29.467469+00:00.
