building clickhousegdelt Sep 30, 2026 GDELT on ClickHouse: Day 4 Timing the 2026 bulk load two ways (and getting two answers), going live on Cloud Run, and a first pass at dashboards.
building clickhousegdelt Sep 24, 2026 GDELT on ClickHouse: Day 3 Fixing a bunch of mistakes I made on day 1 & 2 and (finally) ingesting data
building clickhousegdelt Sep 21, 2026 GDELT on ClickHouse: Day 2 Running the Day 1 ingest for real: timezone bugs, nullable geo fields, signed offsets, dedup tokens — and discovering the materialized view still doesn't aggregate.
building clickhousegdelt Sep 19, 2026 GDELT on ClickHouse: Day 1 Ingesting and analyzing GDELT on ClickHouse Cloud as a ramp project: Find the data, build the tables, prematurely optimize.
thinking meta Apr 20, 2026 Redo: Rediscovering the obvious Yet another new start ... maybe I should have called this yans