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 all

Multi-Cloud Redundancy: The Gap in Our Resilience Thinking

March 19, 2026 System design

Multi-region is not enough. Recent outages exposed the gap between region and provider redundancy.

Read article

PostgreSQL's GiST Exclusion Constraint: The Database-Level Answer to Double Bookings

March 1, 2026 System design

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 article

Race Conditions in Hotel Booking Systems: Why Your Technology Choice Matters More Than You Think

February 1, 2026 System design

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 article

Software development

see all

Why MCP Is the Missing Piece in AI-Assisted Development

January 27, 2026 Software development

MCP bridges outdated AI training and current library knowledge for confident, accurate code generation.

Read article

Reading Code in the AI Era: The Skill That Matters More Than Ever

November 4, 2025 Software development

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 article

Laravel MCP: Production-Ready AI Integration Done Right

September 20, 2025 Software development

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 article

How to articles

see all

The Query I Was Running Twice: How Laravel's Context Solved My Validation Dilemma

January 1, 2026 How to

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 article

The Weekend Bug That Taught Me About Laravel's Event System

November 30, 2025 How to

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

August 30, 2024 How to

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