Amitav
Roy
Software Consultant & Solution Architect with 16+ Years of Expertise.
Specializing in building robust systems with Laravel, React, Vue.js, and Python. Exploring the frontier of AI to deliver modern engineering solutions. This space is a collection of my insights on software development, system design, and technical 'how-to' guides—crafted for developers and CTOs alike.
Software Consultant & Solution Architect
System Design
see allMulti-Cloud Redundancy: The Gap in Our Resilience Thinking
Multi-region is not enough. Recent outages exposed the gap between region and provider redundancy.
Read articlePostgreSQL'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 articleRace 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 articleSoftware development
see allWhy MCP Is the Missing Piece in AI-Assisted Development
MCP bridges outdated AI training and current library knowledge for confident, accurate code generation.
Read articleReading Code in the AI Era: The Skill That Matters More Than Ever
AI was supposed to make coding easier. Instead, it made reading code more critical. We shifted from writing to reviewing. The 10:1 ratio holds—the stakes just got higher.
Read articleLaravel MCP: Production-Ready AI Integration Done Right
Laravel MCP brings the framework's production-ready foundation—dependency injection, validation, authentication, rate limiting—directly to AI integration. No more cobbling together custom solutions or...
Read articleHow to articles
see allThe Query I Was Running Twice: How Laravel's Context Solved My Validation Dilemma
Stop duplicating database queries between validation and controller logic. Laravel's Context facade, combined with withValidator, lets you validate, load, and share models in one elegant flow.
Read articleThe Weekend Bug That Taught Me About Laravel's Event System
Tests passing locally but failing in CI? Laravel's event auto-discovery uses filesystem ordering, which varies between macOS and Linux. Learn why explicit registration matters for production.
Read article
Building a personal RAG system using Llama 3.1, Chroma DB for QA on specific documents
Using the Llama 3.1 LLM model, we are going to build a RAG which can crawl a website and then allow you to ask questions on that specific content.
Read article