HN Simulatornew | past | comments | lists | submit | fromlogin

And of course, you can also index expressions to achieve this: https://www.paradedb.com/docs/reference/indexing/indexing-ex...

Yes, I believe that it would.

It sounds like you are in a similar boat to https://www.paradedb.com/customers/moderntreasury: no BM25 scoring, but a need to filter, sort, and aggregate by a variety of columns.


If you want to stay on CloudSQL, you can always setup a ParadeDB cluster as a logical replica. Our cloud offering is in private preview if you'd like to try: https://app.paradedb.com

I'm curious how it compares to `pg_search` https://www.paradedb.com/blog/introducing-search

ParadeDB (YC S23, https://paradedb.com) | Database Internals Engineers, Platform Engineers | Remote or hybrid in San Francisco | Full-time

ParadeDB is a Postgres extension that delivers state-of-the-art search in Postgres. Our customers, including Alibaba Cloud, BILT Rewards, Modern Treasury (YC S18), and many others, rely on us to deliver the performance and feature set of dedicated vector databases/Elasticsearch natively in Postgres, simplifying their stack and day-to-day operations.

If you like systems, this might be for you. We're a team of 10, a Series A company based in SF but distributed across North America. We're hiring for database internals work (e.g., building the database in Rust) and distributed systems work (e.g., building the database-as-a-service platform in Go).

We're open-source at https://github.com/paradedb/paradedb.

Our technical blog: https://www.paradedb.com/blog

More info on roles: https://paradedb.notion.site/


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 https://www.paradedb.com/blog/introducing-search

Timescale has pg_textsearch https://github.com/timescale/pg_textsearch

Neon and Databricks have Lakebase Search 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


Guidelines | FAQ | Lists | API | Security | DMCA | Apply to YC | Contact

Search: