Hacker News Search - Full-text search for Hacker News, powered by Neon & Vercel.
by•
A full-text search over all of Hacker News (~49M stories, comments, jobs & polls, syncing live per hour) to be 𝐬𝐮𝐫𝐩𝐫𝐢𝐬𝐢𝐧𝐠𝐥𝐲 𝐟𝐚𝐬𝐭 with 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


Replies
Be the first to reply
Have a question or a thought to share? Add a comment above to start the conversation.