Page MenuHomePhabricator

Database: replace deprecated 'wb_terms' by MW 1.36 alternative
Open, HighPublic

Description

The legacy term storage wb_terms has been removed from master.

During a code-search of it's mentions we found https://github.com/lingua-libre/RecordWizard/blob/master/includes/ApiQueryRwRecords.php which seems to still be querying the wb_terms table.

Is there any action required?

Event Timeline

I stumbled upon this : https://phabricator.wikimedia.org/phame/post/view/195/coming_to_terms_with_change/.
That's basically the "story" of why wb_terms was removed and by what it was replaced.

I'm not aware yet of how we can phase that out on the RecordWizard. But it should indeed be done.

Poslovitch renamed this task from wb_terms has been removed to Remove usage of 'wb_terms' in the RecordWizard.Aug 16 2021, 9:08 AM

As a side note, here are the docs of what 'wb_terms' was replaced by: https://doc.wikimedia.org/Wikibase/master/php/md_docs_storage_terms.html

This will be needed when LinguaLibre will upgrade to 1.36+. The feature provided by ApiQueryRwRecords can be provided by Blazegraph also, so a choice can be made between the two technologies (use the new SQL tables or Blazegraph through SPARQL). (For culture, there is a whole database theory around normalization, which is a tradeoff between performance in reading, performance in writing, space on disk, and ease of use.)

Yug triaged this task as Unbreak Now! priority.Jul 7 2022, 10:00 AM
Yug renamed this task from Remove usage of 'wb_terms' in the RecordWizard to Database: replace deprecated 'wb_terms' by MW 1.36 alternative.Jul 7 2022, 3:11 PM
Yug lowered the priority of this task from Unbreak Now! to High.

The top of this issue should be rewritten so this issue reflect the discussion's knowledge, it is easier to pick and workload to assess.