Articles about software development and book recommendations.
A real war-room story about duplicated deposits in production — why a check-then-insert idempotency guard isn't enough under concurrency, and how flipping it to insert-first-then-check-with-a-row-lock fixed it for good.
A deep dive into the Mediator design pattern, how it works in practice, when it makes sense, and why I built my own lightweight implementation after MediatR went paid.
A deep dive into multi-tenancy architecture patterns, data segregation strategies, and the real-world complexity that emerges when tenants grow apart in requirements, scale, and compliance needs.
Final chapter of the FK investigation: how bad are CASCADE deletes really? Real benchmarks bust the '20× slower' myth and reveal why soft delete wins (33× faster).
Continuing the FK investigation: do Foreign Keys slow down SELECT queries? Are JOINs faster without them? Real benchmarks reveal surprising truths—FKs have ~0% impact on reads.
A real-world journey questioning database dogma. When I found our transactions table without FKs, I built benchmarks to understand why. The results: 0.16% to 32.7% overhead depending on workload.
Loading index…