https://github.com/timescale/pg_textsearch
BM25 index for postgres, mostly written by a single (very smart) guy and Claude Code.
I feel like we should pin this or something as a canonical counter to the now excruciatingly tired claim:
“Generative software code doesn’t work”
Incredible.
If I get production ready bm25 and incremental view maintenance in postgres, it really will do everything I care about.
Especially with the browser/client synch maintenance stuff people are working on.