[Labs-l] MediaWiki comment storage schema changes coming, may break your SQL queries

[Bryan Davis]

There is a task in the late stages of planning [0] that will change
how comments are stored in MediaWiki. Read the task for details, but
the TL;DR is that columns such as rev_comment, ibp_reason,
img_description, and so on will be replaced with id fields referencing
a separate comment table.

I would encourage anyone running a tool that looks at comments and
descriptions to follow the task in phabricator [0] and also to take a
look at the task that Anomie opened to explore the idea of providing
some views in the replica databases that transparently handle the join
[1]. These views would not magically help existing SQL queries, but
they might make the short term transition a matter of a search and
replace to use the composite view rather than the altered table.


[0]: https://phabricator.wikimedia.org/T166732
[1]: https://phabricator.wikimedia.org/T166798

Bryan
-- 
Bryan Davis              Wikimedia Foundation    <bd808 at wikimedia.org>
[[m:User:BDavis_(WMF)]] Manager, Cloud Services          Boise, ID USA
irc: bd808                                        v:415.839.6885 x6855