Hacker News new | ask | show | jobs
by jascha_eng 156 days ago
https://github.com/timescale/pg_textsearch

BM25 index for postgres, mostly written by a single (very smart) guy and Claude Code.

3 comments

Written by a nobody of course:

> T.J. Green is a Senior Staff Engineer at Tiger Data, creators of TimescaleDB, where he is the implementor of pg_textsearch, a new Postgres extension for high-performance BM25 ranked text search. He brings deep expertise in database systems internals and indexing methods to this project. At Tiger Data, he has also contributed to pgvectorscale, the company's vector search extension for Postgres.

The guy could have written it eyes closed.

Yes TJ is very experienced and smart. But no he would not have been able to build this in a few months by himself without AI. In fact he uses Claude so much that he goes over the max subscription and spends thousands of dollars each month on tokens to continue delivering this fast.

AI is a big multiplier for experienced folks like him.

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.

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”