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/schemadumps. 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/public_html. 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 and its code is now housed at https://github.com/MusikAnimal/sql-optimizer. You can find some (unanswered) discussion on that topic 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/