Deep technical analysis of PostgreSQL's MVCC implementation and how different databases (Oracle, MySQL, SQL Server, MongoDB) make different trade-off choices. Explores the design decisions behind common database architectures.

Comprehensive technical article examining how PostgreSQL can replace specialized systems like Kafka, Redis, Elasticsearch, and ClickHouse for most production use cases, emphasizing simplicity and operational efficiency.

A deep-dive into how Notion's collaborative editing system uses CRDTs (Conflict-free Replicated Data Types) to merge concurrent edits across blocks without data loss. Technical architecture exploration.