Outbox Pattern in Postgres: Concurrent Workers vs Reading the WAL
An API can save an order and crash before publishing the message that tells other services about it. The outbox pattern saves the message with the ord...
The .NET Weekly
Practical .NET and software architecture, every Saturday.
One tip per issue that you can apply right away. Read every past issue below, or get the next one by email.
Join 66,000+ software engineers
Previous issues of The .NET Weekly
Looking for longer guides? Browse all 166 in-depth articles.
Manage read historyI Turned Off CI for Pull Requests. Here's Why
My pull requests haven't run GitHub Actions since June. The build and tests run on my machine, and a signoff commit status posted by Basecamp's gh-sig...
How to Revoke a JWT Before It Expires
ASP.NET Core validates a JWT by its signature and expiry, so a stolen token keeps working after the user changes their password. The standard fix is a...
Self-Hosting at Home With Cloudflare Tunnel
My Linux mini PC can run web apps, but CGNAT stops me from sharing them with a router port forward. Cloudflare Tunnel gives me a public URL while the ...
Test Time-Dependent Code Without Waiting
I have time-dependent code in my application that I need to test. An invitation that expires after five minutes is a good example: I want to check the...
What It Actually Took to Port the GitHub Copilot Runtime to Rust
GitHub ported the Copilot agent runtime from TypeScript to more than 800,000 lines of Rust, and the headlines credited one engineer and $120,000 in to...
I Replaced a $120/Year SaaS With My Own App
I paid $120 a year for a transcription tool until a coding agent helped me get my own version running in under an hour. Here is how the AssemblyAI int...
Adding an Index Made This Query Slower
A query already had a usable index. Adding another index made Postgres choose a plan that discarded almost half a million rows to return ten. Here is ...
Let Postgres Enforce Tenant Isolation
EF Core query filters can be bypassed. PostgreSQL row-level security enforces tenant isolation on reads and writes, if you connect with the right data...
Four Years of Writing Every Week
Four years ago this week, the first issue of this newsletter landed in a few hundred inboxes. Two hundred and ten issues later, I want to step back fr...
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.