- Published on
How to choose between optimistic locking, guarded updates, and SELECT FOR UPDATE in SQL when concurrent requests can overwrite data, oversell inventory, or serialize hot rows.
Sql
All Posts
- software-engineering (24)
- backend (23)
- reliability (20)
- distributed-systems (15)
- databases (12)
- production-systems (8)
- architecture (7)
- performance (7)
- api-design (6)
- microservices (5)
- fundamentals (4)
- observability (4)
- debugging (4)
sql (4)
- testing (3)
- best-practices (3)
- cascading-failures (3)
- systems (3)
- code-review (2)
- engineering-process (2)
- career (1)
- postgresql (1)
- production (1)
- Published on
A practical guide to SQL isolation levels, including Read Committed, Repeatable Read, Serializable, database-specific behavior, locking trade-offs, and production examples.- 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, including selectivity, row estimates, composite index order, post-index filters, ORDER BY LIMIT behavior, partial indexes, and production verification.