Engineering Publications
Technical Insights & Architecture Papers
Deep-dives on high-throughput backend architecture, Python & Django performance, real-time Voice AI, and resilient database modeling.
Advanced Django ORM Optimization: Subqueries, Window Expressions & `FilteredRelation`
Eliminate the N+1 query problem and massive Cartesian joins. Discover how to consolidate 20+ roundtrips into a single performant SQL query using Django Subquery, OuterRef, SQL Window Expressions, and FilteredRelation.
Mastering `select_for_update`: Preventing Race Conditions in Financial Ledgers & Worker Queues
High-concurrency updates to balances, limited promo codes, and worker queues suffer from lost updates. Master pessimistic locking, skip_locked semantics, and optimistic concurrency control in Django and PostgreSQL.