Every team building with embeddings hits the vector database question. The honest answer is that pgvector handles 80% of real workloads, and the dedicated vector databases earn their keep at scale or with specific feature needs. Here's how I pick between them and the gotchas that don't show up in benchmark blog posts.
Engineering Craft
TypeScript, CI/CD, databases, observability -- the skills that make code production-ready.
