pgvector with LangChain: Build a RAG Pipeline on PostgreSQL
https://rivestack.io/blog/pgvector-langchain
LangChain's PGVector lets you run RAG on PostgreSQL. Embeddings live next to your relational data, so you get transactions, JOINs, and existing infra for free. Covers similarity search, metadata filtering, MMR, connection pooling, and HNSW indexing for production.
