BM25 in PostgreSQL

Post by pezezin » Mon, Mar 03, 2025, 7:02 AM UTC

crowdyriver wrote: post #10

patrickhogan1 wrote: post #4

Earlier quoted context omitted.

pg_bm25 - Optimized for faceted search & PGroonga - Full-text search with JSONB support

Unrelated, but PGroonga reads funny in Argentinian. Better than gimp though

Post by jonathal » Mon, Mar 03, 2025, 7:03 AM UTC

siquick wrote: post #8

Can this be used on AWS RDS? I’ve seen a few things like this that would be great to use but without RDS support they’re unusable for us.

Post by Jysix » Mon, Mar 03, 2025, 8:31 AM UTC

gaocegege wrote: post #14

rpcope1 wrote: post #7

I'd be interested to see how this stacks up against Manticore or Meilisearch.

Thanks for sharing your feedback! Could you let me know the reason behind it? Are you currently using Manticore or Meilisearch?

Post by isbvhodnvemrwvn » Mon, Mar 03, 2025, 8:55 AM UTC

skissane wrote: post #16

thund wrote: post #6

https://github.com/tensorchord/VectorChord/blob/main/LICENSE

What happens at a lot of places: Elastic license not on legal’s approved license list - need to get special approval from legal to use this. Legal’s license list says AGPL needs case by case legal review - so need to get special approval from legal to use this. Immediate thought: is there another solution which I don’t need special approval from legal to use?

Post by phoronixrly » Mon, Mar 03, 2025, 9:58 AM UTC

skissane wrote: post #18

isbvhodnvemrwvn wrote: post #17

Earlier quoted context omitted.

All licences restricting commercial use will need to be cleared, that's the point.

Yes… but from my point of view, if there is an alternative solution without those restrictions, I’ll go with that. I’d only consider a solution with such restrictions if its other advantages were so compelling as to overcome that (and even then, if one has to ask legal, it isn’t guaranteed they’ll say “yes”)