Skip to content

Database

数据库相关知识体系 —— 关系型、KV、时序等存储引擎的长期沉淀: 日常运维、内部机制、排障实践。

Sub Topics

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