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.
Another Attempt
Rediscovering the Obvious
Where common wisdom is rediscovered and reshared.
Featured
Redo: Rediscovering the obvious
Yet another new start ... maybe I should have called this yans
Recent Musing
GDELT on ClickHouse: Day 3
Fixing a bunch of mistakes I made on day 1 & 2 and (finally) ingesting data
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.
Projects