Mattflaschen-WMF added a comment.

There are a couple issues with this that make it more complicated than I thought:

  1. The Wikidata revision ID is only in rc_params, so it's not joinable. It's also in wb_changes, but that doesn't have the rc_id or anything allowing joining to recentchanges AFAICT.
  2. The ORES tables are per-wiki, so we wouldn't be able to join recentchanges from this DB to the wikidatawiki ORES table.

We could potentially solve 1 by one of:
1a. Putting the real Wikidata revision ID into rc_this_oldid. Not sure if this is a good idea.
1b. Adding rc_id to wb_changes.

We could potentially solve 2 by one of:
2a. Fully centralizing the relevant ORES tables, with a 'wiki' column name.
2b. Mirroring just the Wikidata ones to the client wikis.


TASK DETAIL
https://phabricator.wikimedia.org/T158025

EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Mattflaschen-WMF
Cc: Catrope, jmatazzoni, Aklapper, Mattflaschen-WMF, QZanden, Avner, Iniquity, Izno, SBisson, Wikidata-bugs, aude, He7d3r, Ladsgroup, Mbch331, tarlocesilion, Legoktm
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to