logoalt Hacker News

RobinLyesterday at 4:29 PM2 repliesview on HN

Love this! Would be super interested in any details the author could share on the data engineering needed to make this work. The vis is super impressive but I suspect the data is the harder thing to get working.


Replies

robhawkesyesterday at 4:42 PM

The most time and energy has been getting my head around the source data [0] and industry-specific nuances.

In terms of stack I have a self-hosted Dagster [1] data pipeline that periodically dumps the data onto Cloudflare R2 as parquet files. I then have a self-hosted NodeJS API that uses DuckDB to crunch the raw data and output everything you see on the map.

[0] Mostly from https://bmrs.elexon.co.uk/ [1] https://dagster.io/

robowenyesterday at 10:29 PM

[dead]