I think what we're seeing with every database company providing new full-text search capabilities is an example of AI coding productivity showing up in the real world.
It started with paradeDB and pg_search <a href="https://www.paradedb.com/blog/introducing-search">https://www.paradedb.com/blog/introducing-search
Timescale has pg_textsearch <a href="https://github.com/timescale/pg_textsearch" rel="nofollow">https://github.com/timescale/pg_textsearch
Neon and Databricks have Lakebase Search <a href="https://docs.databricks.com/aws/en/oltp/projects/lakebase-search" rel="nofollow">https://docs.databricks.com/aws/en/oltp/projects/lakebase-se...
Now PlanetScale.
AFAIK all of these are implementations of the BM25 algorithm. You can just tell an agent to read about BM25 and implement it in your system of choice. Cool to see. Seems like there's still a lot of juice to be squeezed out of how it's architected and integrated into each system, but you can't help but wonder if this will lead to aggressive commodification
Was not able to find any mention of AI or LLM usage on the article. The article is very detailed and goes in depth about how they have been able to do it. If anything it just shows the database level expertise and understanding of the existing implementations to find the optimization opportunities.
Unless its explicitly mentioned lets not dilute the credit of the folks who worked on.
andrenotgiant · · focus · HN ↗
It started with paradeDB and pg_search <a href="https://www.paradedb.com/blog/introducing-search">https://www.paradedb.com/blog/introducing-search
Timescale has pg_textsearch <a href="https://github.com/timescale/pg_textsearch" rel="nofollow">https://github.com/timescale/pg_textsearch
Neon and Databricks have Lakebase Search <a href="https://docs.databricks.com/aws/en/oltp/projects/lakebase-search" rel="nofollow">https://docs.databricks.com/aws/en/oltp/projects/lakebase-se...
Now PlanetScale.
AFAIK all of these are implementations of the BM25 algorithm. You can just tell an agent to read about BM25 and implement it in your system of choice. Cool to see. Seems like there's still a lot of juice to be squeezed out of how it's architected and integrated into each system, but you can't help but wonder if this will lead to aggressive commodification
sandeepkd · · focus · HN ↗
Unless its explicitly mentioned lets not dilute the credit of the folks who worked on.