Tag: #database-internals
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 2 posts
The SQLite WAL-Reset Bug: A Data Corruption Race That Hid for 15 Years
On March 3, 2026, SQLite developer Dan found and fixed a data race that could, rarely, corrupt a database in WAL mode. The bug lived in every version from 3.7.0 (2010-07-21), when WAL was introduced, through 3.51.2 (2026
2026-07-16 · 18 min read #sqlite#wal#database-internals#concurrency#data-raceDatabase Internals Complete Guide 2025: Storage Engines, B-Tree, LSM-Tree, MVCC, WAL
Everything about DB internals! Storage engines (InnoDB/RocksDB/WiredTiger), B-Tree vs LSM-Tree, Buffer Pool, WAL (Write-Ahead Log), MVCC (Multi-Version Concurrency Control), Query Optimizer, Transaction Isolation Levels,
2026-04-14 · 26 min read #database-internals#storage-engine#btree#lsm-tree#mvcc