Full-text search across the Hacker News

A full-text search over all of Hacker News (~49M stories, comments, jobs & polls, syncing live per hour) to be 𝐬𝐮𝐫𝐩𝐫𝐢𝐬𝐢𝐧𝐠𝐥𝐲 𝐟𝐚𝐬𝐭 with no Next.js level cache and all magic at the Neon Postgres layer:

• Every keystroke is a live query against Neon Postgres

• BM25 (powered by Lakebase Search) ranking runs inside the Postgres

• No connection pool, just SQL-over-HTTP round trips

• pg_prewarm loads the table + every index into cache

• partial BM25 index per type, predicate matching the WHERE clause

• Deployed on Vercel

Just Postgres doing Postgres things, close to the compute 🐘