Page MenuHomePhabricator

wb_terms is deprecated
Closed, InvalidPublic

Description

Apparently, the wb_terms table is deprecated (see also T86530: Replace wb_terms table with more specialized mechanisms for terms (tracking)).

The query for description presence/absence will need to be updated to use whatever its successor is.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 28 2019, 1:58 PM
Mholloway triaged this task as Medium priority.Mar 28 2019, 1:59 PM
Mholloway updated the task description. (Show Details)
Mholloway added a subscriber: Jdforrester-WMF.EditedMar 28 2019, 6:21 PM

@Jdforrester-WMF What should be used in preference to wb_terms?

(Edit: comprehensibility)

@Jdforrester-WMF What should be used in preference to wb_terms?

Not using it.

What's your use case?

It's used in WikimediaEditorTasks to derive whether a description exists in the language of sitelinked pages.

https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/WikimediaEditorTasks/+/master/maintenance/populateEntityDescriptionExistsTable.php

Is there somewhere else description data is stored? I couldn't see anything else in https://www.mediawiki.org/wiki/Wikibase/Schema.

Ah. No, the reason to get rid of wb_terms was explicitly to not have this content data stored in MySQL, which is for metadata, just in External Storage, which is for content. There's so much content from Wikibase, particularly on Wikidata, and it changes so fast. It was risking the integrity of the overall system.

The need for supporting this use-case is one we would like in WikibaseMediaInfo too, but unfortunately it's not feasible right now.

Mholloway closed this task as Invalid.Mar 28 2019, 7:26 PM

Makes sense. Thanks for the explanation, @Jdforrester-WMF. For now, I think I'll close this ticket since it's not actionable at present.