Tagged “Data”
-
The top Hacker News story of every day, 2007 to 2026
One highest-scored story per day, across 7,177 days of Hacker News. Top stories doubled in points over a decade, and a quarter of today's are about AI.
-
From GPT to agents: how AI changed on Hacker News
I queried 50 million Hacker News items to see how the AI conversation shifted since ChatGPT: from the model to the tools, then to living with them.
Top 3000 comments with the most replies
The 3,000 Hacker News comments that drew the most replies, queried from 41 million rows in DuckDB, each linked so you can read the thread.
Hacker News Data Exploration
DuckDB over 41 million Hacker News rows: activity by hour and weekday, hiring thread trends, top stories, and the most upvoted domains.
Alfamart vs Indomart dominance in Jakarta
Counting Alfamart and Indomart stores from OpenStreetMap, then plotting both chains in 1 km grid cells over a Jakarta basemap.
Jupyter Notebook in Hugo
A very handy guide on rendering Jupyter Notebooks in Hugo with no extra dependencies like nbconvert or a daemon, and simple enough to self-maintain.
-
Indonesia Postal Code
Inspired by a CGP Grey video, I plotted 83,761 Indonesian postal-code points to see how far the five-digit hierarchy holds outside Jakarta.
-
Exploring TimescaleDB
TimescaleDB vs MySQL and ScyllaDB for time series: one aggregation ran 6m52s on MySQL, 27s on raw TimescaleDB, 35ms on a continuous aggregate.
