Software Engineering
6 guides tagged “Software Engineering”.
- How to Handle Timezones in a Database Store instants in UTC, store the user's zone separately, and convert at the edges. A step-by-step pass over the decisions that prevent silent time bugs.
- What Is a Materialized View? A materialized view stores the result of a query as a table. It makes expensive reads fast at the cost of staleness and maintenance — and it is not the same as a view.
- What Is AGENTS.md (and Why Does Your Agent Ignore Your Rules)? AGENTS.md is a plain markdown file at the repository root that tells an AI coding agent how your project works. Here is what belongs in it and why rules are often skipped.
- What Is a Cache Stampede? When a popular key expires, every request for it can miss at once and hit the database together. Here is how to detect and prevent the thundering herd.
- Cache Invalidation Explained Stale data is the price of caching. Here are the strategies that keep it bounded — TTL, write-through, purge on write, versioned keys — and how to choose between them.
- How to Version an API A practical versioning process: choose a scheme, make additive changes without breaking clients, deprecate on a schedule, and prove the contract with tests.