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/" "上海地区底图项目"