Running Analytics on 22 GB of Hacker News in SQLite
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
Does the same job
all alternatives →- HThnlive.tk – A tool to estimate activity on HN before posting2016 · hnlive.tk · ▲109
- HTHN Text Analytics – Check what’s trending on Hacker News2018 · hn.textalytics.io · ▲16
Posts grew 6x since ChatGPT, but success rate remained relatively flat24d ago · orangecrumbs.com · ▲11Show HN submissions peaked at 6.3x their ChatGPT-launch level, while the number of successful submissions remained relatively flat.
- 2Y20 years of Hacker News discussions, clustered and visualizedMar 2026 · app.lenzy.ai · ▲7
We took the top 3 HN stories every day since October 2006 (~21K stories total), ran topic clustering on them, and visualized how topics rise and fall over time. You can zoom into any period - some patterns are surprisingly clear (AI overtaking startup culture as HN's top topic, crypto's rise and fall, remote work spiking with COVID). Happy to answer questions about the methodology.
More work this month
the category →
The app store for voice native apps that lives in your notch
Work · 28d ago · voiceos.com
The New Calendly▲211Handle all of the work before, during, and after meetings
Work · 17d ago · calendly.com
Launched alongside, December 2025
the whole month →- GP
Life & fun · Dec 2025 · dosaygo-studio.github.io
- JG
Hi everyone! My name's Luke and I made the original Jmail here alongside Riley Walz. We had a ton of friends collaborate on building out more of the app suite last night in lieue of DOJ's "Epstein files" release. Please AMA!
Life & fun · Dec 2025 · jmail.world
PlanEat AI▲733AI turns your health goals into a 7-day menu & grocery list
AI · Dec 2025 · planeatai.com
- 2G
Community, All the HN belong to you. This is an archive of hacker news that fits in your browser. When I made HN Made of Primes I realized I could probably do this offline sqlite/wasm thing with the whole GBs of archive. The whole dataset. So I tried it, and this is it. Have Hacker News on your device. Go to this repo (https://github.com/DOSAYGO-STUDIO/HackerBook): you can download it. Big Query -> ETL -> npx serve docs - that's it. 20 years of HN arguments and beauty, can be yours forever. So they'll never die. Ever. It's the unkillable static archive of HN and it's…
Dev tools · Dec 2025 · hackerbook.dosaygo.com
