- Published on
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.
All Posts
All Posts
- software-engineering (26)
- backend (24)
- reliability (21)
- distributed-systems (15)
- databases (14)
- production-systems (9)
- performance (8)
- architecture (7)
- api-design (6)
- testing (5)
- microservices (5)
- fundamentals (4)
- observability (4)
- debugging (4)
- sql (4)
- best-practices (3)
- cascading-failures (3)
- systems (3)
- code-review (2)
- engineering-process (2)
- ci (2)
- Published on
How to test database migrations in CI with production-shaped data, compatibility checks, backfill verification, schema drift detection, and rollback gates.- Published on
How to diagnose flaky integration tests in CI: shared state, timing assumptions, parallel worker conflicts, database cleanup gaps, and unstable dependencies.- Published on
How to plan database migration rollback in production with compatibility windows, forward fixes, backfill recovery, and clear stop points.- Published on
How database connection pool exhaustion happens under load, how to tell pool wait from slow SQL, and how to size pools across instances safely.