Databases

How to compare SKIP LOCKED, plain FOR UPDATE, and advisory lock job claims in PostgreSQL with a runnable pgbench harness and a claim-strategy decision table.

How to test database migrations in CI with production-shaped data, compatibility checks, backfill verification, schema drift detection, and rollback gates.

How to plan database migration rollback in production with compatibility windows, forward fixes, backfill recovery, and clear stop points.

How database connection pool exhaustion happens under load, how to tell pool wait from slow SQL, and how to size pools across instances safely.

How to choose database transaction boundaries in backend APIs so writes stay atomic without holding locks across external calls, retries, or slow work.