Posts tagged #PostgreSQL

Zero-Downtime Database Migrations: Expand, Backfill, Contract

Changing a production schema safely is less about clever SQL and more about ordering: add new structure, ship compatible code, backfill data, then remove the old path.

RAG on Postgres You Already Have: pgvector From Scratch

You don't need a dedicated vector database to ship retrieval-augmented generation. With the pgvector extension, the Postgres instance behind your app becomes a semantic search engine. Here's the whole pipeline — chunking, embedding, storing, and querying.