As I always say "just use Postgres". Hasn't failed me so far.

MongoDB got replaced by JSONB. Dedicated vector DBs got replaced by pgvector. For Postgres, it's just another index.