HN-fdw – All of Hacker News, queryable from Postgres, with zero copies
Zero-copy Postgres queries against 47M rows using DuckDB FDW and HTTP range requests.

47M HN items in Parquet, auto-updating every 5 minutes on Hugging Face.
Data scientists, ML researchers, HN analysts
Google BigQuery public datasets · Firebase HN dump · Hugging Face datasets
Zero-copy Postgres queries against 47M rows using DuckDB FDW and HTTP range requests.
Clean Parquet dump of 55M Open Library rows saves weeks of data cleaning.
Curated HN links in a README—Colin Percival already did this in 2010.
Runs 22GB of HN history entirely in-browser using lazy-loaded SQLite shards over WebAssembly.
Real-time HN push notifications powered by Val Town and Firebase SSE.
Yet another HN reader in a space with dozens of established options.