All Articles
- Day 23: Can 5,000 Lines of C11 Outrun ClickHouse, DuckDB, and MonetDB? The Benchmark Showdown
- Day 22: The REPL Read Path & Query Planner (Binding SQL SELECT to the Vectorized Pipeline)
- Day 21: The Interactive REPL CLI & Query Engine
- Day 20: Minimal SQL & Query Parser (Lexer, Recursive Descent & AST)
- Day 19: The MergeTree Part Compactor
- Day 18: APL / K Vectorized Physical Execution Pipeline
- Day 17: The Multi-Part Table Scanner (Lazy Data Loading & Granule Pruning)
- Day 16: Partitioned Grace Hash Aggregation (Disk Spilling GROUP BY)
- Day 15: External Merge Sort (Disk-Spilling ORDER BY)
- Day 14 Bis: Table Flush & Immutable Part Serialization
- Day 14: The Table Abstraction (Ingestion Layer)
- Day 13: Roaring Bitset Deletion Vectors
- Day 12: Free-Text Inverted Block Indexing & BM25 Scoring
- Fast Vim / Neovim Editing Guide for Zed Editor (C11 Edition)
- Day 11: The Column Reader (Zero-Copy Data Loading)
- Day 10: The Sparse Primary Index (2-Tier Query Pruning)
- Day 9: Streaming Uncompressed Storage
- Day 8: SIMD APL Vector Primitives (Compress & Reduction)
- Day 7: Bitmaps & Dynamic Schema Registry
- How This Blog Is Written (LLM Socratic Method)
- Analytics & CI/CD: My Astro Blog Infrastructure
- Day 6: High Cardinality String Dictionaries
- Day 5: Column Vectors, Selection Vectors and Branchless Filtering
- Day 4: Build System, Compiler Optimizations & POSIX Micro-Benchmarking
- Day 3: Zero-Copy Memory-Mapped Files (mmap) & OS Page Cache
- Day 2: Zero-Copy Typed Slices & C11 _Generic Polymorphism
- Day 1: 64-Byte SIMD Alignment & Dynamic Column Buffers
- Day 0: Motivations, Technical Inspirations & Non-Goals