Technical Blog

Key learnings from building high scale systems

Event-driven scheduling

Event-driven architecture with DynamoDB hierarchical keys and EventBridge Scheduler for scheduled price changes

TypeScriptDynamoDBEventBridgeLambdaEvent-driven

Hybrid architecture

Hybrid DynamoDB + MySQL architecture combining NoSQL flexibility with relational query power

TypeScriptDynamoDBMySQLDrizzleHybrid persistence

N+1 query optimization

Solving GraphQL N+1 query problems with Drizzle ORM batch fetching and connection pooling

TypeScriptMySQLDrizzleN+1 solving

ETL framework

Plugin-based Python ETL framework with Jinja2 templating and parameter validation

PythonLambdaEvent-driven

Next.js deployment

Enterprise Next.js deployment with SST, WAF security, and multi-tenant routing

TypeScriptNext.jsSSTWAF

Dynamic assembly loading

C# .NET Lambda with dynamic assembly loading and versioned exporters using reflection

C# .NETLambda

Composable transactions

Composable transaction patterns with Go 1.21 generics (RunWithin0/1) and clean architecture

GoPostgreSQLTransactions

Interactive DAG editor

Interactive DAG editor with dual ID pattern (frontend + backend IDs) managing 10K+ work orders

TypeScriptReactReactFlowDual ID pattern

URL-first state

URL-first state management with nuqs and debounced dual-state sync for shareable filters

TypeScriptReactURL-first state

Supply/demand matching

Greedy allocation algorithm (O(n+m)) matching supply to demand with BOM hierarchies

TypeScriptReactGreedy allocation

Building a Production RAG Chatbot: From Zero to Portfolio AI Assistant

How I built a sophisticated Retrieval-Augmented Generation system that indexes my entire portfolio and responds as me using OpenAI GPT-4o-mini

TypeScriptNext.jsDynamoDBOpenAIRAGAI

AWS Cognito + AppSync: Field-Level Authorization at Scale

How we secured 5+ GraphQL services with AWS Cognito, supporting 10K+ users with fine-grained permissions and zero token management overhead

TypeScriptAWS CognitoAppSyncLambdaAuthorization

Event-Driven Cache Invalidation: Keeping Distributed Systems in Sync

How we built a cache invalidation system handling 50K+ invalidations/day with Momento, EventBridge, and the outbox pattern for sub-second menu consistency across 8,000+ stores

C# .NETLambdaEventBridgeCache invalidationEvent-driven