Skip to main content

Posts

New best story on Hacker News: Show HN: Use Claude Code to Query 600 GB Indexes over Hacker News, ArXiv, etc.

Show HN: Use Claude Code to Query 600 GB Indexes over Hacker News, ArXiv, etc. 360 by Xyra | 126 comments on Hacker News. Paste in my prompt to Claude Code with an embedded API key for accessing my public readonly SQL+vector database, and you have a state-of-the-art research tool over Hacker News, arXiv, LessWrong, and dozens of other high-quality public commons sites. Claude whips up the monster SQL queries that safely run on my machine, to answer your most nuanced questions. There's also an Alerts functionality, where you can just ask Claude to submit a SQL query as an alert, and you'll be emailed when the ultra nuanced criteria is met (and the output changes). Like I want to know when somebody posts about "estrogen" in a psychoactive context, or enough biology metaphors when talking about building infrastructure. Currently have embedded: posts: 1.4M / 4.6M comments: 15.6M / 38M That's with Voyage-3.5-lite. And you can do amazing compositional vector search, ...
Recent posts

New best story on Hacker News: Show HN: 22 GB of Hacker News in SQLite

Show HN: 22 GB of Hacker News in SQLite 378 by keepamovin | 123 comments on Hacker News. 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://ift.tt/SxDe2Gz ): 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 your hands. That's my Year End gift to you all. Thank you for a wonderful year, have happy and wonderful 2026. make something of it.