DuckDB PR3 — Investigating ART Checkpoint Overhead Behind Insert Slowdowns
Reproducing a 244% increase in batch latency and tracing how persistent Adaptive Radix Tree (ART) indexes affect insert performance as a DuckDB table grows.
The Shadow Byte
Latest articles
Building an LSM-Tree MemTable in C++: Engineering Discipline Behind the Implementation
Five principles for designing functions, controlling access, reducing redundancy, reasoning about correctness, and using LLMs without outsourcing engineering judgment.
Building an LSM-Tree MemTable in C++: Small-Buffer Optimization and Heap Allocation for Lookup Keys
A C++ design investigation into variable-length keys, stack-versus-heap allocation, CPU cache behavior, and the performance trade-offs of temporary search objects.
DuckDB PR2 — Phase 1: Finding the First Bad Commit with Git Bisect
Automating a memory-leak regression test across DuckDB versions with a Bash test harness
Building with AI Without Outsourcing the Thinking
A six-stage, LLM-assisted development process for specification, interface design, invariant-driven testing, implementation, sanitizer debugging, and adversarial code review
DuckDB PR2 — From One Issue to the Next PR Candidate
Tracing a DuckDB memory leak from ON CONFLICT ... DO UPDATE through ART index updates and checkpoint cleanup
DuckDB PR1 — Phase 2: Investigating the Double-Free
..reproducing a DuckDB memory-safety bug with AddressSanitizer, automated test matrices, controlled memory and thread limits, and historical-version analysis.