Blog Posts

Enterprise Text-to-SQL Analytics: Python, Haystack, and SQL Server for Natural Language BI Queries

1 Introduction: The “Sidecar” Strategy for Modern BI Most enterprise BI platforms were designed for repeatable reporting, not for open-ended questions asked in the middle of a business conversatio

The Apache Pulsar Advantage: Why Tencent Moved from Kafka - Multi-Tenancy, Geo-Replication, and Tiered Storage in Practice

1 Introduction: The Scale Ceiling and the Architectural Pivot Streaming platforms behave very differently once they move past “large” and enter true enterprise scale. At modest volumes, most archi

Workflow Orchestration for .NET on AWS: Step Functions vs. DIY Sagas in Code

1 The Distributed Transaction Dilemma in Modern .NET Architecture Modern .NET systems rarely look like they did ten years ago. What used to be a single application talking to a single relational d

ESPN-Scale Sports Platform Architecture for 10M Concurrent Fans | Real-Time Scores & Notifications

1 The High-Concurrency Challenge: Defining the "World Cup" Scale An ESPN-scale sports platform that supports 10 million concurrent users, delivers live scores in real time, and sends **ove

Refactoring Legacy C# Codebases: From `async void` and `ArrayList` to Modern, Safe C#

1 The Strategic Modernization Roadmap: Philosophy Over Syntax Refactoring legacy C# code is rarely about swapping old syntax for new syntax. Experienced teams know the real problem runs much deepe

Building Secure Enterprise APIs with .NET, Azure API Management, and Entra ID (Azure AD)

1 Introduction: The Zero Trust Mandate for Modern APIs Modern enterprise systems depend on APIs to connect business processes, exchange data, and support distributed applications. These APIs opera

Building a Plugin-Ready Modular Monolith in .NET: Feature Isolation, Module Discovery, and Versioning

1 The Strategic Shift: From Monolithic Mud to Plugin Architectures Most enterprise systems start life as a straightforward monolith — one codebase, one deployment, and one shared runtime. That sim

Hotel Booking Systems That Scale: Inventory Management, Double-Booking Prevention, and Dynamic Pricing with .NET

1 Architectural Blueprint: Designing for 50k Daily Bookings A hotel booking system at scale is not “just a database with some CRUD screens.” Once you support tens of thousands of bookings a day, t

On-Device AI for Mobile: Tiny LLMs, Vision Models, and Private Inference

Sudhir Mangla
Mobile Development , AI & Machine Learning
06 Dec, 2025

1 The Strategic Foundation: The Hybrid Compute Spectrum Mobile AI systems now have three realistic places where computation can run: the cloud, the edge (MEC), and directly on the device. Each tie

Operational Dashboards at Milli-Scale: Materialized Views, Columnstore & Redis Read Models

1 The Latency Gap: Why Standard Queries Fail at Scale Operational dashboards succeed only if they stay fast. When a dispatcher refreshes a fleet view or a support agent checks live customer metric