Show HN: Running Analytics on 22 GB of Hacker News in SQLite

5 points

5 months ago

First of all please go check out the amazing project this analysis is based on: https://news.ycombinator.com/item?id=46435308

For my paper [1] I analyzed HN attention dynamics using 72k temporal snapshots from December 2025 to model decay curves, preferential attachment, and engagement survival. Today I’ve cross-referenced these findings with the recent 22GB HackerBook SQLite export to validate my early-engagement prediction models on this 22GB historical subset.

[1] Preprint available on SSRN: https://dx.doi.org/10.2139/ssrn.5910263