Match the index to the query. Verify the result.
A reproducible SQLite experiment with 50,000 synthetic rows, exact result checks, and measured tradeoffs.
Read database case study ↗Decisions behind
maintainable software.
Practical explanations, small examples, and tradeoffs in application development.
Test the boundary. Document the exception.
A reproducible walkthrough with 22 request fixtures, recorded results, and two parser limitations made explicit.
Read case study ↗Valid JSON is only the first check
A request can parse correctly and still violate the rules of the application. A small contract makes that distinction visible.
Read note ↗A timeout is not proof that a request failed
Design retries around the effect of an operation, with a clear way to recognize the same request.
Read note ↗Investigate a slow query before adding an index
Use a query plan to ask a specific question, then validate the effect with representative data.
Read note ↗Pagination starts with a stable order
Page boundaries are part of an API contract. Choose them deliberately when data can change between requests.
Read note ↗