back
▲ 5 points

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

philippdubach.com
by 7777777phil·7mo ago·0 comments·view on hn ↗
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

// no comments yet