Skip to content

All articles

Latest first
The Hidden Performance Killer: How One WHERE Clause Fixed Our 5-Second Notification Query

The Hidden Performance Killer: How One WHERE Clause Fixed Our 5-Second Notification Query

December 3, 2025 System design

Our 5M row notification table caused 4-second queries. Adding WHERE id > cutoff_id improved locality of reference in the clustered index, dropping query time to 250ms. One WHERE clause, 16x faster.

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

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
Beyond pgvector: Choosing the Right Vector Database for Production

Beyond pgvector: Choosing the Right Vector Database for Production

November 14, 2025 System design

When Vector Search Becomes Your Production Nightmare: A Deep Dive into Vectors, Indexes, and the Databases That Handle Them

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

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

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
The Magic of __repr__ When AI-Generated Code Teaches You Something New

The Magic of __repr__ When AI-Generated Code Teaches You Something New

September 10, 2025 Software development

After 16 years of development, I discovered Python's __repr__ magic method through AI-generated code—and it completely changed how I think about object debugging and logging. Instead of accepting the...

Read article
Database Migrations with Python: Why Alembic + SQLModel is the Perfect Combo 🐍

Database Migrations with Python: Why Alembic + SQLModel is the Perfect Combo 🐍

September 6, 2025 Software development

When building a Python database application, managing schema changes can quickly become chaotic. Imagine a scenario: you ship a great new feature, but a teammate can't run the app because their local...

Read article
Building Resilient Python Applications with Tenacity: Smart Retries for a Fail-Proof Architecture

Building Resilient Python Applications with Tenacity: Smart Retries for a Fail-Proof Architecture

August 18, 2025 System design

Building resilient Python applications requires more than simple retry loops—intelligent retry strategies using Tenacity, combined with exponential backoff, jitter, and precise exception handling, for...

Read article
The Craft of Context: Engineering Smarter AI Agents Through In-Context Learning

The Craft of Context: Engineering Smarter AI Agents Through In-Context Learning

August 1, 2025 Software development

In recent years, language models have become the heart of a new wave of intelligent agents. As these systems tackle increasingly complex chains of reasoning and decision-making, a universal lesson has...

Read article

Need help with system design or architecture?

I work with engineering teams on technical audits, architecture reviews, and scaling strategy. Let's discuss your challenges.

Let's talk