Page MenuHomePhabricator
Create Task
Maniphest T129486

Introduce watchlist_props table
Closed, DeclinedPublic
Actions

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
WIP watchlist_props tableAddshoremediawiki/coremaster+42 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

Tobi_WMDE_SW created this task.Mar 10 2016, 3:17 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 10 2016, 3:17 PM
Tobi_WMDE_SW added a parent task: T100508: Watchlist expiry: Watch pages for a specified time frame (2013).Mar 10 2016, 3:17 PM
Tobi_WMDE_SW triaged this task as Medium priority.Mar 16 2016, 11:41 AM
Tobi_WMDE_SW added a project: TCB-Team-Sprint-2016-03-16.
Tobi_WMDE_SW mentioned this in T124752: RFC: Expiring watch list entries.Apr 15 2016, 8:54 AM
Tobi_WMDE_SW moved this task from Incoming to Sprint Ready on the TCB-Team (now WMDE-TechWish) board.Apr 19 2016, 11:32 AM
MGChecker subscribed.Apr 20 2016, 8:19 PM
Restricted Application added a subscriber: Luke081515. · View Herald TranscriptApr 20 2016, 8:19 PM
gerritbot added a project: Patch-For-Review.Apr 21 2016, 12:50 PM
gerritbot subscribed.Apr 21 2016, 1:09 PM

Change 284690 had a related patch set uploaded (by Nemo bis):
WIP watchlist_props table

https://gerrit.wikimedia.org/r/284690

Tobi_WMDE_SW added a project: TCB-Team-Sprint-2016-05-04.May 4 2016, 12:48 PM
• Lea_WMDE moved this task from Sprint Ready to Watchlist Expiry on the TCB-Team (now WMDE-TechWish) board.May 11 2016, 12:37 PM
Tobi_WMDE_SW added a project: Expiring-Watchlist-Items.May 11 2016, 12:52 PM
Addshore moved this task from Incoming to Work in progress on the German-Community-Wishlist board.Jul 7 2016, 10:59 AM
Addshore added a project: User-Addshore.Jul 12 2016, 1:16 PM
Addshore moved this task from Unsorted 💣 to Active 🚁 on the User-Addshore board.
Addshore mentioned this in T126641: [RFC] Devise plan for a cross-wiki watchlist back-end.Aug 3 2016, 9:49 AM
Tobi_WMDE_SW moved this task from Work in progress to Incoming on the German-Community-Wishlist board.Aug 31 2016, 2:17 PM
gerritbot added a comment.Mar 4 2017, 11:52 AM

Change 284690 abandoned by Addshore:
WIP watchlist_props table

Reason:
Abandoning for now, the direction here is still unclear

https://gerrit.wikimedia.org/r/284690

Addshore removed projects: User-Addshore, Patch-For-Review.Mar 4 2017, 12:33 PM
Addshore changed the task status from Open to Stalled.Mar 21 2017, 11:50 AM

Stalled pending resuming work here once wl_id is deployed on wmf sites (T130067).

ifried moved this task from Backlog to Older WMDE Work (on hold; for reference only) on the Expiring-Watchlist-Items board.Oct 25 2019, 7:56 PM
Restricted Application added projects: Growth-Team, Community-Tech. · View Herald TranscriptOct 25 2019, 7:56 PM
ifried removed a project: Community-Tech.Jan 21 2020, 4:11 PM
kaldari closed this task as Declined.Feb 5 2020, 1:52 AM
kaldari subscribed.

I'm going to be bold and mark this as declined. This is no longer stalled by wl_id, but it seems the current plan (T124752) is to implement something simpler: just adding an expiration column to the existing watchlist table. This seems sensible, especially since it will match how user rights expiration was implemented and thus follow an existing pattern. If anyone disagrees, feel free to reopen this task.

daniel added a comment.Feb 5 2020, 1:21 PM
In T129486#5850833, @kaldari wrote:

I'm going to be bold and mark this as declined. This is no longer stalled by wl_id, but it seems the current plan (T124752) is to implement something simpler: just adding an expiration column to the existing watchlist table. This seems sensible, especially since it will match how user rights expiration was implemented and thus follow an existing pattern. If anyone disagrees, feel free to reopen this task.

Keep in mind that introducing new tables is much easier for DBAs than modifying existing tables...

kaldari added a comment.Feb 5 2020, 9:43 PM

@daniel - Any personal opinion on which schema we should pursue?

daniel added a comment.Feb 5 2020, 9:50 PM
In T129486#5854029, @kaldari wrote:

@daniel - Any personal opinion on which schema we should pursue?

All depends on access patterns, best ask the DBAs...

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits