Postgres 18 UUIDv7 Primary Keys: Practical Guide (2026)
June 17, 2026
Use Postgres 18's built-in uuidv7() for primary keys: default DDL, uuidv7 vs uuidv4 vs bigint, migrating off uuidv4, and the timestamp-leak caveat to know.
#postgres
Postgres LISTEN/NOTIFY for Job Queues: 2026 Guide
June 11, 2026
Should you use Postgres LISTEN/NOTIFY for a job queue? The global commit lock, 8000-byte payload cap, PgBouncer limits, and safer SKIP LOCKED patterns.
Cursor Pagination in Postgres with Node.js (2026)
June 10, 2026
Build fast cursor pagination on Postgres with Node.js and TypeScript: keyset queries, a compound (created_at, id) tiebreaker, and opaque base64url cursors.
Idempotency Keys for a Node.js API with Postgres (2026)
June 6, 2026
Make POST and PATCH retry-safe. Build a production idempotency-key layer in TypeScript on Node 24 with Fastify 5 and Postgres 18: atomic claims, 409s, replays.
Drizzle ORM + pg-boss Atomic Transactions Tutorial (2026)
May 31, 2026
Send Postgres-backed pg-boss 12 jobs inside a Drizzle ORM transaction with the fromDrizzle adapter, retries, dead letters, and cron schedules.
pg_partman + pg_cron: Postgres 18 Auto Partitions (2026)
May 20, 2026
Tutorial: install pg_partman 5.4.3 + pg_cron on Postgres 18.4, configure daily range partitions with retention, automate maintenance, troubleshoot.
LiteLLM Proxy Production Tutorial: LLM Gateway in 2026
May 19, 2026
Deploy LiteLLM Proxy v1.85 in production: Docker Compose, Postgres, virtual keys with budgets, fallback routing, and cost tracking for Claude, GPT, Gemini.
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.
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.