MySQL Indexes Explained: How to Read EXPLAIN and Fix Slow Queries
A slow query is usually a missing or mismatched index. Learn to read MySQL 8's EXPLAIN output, order composite index columns correctly and verify the fix.
Tech
Software, AI, databases and the craft of building for the web — explained clearly, with code you can actually use.
Securing a Laravel App Before Launch: 12 Checks I Run Every Time
A pre-launch security checklist for Laravel 11 and 12: configuration, authentication, input handling, uploads, headers and dependencies, with the code to fix each.
Building a Blazing-Fast REST API in Laravel: Caching, Eager Loading & Rate Limiting
One endpoint was firing 62 queries per request. Here is how eager loading, Redis caching, indexes and rate limiting took it from 840 ms to under 100 ms.
SQL Window Functions in MySQL 8: Running Totals, Rankings and Top-N per Group
Stop exporting to spreadsheets. MySQL 8 window functions handle running totals, rankings and month-over-month growth in one readable query.
A Docker Compose Setup for Laravel, MySQL and Redis That Your Whole Team Can Use
One compose.yaml, four services and health checks that actually wait for MySQL. A practical local stack for Laravel that new teammates can run in minutes.
jQuery in 2026 With Laravel Blade: When It's Still the Right Tool
Not every Laravel page needs a SPA framework. When jQuery still earns its place alongside Blade, how to wire it up with Vite, and when to reach for something else.