Why I Skipped Pinecone and Used pgvector for My RAG System - And When You Should Too

I never seriously considered Pinecone for my RAG system. Sounds like a confident engineering decision. The honest version is less impressive — I was building a portfolio project with a few hundred que