(If you don't work with the imagelinks or categorylinks tables, you can ignore this message)
Hello,
Here is an update on the ongoing normalization of the MediaWiki link tables.
Starting 1 March, the cl_to and il_to columns in the categorylinks and imagelinks tables will be removed. You will need to use cl_target_id and il_target_id, respectively, and join against the linktarget table instead. This is analogous to the templatelinks normalization done a few years ago.
Additionally, the cl_collation column in the categorylinks table will be removed. Please use cl_collation_id joined with the collation table instead.
If your tools or queries access these tables directly, please update them to use the new schema before 1 March.
Progress is tracked at: https://phabricator.wikimedia.org/T300222
Background/rationale: https://phabricator.wikimedia.org/T222224
Thank you,
Alexander Vorwerk — IRC: Zabe
Summary:
The Cloud Services implementation of Superset
(https://superset.wmcloud.org) is currently unsupported by WMF staff. We
would welcome a volunteer stepping up to maintain it, but without a new
home the service will be shut down at the end of March.
If you would like to take on ownership of this service, please reach out
to WMCS staffor comment on the phabricator task[1]. The day-to-day
maintenance load is minimal, but someone will need to keep track up
updates, security concerns and a potential future of defense against AI
scraping.
Background:
There has always been demand from researchers and volunteers to run
one-off queries against Wikimedia datasets. Quarry.wmcloud.org was built
and launched by the WMF more than 10 years ago. Originally a one-person
skunkworks project, it quickly caught on in popularity as one of the
most trafficked services run by Wikimedia Cloud Services.
A few years ago, we launched superset.wmcloud.org[0] as an intended
Quarry replacement. We soon learned that despite being a less polished,
home-made tool, Quarry provides many features that Superset does not,
and most users resisted migration away from it. Superset has only a
handful of active users.
At this point, Superset is essentially unsupported by WMF staff. As part
of ongoing efforts to improve our support for Toolforge and other more
popular services we will be either shutting it off or transferring
ownership of Superset in a few weeks[1].
[0] https://phabricator.wikimedia.org/T169452
[1] https://phabricator.wikimedia.org/T416373