http
6 minHTTP conditional writes: detect an edit based on stale state
Use strong validators and atomic preconditions to prevent lost updates without confusing them with retry identity.
Search the library
9 matching resultsArticles and interview answers
Q&A
Q&AWhat is the first step when a Python test fails intermittently?
Capture the seed and environment, then isolate and repeatedly run the smallest failing test.
Read the concise answer
Treat the failure as evidence of an uncontrolled input. Record test order, random seed, runtime, timing, and environment; run the test alone and repeatedly. If it only fails in a suite, inspect shared fixtures, globals, ports, environment patches, clocks, and unawaited tasks before adding retries.
Q&A
Q&AWhy is one global SQLAlchemy Session unsafe in an async FastAPI service?
A Session carries mutable identity-map and transaction state and is not safe for concurrent requests.
Read the concise answer
Concurrent coroutines can interleave operations on the same Session, mixing transaction state and identity-map contents. Create a session per request or task, scope its transaction clearly, and size the connection pool across all worker processes and replicas. A global Engine/pool is different from a shared mutable Session.
http
5 minReliable API Clients: Pagination, Conditional Requests, and Retry Budgets
Keep list traversal stable, validate cached representations, and bound retry work when networks fail at ambiguous points.
Q&A
Q&AWhat does a successful kubectl apply prove?
API acceptance is not convergence. Inspect rollout status, Pod conditions, and events to determine whether the desired workload is actually ready.
Read the concise answer
API acceptance is not convergence. Inspect rollout status, Pod conditions, and events to determine whether the desired workload is actually ready.
Q&A
Q&ADoes If-Match make a lost-response write safely identifiable on retry?
No; it identifies an expected version, not a logical operation.
Read the concise answer
A committed first attempt advances the validator, so a repeat with the old validator may fail with 412. Use a separate scoped idempotency contract when retries must recover the original result.
Q&A
Q&AWhat is the difference between WHERE and HAVING?
WHERE filters input rows before grouping; HAVING filters groups after aggregation.
Read the concise answer
Use WHERE to remove rows before GROUP BY, such as excluding inactive employees. Use HAVING to filter aggregate results, such as departments with COUNT(*) greater than five. Moving a condition between them can change both meaning and query work.
Q&A
Q&AWhat happens when a Java thread calls wait()?
It must own the monitor, releases that monitor, and waits until notified or interrupted.
Read the concise answer
Object.wait() requires ownership of that object’s monitor. The thread releases that monitor and enters a waiting state until notification, interruption, timeout, or spurious wakeup; it must reacquire the monitor before returning. Always wait in a while loop that rechecks the condition, and use higher-level concurrency utilities where possible.