Show HN: a local-first Postgres + pgvector substrate for discovery
Reference example. With Lab running, the top of this feed shows ranked HN items by 4-factor signal score (HN discussion + recency + velocity + GitHub momentum).
The shared discovery substrate beneath every sub-product. Local-first Postgres index over Hacker News, GitHub trending, engineering blogs, arXiv, and operator forums. Ranked, searchable, and feeding the curated signal layers above.
The rows below are a static preview of what /lab shows when the local Postgres substrate is running. The Lab is intentionally local-only — it ranks raw discovery material (Hacker News, GitHub trending, one-hop link extraction) so the operator can turn the top of the ranking into cited signals in the public brief. See python/lab for the runbook.
Reference example. With Lab running, the top of this feed shows ranked HN items by 4-factor signal score (HN discussion + recency + velocity + GitHub momentum).
Each HN submission's linked page becomes a document of its own, with outbound links recorded as `links` rows so subsequent passes can materialise them.
Daily / weekly / monthly trending in Python, Rust, TypeScript, Go. Star count feeds the GitHub-momentum factor in the scorer.
Documents that point at the same upstream get the same cluster_id so the feed can collapse near-duplicates into one row.