Running Analytics on 22 GB of Hacker News in SQLite
Details
- External ID
- 46444657
- Source
- HN
- Company
- —
- Product
- Running Analytics on 22 GB of Hacker News in SQLite
- Website domain
- philippdubach.com
- Launched
- Dec. 31, 2025
- Cohort
- —
- Upvotes
- 5
- Upvotes percentile
- 0.10400763358778627
- Tags
- —
- Fetched at
- Sept. 7, 2026, 9:25 p.m.
- Updated at
- Sept. 7, 2026, 9:25 p.m.
Description
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
Enrichment
- Theme
- Hacker News clients, datasets, and tools
- Vertical
- Horizontal
- Function
- Analytics & BI
- Audience
- Developer
- AI stance
- Not AI
- Project type
- Hobby / open-source project
- Normalized one-liner
- analytics on hacker news data
- Manually corrected
- False
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 — 50 launches clear the similarity bar, closest 8 shown.
Attention rank: #44 of 51 (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.45
- 20 years of Hacker News discussions, clustered and visualized · hn · 2026-03-22 · 7 upvotes · similarity 0.45
- I measured the half-life of 41,301 Show HN launches. It's 7 hours · hn · 2026-07-02 · 37 upvotes · similarity 0.43
- Trader News · hn · 2026-09-24 · 25 upvotes · similarity 0.41
- Llm.sql · hn · 2026-04-24 · 8 upvotes · similarity 0.41
- Hacker-News Buddies · hn · 2026-07-04 · 6 upvotes · similarity 0.41
Other launches for this product
- No other launches for this product.
Same idea, different domain
Nobody's really built a analytics & bi tool for Legal yet.