Vector Databases for RAG: How to Choose One and Wire It In

Does your RAG app need a dedicated vector database? pgvector vs Chroma vs Qdrant vs Weaviate vs Milvus vs Pinecone — open-source vs managed, and how to choose.