Infrastructure●●Solid
A Postgres Extension to Write PostgreSQL Functions in TypeScript
Deno runtime inside Postgres brings npm imports and sandboxing to stored procedures.
WizardryNiche GemBig Brain
idd2
102mo ago
Back to browse
GitHub Repository
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.
3,783 starsC
How This Graybeard Built the Fastest and Freest Postgres BM25 Search
by tjgreen·Mar 31, 2026·203 points·56 comments
AI Analysis
●●●BangerBig BrainSolve My Problem
Native Postgres BM25 with ORDER BY content <@> 'query' operator syntax.
Strengths
- •Block-Max WAND optimization enables fast top-k queries on large datasets
- •3.2k stars and v1.0.0 production-ready status with pre-built binaries
- •Parallel index builds and partitioned table support for scalability
Weaknesses
- •Only supports PostgreSQL 17 and 18, excluding older deployments
- •Requires shared_preload_libraries configuration and server restart
Category
Target Audience
PostgreSQL developers needing native full-text search
Similar To
pg_search (ParadeDB) · Elasticsearch · Meilisearch
Similar Projects
Developer Tools●●Solid
81% on LongMemEval with Pgvector and BM25 – Memory for Claude Code
Pgvector + BM25 hybrid retrieval with honest LongMemEval benchmarks for Claude Code memory.
Big BrainSolve My Problem
m4cd4r4
222mo ago
Open Source●●●Banger
Omni – Open-source workplace search and chat, built on Postgres
Glean alternative on pure Postgres—hybrid search, sandboxed code execution, permission inheritance.
Ship ItNiche GemSolve My Problem
prvnsmpth
177423mo ago
Developer Tools●Mid
The Fastest Way to Ship TanStack Apps
TanStack Start boilerplate, but Wasp, Reflex, and dozen frameworks offer identical features.
Ship It
devarifhossain
553mo ago
Developer Tools●●Solid
Pgcraft – a lazygit-style TUI for Postgres
Native Postgres TUI digs into pg_stat_* where generic tools like lazysql stop.
Niche GemSolve My Problem
lucasfrederico
6017d ago
Developer Tools●●●Banger
SkillMesh (role-based tool routing for Claude/Codex)
Context routing cuts 73% of tokens while staying 9/10 accurate on role match.
Big BrainSolve My Problem
VarunReddy023
303mo ago