digitalmatters.me
pgvector on Supabase: Building a RAG Pipeline on the Free Tier
pgvector turns a Supabase project into a vector store without adding a second system to your stack. Enable one extension, add a column, create an index, and the same Postgres that holds your users and content can answer similarity queries. This post walks through building a retrieval-augmented generation (RAG) pipeline on that foundation, and accounts honestly for how far the free tier carries you before the numbers stop working.