Page MenuHomePhabricator

[SPIKE] investigate best alternative to pagetriage_tags table.
Open, LowPublic5 Estimated Story PointsSpike

Description

Does pagetriage_tags really need to be a table? This could become a scalability issue if we ever deploy PageTriage to lots of other wikis. Let's explore non rdms alternatives, such as just hard-coding it in PHP instead. We can write patches to hard-code this in PHP, then when this table is no longer called by any PHP code, we can ask DBAs to delete the table from enwiki, testwiki, etc.

PageTriage installs its tables on s1-8 rather than x1, so reducing the # of tables seems like a good idea.

image.png (730×1 px, 84 KB)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Restricted Application changed the subtype of this task from "Task" to "Spike". · View Herald TranscriptOct 2 2025, 6:08 PM
jsn.sherman renamed this task from refactor code to not use pagetriage_tags table. hard code it in PHP instead. to [SPIKE] investigate best alternative to pagetriage_tags table..Oct 2 2025, 6:09 PM
jsn.sherman updated the task description. (Show Details)