We use qdrant. It's well written software. I do wish these vector indices would stop trying to be complete databases though.

Probably the best outcome is for large DB companies to acquihire and add vector queries as a feature.