Writing

Notes on data engineering, analytics, and building LLM-powered systems that survive production.

October 4, 20266 min read
A Year of LLM Traffic, in a Browser Tab
6.12 billion production LLM requests, explored interactively with DuckDB-WASM and Mosaic. No backend: a one-time rollup turns the 91 GB Parquet file on AWS S3 into 24 MB for the charts, and raw rows are still read live from S3.
DuckDBParquetMosaicAWS S3LLM ServingData Engineering
September 19, 202612 min read
A Million Rows, 30 Milliseconds a Frame
DuckDB reads Parquet, Mosaic coordinates the views, and every interaction costs three small queries against a cube built while your hand was still moving. An analytics architecture a platform team can build in a week.
DuckDBParquetMosaicData PlatformArchitectureAnalytics Engineering