Alternatives
Products that do what Running Analytics on 22 GB of Hacker News in SQLite does
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
- 12G
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…
Dec 2025 · hackerbook.dosaygo.com
- 2EH
2024 · blog.wilsonl.in
- 3IM
Jun 2026 · hackernewstrends.com
- 4NW
Hey HN, Henry here from Cactus. We open-sourced Needle, a 26M parameter function-calling (tool use) model. It runs at 6000 tok/s prefill and 1200 tok/s decode on consumer devices. We were always frustrated by the little effort made towards building agentic models that run on budget phones, so we conducted investigations that led to an observation: agentic experiences are built upon tool calling, and massive models are overkill for it. Tool calling is fundamentally retrieval-and-assembly (match query to tool name, extract argument values, emit JSON), not reasoning. Cross-attention…
May 2026 · github.com
- 5IM
I scraped every Show HN from the last 12 months (41,301 posts) plus the full comment tree of every launch with 10+ comments, ~100k comment timestamps, all from the Algolia HN API. The median launch gets 2 points and 0 comments. For launches that do get traction, half the comments they'll ever get arrive within 7.2 hours and 90% within 26, and the top decile decays on the same clock as everyone else. Vote timestamps aren't public, so comment timing is the attention proxy; caveats are in the post. Everything reproduces from the repo with one command…
Jul 2026 · jonno.nz
- 6HT
2016 · hnlive.tk
- 7HA
Hey there HN! I wanted to share a pet project of mine. I built HackYourNews [1] to scratch a personal itch: Knowing which stories to focus on while browsing aimlessly (though there is a certain joy in that, as well!) HackYourNews uses OpenAI's gpt-3.5-turbo to summarize the destination article as well as the comments section. Summarization of the article is always cached, while summaries of the comments are regenerated if the comments count is >10% (or >10 comments) different. While I styled the homepage to welcome HNers, my preferred view is the Mobile view, accessed from the navbar. This…
2023 · hackyournews.com
- 8
- 9AT
Hi HN, I spent a few weeks looking at the top HN posts of all time. This included exploration, clustering, creating visualizations, and zooming in on what (to me personally) seems like some of the best discussions on here. Three things in this post: 1- The interesting groups of HN posts 2- The interactive visualizations that you can explore in your browser 3- The data from this exploration -- this includes CSV of the titles as well as the text embeddings of 3,000 Ask HN articles. Blog post about this whole process here: [1] ============ 1- The interesting groups of HN posts From the…
2022
- 10CW
Hey HN We loaded a BigQuery dataset of all of Hacker News, every comment, story and user, into camelAI. You can ask questions like: • “When does dang tend to comment during the day?” • “Which domains have gained the most submissions since 2015, year-over-year?” • “How has average comment length changed each January since 2007?” • “Top five users who link to arXiv papers the most.” It's behind a log-in to prevent abuse but free to use for 10 messages. No payment info required. We use OpenAI o3 or Claude sonnet 3.7 for the agent which can be really expensive. Would love feedback especially…
2025 · app.camelai.com
- 11IB
Hey HN community, I built a tool that helps optimize your post for hitting the first page of Show HN. How it works: I used a Hugging Face dataset of all Hacker News posts from the past 3 years and trained a model that predicts how successful your post might be. There's still a lot of randomness on HN, so nothing is guaranteed, but the tool helps optimize your post for higher odds. A couple of interesting findings: - GitHub repo links work x3 better than regular domains - Open-source tools have a steady virality rate (13.9% - one of the highest) - "I built" outperforms "We built" - Using…
May 2026 · wannalaunch.com
- 12AD
We (Nick, Dens, Denzell, Fede, Drew, Aaryan, and Daniel) have been building HN Discovery, a discovery-focused search engine for Hacker News, in our spare time for the past 6 months and are excited to show it! It adds the following features relative to the existing keyword search interface and preserves the existing ones: - no-JS version (hnnojs.trieve.ai) - site:{required_site} and site:{negated-site} filters - public analytics - LLM generated query suggestions based on random stories - recommendations - dense vector semantic search - SPLADE fulltext search - RAG AI chat - order by…
2024 · hn.trieve.ai
- 13HH
Hi HN! A few days ago I saw a graph[0] that showed the # of job postings on HN was declining. I started wondering what other trends I could glean from the data, so I created this! You can filter through the top level comments by keyword; for example you can filter by "remote" to see the massive spike around March 2020. Another interesting thing I found is that I can compare hiring across cities. I hope you enjoy! I made it so that the links to your search are sharable so if you have some interesting data you should be able to just link the page you're on! [0]…
2023 · hnhiringtrends.com
- 14IM
Hey HN! I love finding new books to read on here. I wanted to gather the most mentioned books and recreate the serendipity of physical browsing. I scraped 20k comments from HN threads related to reading, extracted the references and opinions using GPT-4o mini, and visualised their embeddings as a map. - OpenAI's embeddings were processed using UMAP and HDBSCAN. A direct 2D projection from the text embeddings didn't yield visually interesting results. Instead, HDBSCAN is first applied on a high-dimensional projection. Those clusters tend to correspond to different genres. The genre…
2024 · hnbooks.pieterma.es
- 15HW
I was looking for some fun project to play around with the latest Gemini models and ended up building this :) Enter your username and get: - Generated roasts and stats based on your HN activity 2025 - Your personalized HN front page from 2035 (inspired by a recent Show HN [0]) - An xkcd-style comic of your HN persona It uses the latest gemini-3-flash and gemini-3-pro-image (nano banana pro) models, which deliver pretty impressive and funny results. A few examples: - dang: https://hn-wrapped.kadoa.com/dang - myself: https://hn-wrapped.kadoa.com/hubraumhugo Give…
Dec 2025 · hn-wrapped.kadoa.com
- 16IM
I love HN but always felt the search with algolia is okay but does have some limitations. Since I work at Vectara I decided to try and create a better search for HN. It's based on data from roughly the last 6 months of HN stories and comments. Would love to hear feedback and how useful this is relative to the existing search.
2024 · hackernews.demo.vectara.com
- 17MA
Hi everyone! I wanted to share my analytics app with you. This project came from requirements to track certain very frequent events. I found that the cost to do it on a regular analytics product was much more than i was willing to pay. Secondly, I also wanted to use as few resources as possible. So I thought it may be a good idea to create something that may be useful for myself (and hopefully others). I have been able to track a great number of events with this using ~20 MB of storage and memory which is incredible. I have been really impressed by golang as a language and as an ecosystem…
2025 · github.com
- 18HN
I made a little website with a server that collects only HN submissions with > 500 upvotes chronologically. https://hn.moritz.pm/ It's quite simple because I wanted to learn from the project. But I think it's useful, to get a summary of what was important over the last days. The UI is almost identical to the HN frontpage, you can click on the comments to view the thread and on the username to see the profile. The rest of the cards takes you to the submitted URL.
2024 · hn.moritz.pm
- 19SH
I built this tool to help me find interesting discussions on Hacker News. I love reading HN discussions almost more than the articles themselves. However, I found that full text search, although highly performant, is not always good at surfacing interesting discussions on a certain topic -- especially if you don't know what to search for exactly. I built this by scraping the most recent ~6 million posts (that's about 2 years of history) and putting the resulting posts and their vector embeddings into Postgres. Let me know what could be improved, and if you'd like a more detailed writeup of…
2024 · searchhacker.news
- 20
- 21DY
A fun project that I built to try out R1 Distill Llama 70B. Enjoy :)
2025 · hn-wrapped.kadoa.com
- 22SH
I analyzed 10 years of Hacker News data (2016-2025) to track Show HN submission trends. - Show HN posts went from ~900/month (2016-2019) to 3,315 in Dec 2025 - Share of all stories: 2.4% (2016) → 12.8% (Dec 2025) - Notable spikes: COVID-19 (2020), AI boom (2023), and accelerating growth through 2024-2025 Data source: HackerBook (144k Show HN posts / 3.4M total stories)
Jan 2026 · imgur.com
- 23HB
I made a HN client that allows you to explore comments in a breadth-first manner. Compared to the classic depth-first approach, it works much better for the larger threads - you don't lose the context and can easily skip discussions you're not interested in. Video preview: https://imgur.com/a/tzBdpXw
2025 · apps.apple.com
- 24HT
2018 · hn.textalytics.io
Ranked by how close each launch is in meaning, then by votes. Refine with a description →