#databases

Moved 200TB of data between databases with zero downtime. Dual-write → shadow reads → cutover. Boring engineering at its finest.

Optimized a query from 12 seconds to 4 milliseconds today. Added one index. That's the job sometimes — knowing where to put the index.

CockroachDB for global distribution, Postgres for everything else. That's my database decision tree.

数据库选型不要追新。MySQL 和 PostgreSQL 能覆盖 90% 的场景。稳定压倒一切。