TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

New HN data dump available with over 14.5m entries

79 pointsby cdmanalmost 8 years ago

3 comments

minimaxiralmost 8 years ago
If you&#x27;re interested in playing with Hacker News data and don&#x27;t want to download the entire dataset (or don&#x27;t have the CPU&#x2F;memory to perform large JOINs on stories&#x2F;comments), you can use the Google BigQuery HN dataset, which is now up-to-date: <a href="https:&#x2F;&#x2F;cloud.google.com&#x2F;bigquery&#x2F;public-data&#x2F;hacker-news" rel="nofollow">https:&#x2F;&#x2F;cloud.google.com&#x2F;bigquery&#x2F;public-data&#x2F;hacker-news</a> (specifically, the .full table, which combines both stories and comments; the dedicated tables are not up-to-date)
评论 #14581957 未加载
ers35almost 8 years ago
See also: A dump of the stories, comments, and users from the Firebase API as a SQLite database with a full text search index: <a href="https:&#x2F;&#x2F;archive.org&#x2F;details&#x2F;hackernews-2017-05-18.db" rel="nofollow">https:&#x2F;&#x2F;archive.org&#x2F;details&#x2F;hackernews-2017-05-18.db</a>
评论 #14582397 未加载
natchalmost 8 years ago
Kudos to archive.org for hosting torrents. It would be helpful to know the size of the download up front. Nice clean web page design; would love to see that one bit of information added.
评论 #14581212 未加载