As a SQL-head, I enjoyed following along with Robin Moffatt's blog on doing the challenge with DuckDB. I got slightly slower numbers than he did (I have differe

As a SQL-head, I enjoyed following along with Robin Moffatt's blog on doing the challenge with DuckDB. I got slightly slower numbers than he did (I have different hardware), but definitely in the same order of magnitude. He got 28 seconds to ingest the CSV, then 6 seconds to aggregate and calculate. Maybe 2 hours of coding, tops https://rmoff.net/2024/01/03/1%EF%B8%8F%E2%83%A3%EF%B8%8F-1brc-in-sql-with-duckdb/ https://rmoff.net/2024/01/03/1%EF%B8%8F%E2%83%A3%EF%B8%8F-1b...