Couple relatively recent HN threads that give a good overview of the vector database landscape.

https://news.ycombinator.com/item?id=36943318

https://news.ycombinator.com/item?id=38416994

https://news.ycombinator.com/item?id=38420554

I work for Pinecone so my bias is obvious, but objectively: Pinecone is ranked as the most popular vector DB according to multiple sources [1][2][3][4], the best funded ($100M Series B), and is used in production by the likes of Shopify, Gong, Plaid, Zapier, Midjourney, CVS, and thousands of others.

[1] https://retool.com/reports/state-of-ai-2023

[2] https://state-of-llm.streamlit.app/#third

[3] https://db-engines.com/en/ranking/vector+dbms

[4] https://www.g2.com/categories/vector-database

Regarding "future-proof-ness": we've been building production-grade vector search since 2018 and have a number of organizations running it at billion+ scale in production environments. It's all open source too.

https://milvus.io

Redis is probably better suited