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/