Postgres is a good idea.

Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25

BM25 search implemented in PL/pgSQL, there's also an example of Hybrid (BM25+pgvector) search in the repo.