SQL
How We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation at Scale
How Mattrx ended oversells and retired a Redis cluster by moving inventory reservation into MySQL with SELECT FOR UPDATE SKIP LOCKED.
23 min read5
Posts and interview questions tagged MySQL.
How Mattrx ended oversells and retired a Redis cluster by moving inventory reservation into MySQL with SELECT FOR UPDATE SKIP LOCKED.
10 hidden ASP.NET Core memory leaks with before/after code — singletons, MemoryCache, EF tracker, LOH. Mattrx fleet RAM 12.6 GB → 2.3 GB.
The 10 React mistakes I see in every audit — derived state, fetch waterfalls, key bugs — with before/after code and real production metrics.
Full-stack Mattrx playbook — Angular 19 + .NET 9 + Clean Architecture + CQRS + MediatR + EF Core + JWT + SignalR + Redis, with production metrics.
Deep .NET data access guide: EF Core tracking, projection, AsSplitQuery, ExecuteUpdateAsync, compiled queries, and the EF + Dapper hybrid pattern.
SOLID principles built around a real C# order-processing service. Refactor each principle with honest pros, cons, and a code-review checklist.
React 19 vs Angular 19 in 2026 — Server Components vs Signals, bundle sizes, INP benchmarks, real code, and an honest 13-row decision matrix.
How LLMs actually work — transformers, attention, tokenization, sampling — plus production Python code for chat, streaming, embeddings, tool calls, RAG.
Production RAG with Azure OpenAI + Azure SQL VECTOR in C#. Architecture, ingestion + retrieval code, security, costs, and the pitfalls that ruin RAG apps.
Clean Architecture in .NET — the Dependency Rule, four layers, full ASP.NET Core + EF Core + MediatR code, trade-offs, and the version that ships.
CQRS in .NET — the problem it solves, MediatR + EF Core implementation, separate read/write models, and when CQRS pays off vs over-engineering.
Azure Functions in .NET — when to pick them over Web API, hosting plans, HTTP/Queue/Timer/Durable code, cold starts, and the real cost model.