From 17ms to 0.04ms: How to Design the Right SQL Index
What does a good SQL index look like? I seeded Postgres with 1 million comments and measured every indexing decision with EXPLAIN ANALYZE: a 17ms sequ...
The .NET Weekly archive
Page 2 of 22. Practical .NET and software architecture lessons.
Newsletter issues on page 2
How Do You Build a Social Media Feed? (System Design)
The home feed looks like the easiest feature in a social app: fetch posts from the accounts you follow, sort, return a page. That design collapses onc...
Persisting a Rich Domain Model With EF Core
Every time I show a rich domain model, someone tells me EF Core can't persist it without public setters and a public constructor. That stopped being t...
Should You Split That Into Microservices? Ask These 5 Questions First
Nobody regrets microservices on day one. The regret shows up eighteen months later, when the team is drowning in distributed-systems problems they nev...
The System Design Behind My New SaaS
I just shipped Katabench, and it's the most fun system I've ever built: it takes C# from strangers and runs it safely on servers I own. Three Hetzner ...
How I Migrated My Website to Cloudflare and Saved $228
This website ran on Netlify for years, at $19 a month. Earlier this month I moved it to Cloudflare Pages: same repo, same GitHub Actions pipeline, zer...
How to Test Vertical Slice Architecture
The most common question I get about vertical slice architecture isn't about structure. It's "where do my tests go?" The layered-architecture testing ...
Build Your Own VPN With Tailscale
Most of what runs on your servers was never meant to be public: databases, dashboards, admin panels, internal APIs. Tailscale connects your machines i...
Getting Started With NATS JetStream in .NET
NATS almost never comes up when .NET developers talk about message queues, and that's a shame. It's a tiny, fast, single-binary broker, and JetStream ...
The Modular Monolith Boundary I Couldn't Take Back
We built the system exactly the way a modular monolith is supposed to be built, and that's how I ended up with two modules I couldn't pull apart a yea...
Subscribe to the Newsletter
Join 66,000+ readers of The .NET Weekly for practical tips and resources to improve your .NET and software architecture skills.