System design
All articles
Event-Driven Queue Architecture in NestJS: A System Design Perspective
Scalable NestJS backends live or die on how queue infrastructure is separated from domain logic. Here's the system design reasoning behind an event-driven BullMQ architecture that actually holds up.
Read article
Field-Level Encryption With Searchable Blind Indexes: A Practical SOC2 Control Worth Understanding
Most security controls protect the perimeter. Field-level encryption protects the data itself. Using CipherSweet's blind index approach, you can encrypt sensitive columns at the application layer and...
Read article
Human Adoption Is a Design Requirement, Not a Post-Deployment Fix
Most digital transformations don't fail at the architecture layer. They fail because the system never matched how people actually work. I've seen floor supervisors maintain secret Excel processes for...
Read article
Killed One Service and Nothing Should Break
Speed is only an asset if your engineering culture can keep up. Learn why AI isn't DRY by default and how to manage the "junior developer" context gap before your technical debt spirals.
Read article
Multi-Cloud Redundancy: The Gap in Our Resilience Thinking
Multi-region is not enough. Recent outages exposed the gap between region and provider redundancy.
Read article
PostgreSQL's GiST Exclusion Constraint: The Database-Level Answer to Double Bookings
PostgreSQL's GiST exclusion constraint prevents overlapping hotel bookings at the database layer — making double bookings structurally impossible. One declarative rule that catches what application-le...
Read article
Race Conditions in Hotel Booking Systems: Why Your Technology Choice Matters More Than You Think
Race conditions in hotel bookings: PHP needs only DB protection, Node.js/FastAPI need both DB and app-level locks. Use atomic updates by default, pessimistic locking for complex logic.
Read article
Lambda Functions and API Gateway: Are You Ready for Your Next Infrastructure Change?
Can your Lambda functions survive a datacenter migration? Are you prepared for a technology change? Here is how the infrastructure needs to be built.
Read article
The Hidden Performance Killer: How One WHERE Clause Fixed Our 5-Second Notification Query
Our 5M row notification table caused 4-second queries. Adding WHERE id > cutoff_id improved locality of reference in the clustered index, dropping query time to 250ms. One WHERE clause, 16x faster.
Read article