Categories Misc Benchmarking SQLite inserts Bugs From ignoring C Operator Associativity Hello World SQL Graph Query Interfaces: A Comparison Between SQL and Cypher Wrangling JSON with DuckDB Lateral Joins & Iterators in SQL SQL Grouping sets, Rollups & Cube Speeding up unique constraint checks in Postgres... or not Golang Logging in Go Handling panics from goroutines you've spawned Go Channels Suffice for Synchronization Computer Systems Hybrid Locking & Synchronization Optimizing CPU & Memory Interaction: Matrix Multiplication x86 Cache Control Instructions Retrieving Memory and Cache Organization Microbenchmarking: Way more than I set out to know Malloc excess bytes Distributed Systems Optimizing Data Placement for Distributed OLAP Systems Getting started with TLA+ End-to-End Arguments in System Design Distributed Reference Counting DuckDB Graph Query Interfaces: A Comparison Between SQL and Cypher Some Notes on Vector Indexing in DuckDB Combining Lexical and Semantic Search with Reciprocal Rank Fusion Vector Indexing and Search with DuckDB & FastEmbed DuckDB JIT Compiled UDFs with Numba Vectorized DuckDB UDFs with Rust and Python FFI Parquet + Zstd: Smaller faster data formats Programmatically creating a DuckDB table from an Arrow schema Python DuckDB JIT Compiled UDFs with Numba Vectorized DuckDB UDFs with Rust and Python FFI Programmatically creating a DuckDB table from an Arrow schema Timeseries Archiving Time-Series Data from PostgreSQL into Parquet Handling Missing Values in Timeseries Datasets Discrete Optimization Guided Local Search for the Capacitated Facility Location Problem Minizinc: Alternative Modeling Approaches for the Facility Location Problem The Facility Location Problem Database Internals Leanstore: High Performance Low-Overhead Buffer Pool Tiered Storage via 2-Tree Pointer Swizzling Buffer Pools Compacting Transactional Data in HyPer Virtual Memory Hot/Cold Data Re-organization for OLTP Offline (but Faster and more Accurate) Classification of Hot and Cold Data Anti-Caching Larger-Than-Memory Data Management RAG Some Notes on Vector Indexing in DuckDB Combining Lexical and Semantic Search with Reciprocal Rank Fusion Vector Indexing and Search with DuckDB & FastEmbed Cache LRU vs FIFO (with Lazy Promotion and Quick Demotion) Notes on 'A large scale analysis of hundreds of in-memory cache clusters at Twitter' Systems LRU vs FIFO (with Lazy Promotion and Quick Demotion) Notes on 'A large scale analysis of hundreds of in-memory cache clusters at Twitter' PostgreSQL Archiving Time-Series Data from PostgreSQL into Parquet