SShortSingh.
Back to feed

Open-source Laravel package flags missing, unused and duplicate MySQL indexes without writing to the database

0
·3 views

Laravel MySQL Advisor is a read-only health tool for MySQL or MariaDB databases used by Laravel apps. It reports unused, duplicate and missing indexes, full table scans, N+1 query patterns and server pressure, along with the SQL or migration needed to fix each issue. Each finding carries a severity level of critical, warning or notice, plus the underlying numbers and a suggested fix. Unused-index removal is recommended in two steps, hiding the index first and then dropping it, and the dashboard stays locked outside local environments until an access gate is defined. The package requires PHP 8.3 or later, Laravel 12 or 13, and MySQL 8.0 or MariaDB 10.6 or later, and is released under the MIT license.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Why AI models and AI agents are not the same thing, illustrated with a board game

A developer built a strategy game called 6WINS, where a computer opponent uses two separate components. TAEL, a neural network, only estimates how favorable a board position is, producing a value between -1 and +1 without knowing the rules. ORACLE knows the rules, generates legal moves, searches ahead, and calls TAEL to evaluate resulting positions before choosing an action. The author argues this split mirrors the difference between a model, which supplies learned information, and an agent, which combines that information with rules, search, and action. Early versions of the opponent played erratically, and later wins came from ORACLE's search using TAEL's evaluations rather than the network learning to play alone.

0
ProgrammingDEV Community ·

Learn motion graphics in a browser: animate one shape with two keyframes

A beginner tutorial recommends starting motion graphics by moving a single shape from one point to another. Using the SoloMotion browser tool without an account, the reader draws a circle, sets a position keyframe at the start and another about a second later, then scrubs the timeline to watch the movement. The guide explains how to troubleshoot common issues such as the shape jumping, staying still, or moving robotically, and how to adjust easing and keyframe timing. It concludes by suggesting the reader export a short clip or GIF and note any confusing steps, which the author wants to use to improve the interface.

0
ProgrammingDEV Community ·

CISA Adds Puppet Enterprise Report Deserialization Flaw CVE-2026-115731 to KEV Catalog

On 17 November 2026, CISA added a deserialization vulnerability in Perforce Puppet Enterprise, tracked as CVE-2026-115731, to its Known Exploited Vulnerabilities catalog with a remediation deadline of 1 December. Neodyme researcher Alain Rödel reported two defects while preparing a red-team engagement, and Perforce and OpenVox published patches and advisories on 3 November. OpenVox's 4 November advisory included a working malicious report JSON, and Red Hat released Satellite and Capsule updates on 13 November. The flaw, rated CVSS 4.0 9.4 Critical, affects multiple Puppet Enterprise and Puppet Core releases dating back to 2021, and code execution can expose the CA signing key that underpins trust across managed nodes. Organizations are advised to apply the listed fixed versions promptly.

0
ProgrammingDEV Community ·

SoloMotion vs HyperFrames: Visual Canvas Editing or HTML Video Projects?

The article compares two open-source tools for making short launch clips: SoloMotion, a browser-based editor with a canvas and timeline, and HyperFrames, which builds video from HTML compositions rendered to MP4. The author, who makes SoloMotion, frames the choice around whether the user expects to adjust timing and layers visually or to edit components and re-render. HyperFrames also offers a Studio app with a free tier and an agent-friendly workflow built on project files. The piece suggests a test: build a simple animated card, then make three revisions such as shifting timing, changing text, and creating a color variant. It recommends HyperFrames for teams producing many templated versions and SoloMotion for clips needing frequent visual iteration.