Software-engineering

A practical guide to SQL isolation levels, including Read Committed, Repeatable Read, and Serializable, with backend examples and production trade-offs.

How to roll out database schema changes safely in production using expand-and-contract, compatibility periods, and backfills that tolerate mixed-state reality.

How to write API integration tests that verify real persistence, auth rules, contracts, idempotency, concurrency, and failure handling across request boundaries.

A practical production workflow for finding slow SQL queries, reading plans, picking the right fix, and avoiding fake optimizations.

Why AI code review often improves speed more than judgment, and how teams can use it without missing system-level risk in production.