Dev.to WebDev 🛠 Dev 👁 0 📖 1 min read

Building 5 Client-Side Developer Utilities for Laravel & MySQL 8.4 (Zero Backend, Web Crypto API)

Whenever I'm working on high-volume Laravel and MySQL 8.4 applications, I constantly run into small, repetitive checks—verifying whether an ALTER TABLE statement supports ALGORITHM=INSTANT, ordering composite index colum

Whenever I'm working on high-volume Laravel and MySQL 8.4 applications, I constantly run into small, repetitive checks—verifying whether an ALTER TABLE statement supports ALGORITHM=INSTANT, ordering composite index columns properly, sizing Horizon worker RAM limits, or testing webhook HMAC signatures without pasting production secrets into a third-party server.

To keep all of these in one fast, zero-telemetry place, I built tools.gulfaraz.me (open-source on GitHub at gulfaraz-arshad/laratools).

Architecture: 100% Client-Side Execution

Every tool runs strictly in the browser using vanilla JavaScript, Tailwind CSS, and native browser APIs:

  • Zero backend servers: Static deployment on GitHub Pages with instant load times.
  • No telemetry or tracking: No payloads or signing keys ever leave your machine.
  • Native Web Crypto API: Cryptographic operations run directly via window.crypto.subtle.

What's Inside the Suite

  1. MySQL 8.4 ALGORITHM=INSTANT DDL Checker Paste a CREATE TABLE or ALTER TABLE statement to verify whether MySQL 8.4 executes it instantly via metadata-only changes or falls back to an INPLACE / COPY table rebuild.
  2. Composite Index Builder Orders multi-column indexes using the Equality → Range → Sort rule and outputs both raw SQL and Laravel Blueprint migration syntax.
  3. Webhook HMAC-SHA256 / SHA1 Debugger Computes and verifies webhook signatures locally using window.crypto.subtle and generates constant-time hash_equals() verification snippets for Laravel controllers/middleware.
  4. JSON to PHP 8.2+ final readonly DTO Generator Converts raw API or webhook JSON payloads into strict-typed PHP 8.2+ final readonly Data Transfer Objects complete with fromArray() and toArray() methods.
  5. Laravel Horizon & Redis Worker Calculator Estimates queue throughput, backlog drain times, and worst-case memory footprint (workers × memory_limit) to help prevent OOM kills in production.

Try It Out

You can test all five utilities at tools.gulfaraz.me or inspect/fork the source code on GitHub.

If you have ideas for additional Laravel or MySQL utilities—or edge cases in MySQL 8.4 DDL rules—drop a comment below!

📰 Read the original article on Dev.to WebDev

Originally published by Dev.to WebDev. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.