A myth-vs-reality breakdown of Pinecone, Weaviate, and Chroma for retrieval-augmented generation, with concrete code, trade-offs, and decision rules for picking the right one.