[MDBF-529] Research Explain Analyzer rewrite work Created: 2023-01-24 Updated: 2023-08-15 |
|
| Status: | Open |
| Project: | MariaDB Foundation Development |
| Component/s: | None |
| Affects Version/s: | N/A |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Andrew Hutchings | Assignee: | Andrew Hutchings |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
Explain Analyzer is a tool that used to be hosted on the mariadb.org site. It is a web form that helped read the explain output for you. phpMyAdmin were linking to this page but it has been down for several months as it is in an unmaintainable state. The original source was written by bryan in Python 2 and I am informed that it is proprietary and we cannot open source it for people such as phpMyAdmin. Instead we need to work out a plan for rewriting it, deciding what form that will be in (library? full application?) and how much effort it will be to do so. Using a GPL license. |
| Comments |
| Comment by Bryan Alsdorf [ 2023-01-24 ] |
|
My code is so old and messy (one of my first python projects!) I think it would be best to pull the regular expressions (the hardest part I recall) and some of the logic and reimplement in a sustainable manner. If I recall the initial implementation did not take very long. My 2 cents would be a core library that outputs JSON would be most useful to embed in other applications. A demo application could be created to use this application running on mariadb.org. I don't think I will be much use after so many years, but if you have any questions I'm happy to answer them. I believe you already have a copy of the code for reference since it has been running on a foundation server. |