Blog
Tutorials, guides, and insights on PostgreSQL, pgvector, and AI infrastructure.
PostgreSQL Backup and Recovery: A Complete Guide
Learn how PostgreSQL backup works, from pg_dump basics to WAL archiving and point-in-time recovery. Covers pg_basebackup, pgBackRest, backup verification, and production strategies.
PostgreSQL JSONB: A Complete Guide to Storing and Querying JSON Data
Learn how to use PostgreSQL JSONB for storing, indexing, and querying JSON data. Covers JSONB vs JSON, operators, GIN indexes, real world patterns, and performance tips for production.
pgvector with LangChain: Build a RAG Pipeline on PostgreSQL
Learn how to use pgvector with LangChain to build a production-ready RAG pipeline on PostgreSQL. Covers setup, embeddings, similarity search, metadata filtering, and retrieval chains.
PostgreSQL Connection Pooling with PgBouncer: A Complete Guide
Learn how PostgreSQL connection pooling works, how to set up PgBouncer, and when transaction mode is the right choice. Covers config, monitoring, and common pitfalls.
PostgreSQL Full Text Search: A Complete Guide
Learn how PostgreSQL full text search works, from tsvector and tsquery basics to GIN indexes and ranking. Covers real SQL, performance tips, and FTS vs pgvector.
PostgreSQL High Availability: A Practical Guide for Production
Learn how PostgreSQL high availability works, compare Patroni vs pg_auto_failover, and decide when to manage HA yourself vs use a managed service.
How to Use pgvector with Python: A Complete Guide
Learn how to use pgvector with Python to store and query vector embeddings in PostgreSQL. Covers setup, psycopg3, SQLAlchemy, and building a real RAG pipeline.