Posts

All my posts (MDX/Markdown).

Building Your Own Mediator in .NET: From Pattern to Production

Feb 19, 2026

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.

#csharp#dotnet#mediator#design-patterns#architecture#dependency-injection

Foreign Keys vs Performance (Part 2): The SELECT Story

Jan 19, 2026

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.

#database#performance#postgresql#architecture#benchmarking

Foreign Keys vs Performance (Part 1): The INSERT Story

Jan 19, 2026

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.

#database#performance#postgresql#architecture#benchmarking