Hi Andre:
Those are good questions. The schema data seems to be based upon these: https://tools-info.toolforge.org/explorer/?dir=data/project/tools-info/schem.... Which definitely seems out of date (not to mention that covers a scant few of the possible sites/databases).
You can see some of the code layout via: https://tools-info.toolforge.org/explorer/?dir=data/project/tools-info and especially https://tools-info.toolforge.org/explorer/?dir=data/project/tools-info/publi.... Unfortunately, the code itself cannot be viewed that way.
Some parts of that might be available online somewhere. For example https://github.com/Hedonil/sqloptimizer appears to refer to such, however it seems to have moved to a new tool https://sql-optimizer.toolforge.org/ and its code is now housed at https://github.com/MusikAnimal/sql-optimizer. You can find some (unanswered) discussion on that topic https://wikitech.wikimedia.org/wiki/User_talk:Hedonil#Adoption_request_of_%22Tools-info%22_on_Toolforge from May 2018.
Cheers, —Uzume
On Sun, Jun 5, 2022 at 12:24 AM Andre Klapper aklapper@wikimedia.org wrote:
Hola,
https://tools-info.toolforge.org/schemas.php?schema=enwiki says last updated 67 months ago. Is there something more recent to link to? (Or did we really not change the DB scheme since then which I doubt?)
https://wikitech.wikimedia.org/wiki/Help:MySQL_queries#Database_layout links to that page if anybody wonders how I ended up here.
PS: Oh, and bonus points if someone knows where the code for https://tools-info.toolforge.org/schemas.php itself is located. (Or how I could have found out myself because there are no hints on https://admin.toolforge.org/tools ). Because dead links in sidebar.
Thank you!, andre
-- Andre Klapper (he/him) | Bugwrangler / Developer Advocate https://blogs.gnome.org/aklapper/
Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/