Technical Blog
Deep dives into backend architecture, AI systems, and engineering decisions
How I Design Systems: My Engineering Philosophy
The principles behind my architecture decisions — from monolith vs microservices to multi-tenant isolation and LLM integration.
Designing a Secure LLM-to-SQL Pipeline
How I built a natural language to SQL system that handles prompt injection, schema validation, and query sandboxing — processing 20M+ records in production.
Building Semantic Search with PostgreSQL and pgvector
Why I chose pgvector over dedicated vector databases, and how to implement production-grade semantic search without leaving PostgreSQL.
Multi-Tenant Architecture: Row-Level vs Schema-Level Isolation
A practical comparison of tenant isolation strategies, and why row-level isolation with middleware-based context propagation worked for our 100+ tenant platform.
Orchestrating 20+ Third-Party APIs Without Losing Your Mind
Lessons from integrating ERP, shipping, marketing, and payment APIs into a single e-commerce platform.