- 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.
Sql
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 production workflow for finding slow SQL queries, reading EXPLAIN plans, choosing fixes, and proving the endpoint improved.- Published on
Why a database index can exist and still fail to speed up a query: selectivity, row estimates, composite index order, and ORDER BY LIMIT behavior.