Database
数据库相关知识体系 —— 关系型、KV、时序等存储引擎的长期沉淀： 日常运维、内部机制、排障实践。
Sub Topics
- PostgreSQL：日常运维与机制知识 —— 会话诊断、WAL 与 LSN、复制等
- KV 数据库：KV 存储引擎知识 —— RocksDB / LevelDB / Pebble / Badger / LMDB / redb / bbolt 对比，以及 Bitcask（日志结构哈希表）模型
Backlinks (1)
flowchart LR
n0["Maps"]
n1["CRC（循环冗余校验）原理"]
n2["Algorithms"]
n3["Database"]
n4["Bitcask 存储模型（日志结构哈希表）"]
n5["KV 数据库对比"]
n6["KV 数据库"]
n7["PostgreSQL 活跃会话诊断（Active Sessions）"]
n8["PostgreSQL 磁盘占用查看（Table Size / Datafile）"]
n9["PostgreSQL"]
n10["PostgreSQL 内存占用查看（Memory / Buffers / Connections）"]
n11["PostgreSQL 查看慢查询（Slow Query）"]
n12["PostgreSQL WAL 与 LSN"]
n13["Knowledge"]
n14["Cloud"]
n15["对象存储基本用法（Bucket / Object / 常用操作）"]
n16["对象存储数据迁移（R2 → MinIO / 跨厂商搬迁）"]
n17["Object Storage"]
n18["挂载 Bucket 为本地文件系统（FUSE Mount）"]
n19["对象存储签名 URL（Signed URL）原理与实战"]
n20["对象存储供应商对比（S3 / R2 / OSS / Supabase / MinIO）"]
n21["Infrastructure"]
n22["Prototypes"]
n23["Research"]
n24["Protomaps 自建底图研究"]
n25["自制 PMTiles 地图（最简单例子）"]
n26["MapLibre 集成 Protomaps"]
n27["PMTiles 格式与工具链"]
n28["上海地区底图项目"]
n2 --> n1
n3 --> n6
n3 --> n9
n5 --> n4
n6 --> n4
n6 --> n5
n9 --> n7
n9 --> n8
n9 --> n10
n9 --> n11
n9 --> n12
n10 --> n7
n10 --> n8
n11 --> n7
n13 --> n2
n13 --> n3
n13 --> n21
n14 --> n17
n15 --> n16
n15 --> n19
n15 --> n20
n15 --> n22
n16 --> n15
n16 --> n18
n16 --> n19
n16 --> n20
n17 --> n15
n17 --> n16
n17 --> n18
n17 --> n19
n17 --> n20
n18 --> n15
n18 --> n19
n18 --> n20
n19 --> n22
n20 --> n15
n20 --> n16
n20 --> n19
n20 --> n22
n21 --> n14
n22 --> n4
n22 --> n15
n22 --> n18
n22 --> n19
n22 --> n20
n22 --> n24
n23 --> n24
n24 --> n0
n24 --> n25
n24 --> n26
n24 --> n27
n24 --> n28
n25 --> n27
n26 --> n22
n26 --> n28
n27 --> n25
n27 --> n28
n28 --> n26
n28 --> n27
click n0 "../../collection/maps/" "Maps"
click n1 "../algorithms/crc/" "CRC（循环冗余校验）原理"
click n2 "../algorithms/" "Algorithms"
click n3 "./" "Database"
click n4 "kv/bitcask/" "Bitcask 存储模型（日志结构哈希表）"
click n5 "kv/comparison/" "KV 数据库对比"
click n6 "kv/" "KV 数据库"
click n7 "postgresql/active-sessions/" "PostgreSQL 活跃会话诊断（Active Sessions）"
click n8 "postgresql/disk-usage/" "PostgreSQL 磁盘占用查看（Table Size / Datafile）"
click n9 "postgresql/" "PostgreSQL"
click n10 "postgresql/memory-usage/" "PostgreSQL 内存占用查看（Memory / Buffers / Connections）"
click n11 "postgresql/slow-queries/" "PostgreSQL 查看慢查询（Slow Query）"
click n12 "postgresql/wal-lsn/" "PostgreSQL WAL 与 LSN"
click n13 "../" "Knowledge"
click n14 "../infrastructure/cloud/" "Cloud"
click n15 "../infrastructure/cloud/object-storage/basic-usage/" "对象存储基本用法（Bucket / Object / 常用操作）"
click n16 "../infrastructure/cloud/object-storage/data-migration/" "对象存储数据迁移（R2 → MinIO / 跨厂商搬迁）"
click n17 "../infrastructure/cloud/object-storage/" "Object Storage"
click n18 "../infrastructure/cloud/object-storage/mount-bucket/" "挂载 Bucket 为本地文件系统（FUSE Mount）"
click n19 "../infrastructure/cloud/object-storage/signed-url/" "对象存储签名 URL（Signed URL）原理与实战"
click n20 "../infrastructure/cloud/object-storage/vendors-comparison/" "对象存储供应商对比（S3 / R2 / OSS / Supabase / MinIO）"
click n21 "../infrastructure/" "Infrastructure"
click n22 "../../prototypes/" "Prototypes"
click n23 "../../research/" "Research"
click n24 "../../research/topics/protomaps/" "Protomaps 自建底图研究"
click n25 "../../research/topics/protomaps/make-own-map/" "自制 PMTiles 地图（最简单例子）"
click n26 "../../research/topics/protomaps/maplibre/" "MapLibre 集成 Protomaps"
click n27 "../../research/topics/protomaps/pmtiles/" "PMTiles 格式与工具链"
click n28 "../../research/topics/protomaps/shanghai-map/" "上海地区底图项目"