bigpresh / bigpresh/Catalyst-Plugin-Profile-DBI-Log

Ability to run EXPLAIN ... on a query

Open
#2 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Perl
Stars
0
Forks
0
Avg merge
1h 44m
Merged PRs (30d)
1

Description

It would be super handy when looking at a hairy query to be able to click a link to feed that query into an EXPLAIN and get the result, to see what the planner does. That'd involve the plugin knowing how to get a DB handle to use though, and would fall down if the app uses multiple DBs. Hmm.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reading Catalyst::Plugin::Profile::DBI::Log and the DBI::Log query-capture flow to understand what query data and database handles are available. Clarify how a user-triggered EXPLAIN should work when an application uses multiple databases; done should include a defined link action and returned planner result.

Written by the indexing model from the issue text.

Assessment

Tech stack
perl, sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.