Engineering Notes & Tutorials

Technical Blog

Practical deep dives on Laravel architecture, high-volume MySQL optimizations, REST APIs, and open-source PHP packages.

November 17, 2026 5 min read

Building Laravel Arr Extended: Sequential & Circular Array Navigation with Arr::after()

How a rejected Laravel framework pull request turned into gulfaraz-arshad/laravel-arr-extended — adding strict, associative-safe array navigation with wrap-around support.

Laravel PHP 8.1+ Open Source
November 17, 2026 6 min read

Zero-Downtime Schema Migrations in MySQL 8+ with ALGORITHM=INSTANT

How to add or drop columns on multi-million row MySQL production tables in milliseconds without triggering blocking table rebuilds or metadata locks.

MySQL 8+ Database Performance
November 17, 2026 7 min read

chunk() vs. lazyById() in Laravel: Processing Millions of Records Safely

Why SQL OFFSET degrades exponentially on multi-million row tables and how keyset pagination with lazyById() keeps memory flat.

Laravel Eloquent Memory MySQL
November 17, 2026 6 min read

Securing Laravel REST APIs & Webhooks: HMAC Signatures and Rate Limiting

Hardening public Laravel webhook receivers against replay attacks and payload spoofing with HMAC-SHA256, Redis idempotency locks, and burst rate limits.

Security REST API Redis
November 17, 2026 6 min read

High-Throughput Routing Queues with Laravel Horizon and Redis

Isolating critical webhook supervisors from bulk jobs and throttling external API requests cleanly with Redis::throttle().

Laravel Horizon Redis Concurrency
November 17, 2026 5 min read

Preventing N+1 Queries & Optimizing Composite Indexes in Laravel

Catching lazy-loading bugs in local environments and ordering B-Tree composite index columns with the equality-first rule.

Eloquent MySQL Indexing Query Tuning
November 17, 2026 5 min read

Streaming Large CSV Database Exports in Laravel Without Memory Exhaustion

Archiving millions of database rows to cloud disks and browser downloads under 20 MB of RAM using tmpfile() and fputcsv().

PHP Streams Cloud Storage Archiving