Database

PostgreSQL, Prisma, Supabase, Neon, and database optimization.

A practical 2026 playbook to find and fix orphaned Postgres replication slots before pg_wal eats your disk and takes prod down.

Fix Neon + Drizzle connection storms on Vercel in 2026: pick the right driver, pool correctly, and stop too many connections.

Fix Prisma advisory lock timeouts (10000ms) in CI/CD with deploy concurrency, direct DB URLs, and a Postgres runbook (2026).

A real multi-tenant failure mode: Stripe webhooks + Supabase service_role can bypass RLS and write into the wrong tenant. Here’s the fix.

Getting ERROR: prepared statement "s0" already exists? Here is the fix for Prisma Migrate with PgBouncer pooling in 2026.

OFFSET pagination + RLS can make Supabase feel slow. Spot it, fix policies, and switch to keyset pagination without breaking auth.