Is the revision_table's rev_user field reliable? Who is a good person to connect with about this?
Context & use-case: I am working to create a query to identify the number of editors that edited each article within a predefined list of articles, in a particular wiki, using replicated databases on MariaDB.
After looking at the following tables,
https://www.mediawiki.org/wiki/Manual:Page_table
https://www.mediawiki.org/wiki/Manual:Revision_table
https://www.mediawiki.org/wiki/Manual:Revision_actor_temp_table
https://www.mediawiki.org/wiki/Manual:Actor_table
https://www.mediawiki.org/wiki/Manual:Logging_table
https://www.mediawiki.org/wiki/Manual:User_table
it appears that the best tables to use for this task are the page_table and revision_table. Within the 'revision_table`, I'm interested in the rev_user field.
As I see that the revision table is undergoing, or will undergo, further changes given T161671, T188327, T215466, T167246 and also given issues with rev_usernoted in T112384, I wonder about whether I should be using rev_user after all and whether I should wait to use rev_actor or actor_id when those are ready.
Any feedback and clarity are appreciated. Thank you!