Categories Misc Benchmarking SQLite inserts Bugs From ignoring C Operator Associativity Hello World SQL 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 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 Handling Missing Values in Timeseries Datasets Timeseries and ASOF Joins 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