pgvector HNSW Postgres 18 Production Tuning Tutorial 2026
May 16, 2026
Tune pgvector 0.8.2 HNSW indexes on PostgreSQL 18: ef_search, halfvec quantization, iterative scans, and parallel builds with a runnable Docker setup.
#postgresql
pg-boss Tutorial: Postgres Job Queue in Node 24 (2026)
May 15, 2026
Production pg-boss tutorial. Queue jobs in Postgres from Node.js 24 with TypeScript, retries, dead-letter queues, cron, and graceful shutdown.
Postgres 18 Zero-Downtime Upgrade: pg_createsubscriber 2026
May 13, 2026
Upgrade Postgres 17 to 18.3 with zero downtime using pg_createsubscriber and logical replication. Docker walkthrough with sequences, cutover, rollback.
Production Postgres Pooling: PgBouncer + Supavisor 2026
May 7, 2026
Hands-on 2026 guide: PgBouncer 1.25.1 in front of Postgres 18, then swap to Supabase Supavisor — transaction pooling, prepared statements, and pitfalls.
Postgres LISTEN/NOTIFY: Real-Time Presence Tutorial 2026
May 5, 2026
Hands-on 2026 tutorial: build a real-time online-presence system on Postgres 18 LISTEN/NOTIFY with Node.js, Express, and ws — no Redis, no broker, just SQL.
The Complete Guide to SQL: From Basics to Advanced Queries
September 18, 2025
SQL from beginner to advanced queries: CRUD, JOINs, subqueries, CTEs, Window Functions, indexes — covering Postgres, MySQL, and SQLite (most examples are portable; vendor-specific differences are noted where they apply).