I was in that spot a few weeks ago. My requirements were not huge but a) I was on Windows and b), didn't want to waste too much time setting it up.

Tried a few DBs that didn't work well (e.g. I think it was ChromaDB that didn't support Python 3.12) and ended up picking LanceDB.

Very simple onboarding (just built on top of parquet) but there are a few rough edges.

Curious how it compares with qdrant for non-crazy problems