Running Analytics on 22 GB of Hacker News in SQLite
Get picks like this daily. Today's launch numbers, the top launches, AI and tech news, and a daily opportunity pick, straight to your inbox.
Want to reach these readers? Sponsor an issue.
First of all please go check out the amazing project this analysis is based on: https://news.ycombinator.com/item?id=46435308For 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
HN · launched Dec 31, 2025 · 5 upvotes (top 90%) · 0 views
Niche: specialized analytics platforms · 141 launches, 4 in the last 7 days ▼ -60% · Explore this niche →
Category and tags
- Horizontal
- Analytics & BI
- Developer
- Not AI
- Hobby / open-source project
Visit website ↗ Source listing ↗
More like this: all 141 launches in specialized analytics platforms →
Could you build this?
Yes This is an analytics project and data pipeline querying a 22 GB SQLite dataset, which standard AI coding tools can easily write queries, scripts, and chart visualizers for.
Discussion
No comments on this launch.
Competitors
Other products that read as similar to this one : 83 launches clear the similarity bar, closest 8 shown.
Attention rank: #77 of 84 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).
Launched 63 days after the earliest competitor.
- 22 GB of Hacker News in SQLite · hn · 2025-12-30 · 730 upvotes · similarity 0.57
- I analyzed 297k HN posts · hn · 2025-12-30 · 5 upvotes · similarity 0.47
- Show HN submissions have tripled since 2023 · hn · 2026-01-11 · 18 upvotes · similarity 0.46
- 20 years of Hacker News discussions, clustered and visualized · hn · 2026-03-22 · 7 upvotes · similarity 0.46
- I measured the half-life of 41,301 Show HN launches. It's 7 hours · hn · 2026-07-02 · 37 upvotes · similarity 0.44
- Llm.sql · hn · 2026-04-24 · 8 upvotes · similarity 0.43
- Trader News · hn · 2026-09-24 · 25 upvotes · similarity 0.42
- Viral Potential Predictor · hn · 2025-12-28 · 34 upvotes · similarity 0.41
The niche, labels, vibe code rating and competitor comparison on this page are analysis by Nicheloom. If you use them, please credit nicheloom.com. How you may use our data.