- Published on
A practical guide to SQL isolation levels, including Read Committed, Repeatable Read, Serializable, database-specific behavior, locking trade-offs, and production examples.
Software-engineering
All Posts
- software-engineering (25)
- backend (23)
- reliability (21)
- distributed-systems (15)
- databases (12)
- production-systems (8)
- architecture (7)
- performance (7)
- api-design (6)
- microservices (5)
- testing (4)
- fundamentals (4)
- observability (4)
- debugging (4)
- sql (4)
- best-practices (3)
- cascading-failures (3)
- systems (3)
- code-review (2)
- engineering-process (2)
- career (1)
- ci (1)
- postgresql (1)
- production (1)
- Published on
A practical rollout plan for safe database migrations using expand-and-contract, phased constraints, resumable backfills, rollback planning, and production monitoring.- Published on
A practical guide to API integration testing with real request boundaries, auth, persistence checks, failure cases, idempotency, concurrency, and response contracts.- Published on
A production workflow for finding slow SQL queries, reading EXPLAIN plans, choosing fixes, and proving the endpoint improved.- Published on
Why AI code review can produce useful comments while still missing authorization, data-contract, rollout, and system-level risks, with a practical workflow for keeping humans responsible for judgment.