1st January 2023
TIL
Querying the GitHub archive with the ClickHouse playground
— Via [this comment](https://news.ycombinator.com/item?id=34197637) on Hacker News I started exploring the [ClickHouse Playground](https://clickhouse.com/docs/en/getting-started/playground/). It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
Recent articles
- Claude's new system prompt really doesn't want to reproduce song lyrics - 2nd September 2026
- Claude Fable 5.1 made me a really nice animated pelican - 1st September 2026
- Understanding ChatGPT Work - 30th August 2026