- Published on
How to choose between optimistic locking, guarded updates, and SELECT FOR UPDATE in SQL when concurrent requests overwrite data or serialize hot rows.
Software-engineering
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
A practical guide to SQL isolation levels: Read Committed, Repeatable Read, Serializable, database-specific behavior, and locking trade-offs.- Published on
A practical rollout plan for safe database migrations using expand-and-contract, phased constraints, resumable backfills, and rollback planning.- Published on
A practical guide to API integration testing: real request boundaries, auth, persistence checks, failure cases, idempotency, and response contracts.- Published on
A production workflow for finding slow SQL queries, reading EXPLAIN plans, choosing fixes, and proving the endpoint improved.