Develop simplified read-only URL resolver for ShortUrl database to UrlShortener extension repo behind a feature flag: wgUrlShortenerResolveLegacyShortUrl.

1. Revised plan

Outside scope of Reader Experience Team but this removal makes sense to me and happy to review any patch.

Ah okay. Eventually yeah, it should move to core and url shortener and others could add content via hooks. Not sure for now though (since we are not adding OG preview to url shortener now).

Oh no, I mean the preview of the metadata, as in: if you open a 'share' dialog, it might be good to see a preview of what you'd share if you pasted the URL into Mastodon or whatever (the 'card' view, I think it's called sometimes). Not necessarily from OG, perhaps the OEmbed stuff will happen at some point. But my main point was about scope creep of UrlShortener if it were to be exposed as just "Share". Perhaps it'd just be a matter of adding a JS hook with which other extensions could modify the dialog contents.

In T403951#11157070, @Samwilson wrote:

Would that set the scene for the UrlShortener extension being a place to put other sharing features? e.g. someone might suggest a Open Graph preview thing (showing the page image and short description). Not sure if that's a worry.

Would that set the scene for the UrlShortener extension being a place to put other sharing features? e.g. someone might suggest a Open Graph preview thing (showing the page image and short description). Not sure if that's a worry.

Honestly at this point I'm in favor of simply shutting it down without no replacement. We can let the community know beforehand but if/when goo.gl can do it, I wonder why we can't. We can definitely provide a public dump of the tables so people could fix links retroactively but the benefit of the redirect mechanism IMHO is not worth the effort as this is a very small set of requests coming to our infra.

Change #1184153 had a related patch set uploaded (by Jforrester; author: Jforrester):

[operations/mediawiki-config@master] [WIP] Disable ShortURL everywhere, without migration

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

In T107188#11132823, @Tgr wrote:

Would the tables be kept and transferred to UrlShortener? Or would there be some kind of migration script that can convert ShortUrl entries into UrlShortener entries? I imagine the link format is too different for that...

Would the tables be kept and transferred to UrlShortener? Or would there be some kind of migration script that can convert ShortUrl entries into UrlShortener entries? I imagine the link format is too different for that...

Change #1183142 had a related patch set uploaded (by Jforrester; author: Jforrester):

[operations/puppet@production] tables-catalog: Add table for (deprecated) ShortUrl extension

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

FWIW, shorturl tables are the only tables in production that have not been cataloged yet.

Done now \o/ Thank you everyone!

Change #1180247 merged by Ladsgroup:

[operations/puppet@production] tables-catalog: Catalog BounceHandler and LoginNotify tables

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

Change #1180247 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] tables-catalog: Catalog BounceHandler and LoginNotify tables

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

Thanks @Ladsgroup! Untagging apps.

Thanks! I make sure it's cleaned up.

In T399302#11096339, @Ladsgroup wrote:

I found wikimedia_editor_tasks_targets_passed that is not cataloged. But also is not in production (as far as I checked), do you know what's going on with it?

Thanks @Dbrant! I merged your patch. Quick question, while cleaning up list of private tables, I found wikimedia_editor_tasks_targets_passed that is not cataloged. But also is not in production (as far as I checked), do you know what's going on with it?

Change #1179714 merged by Ladsgroup:

[operations/puppet@production] common.yaml: Remove private tables that have been cataloged

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

Change #1179695 merged by Ladsgroup:

[operations/puppet@production] mariadb: Document WikimediaEditorTasks tables.

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

Change #1179714 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] common.yaml: Remove private tables that have been cataloged

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

Change #1179683 merged by Ladsgroup:

[operations/puppet@production] Catalog Extension:ReadingLists tables

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

^^ done, for the wikimedia_editor_tasks_ tables. Note, however, that the WikimediaEditorTasks extension is technically no longer used by apps, and is slated to be sunset (T376954) in the near future anyway.

Change #1179695 had a related patch set uploaded (by Dbrant; author: Dbrant):

[operations/puppet@production] mariadb: Document WikimediaEditorTasks tables.

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

Change #1179683 had a related patch set uploaded (by Jdrewniak; author: Jdrewniak):

[operations/puppet@production] Catalog Extension:ReadingLists tables

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

In T399302#11093555, @Ladsgroup wrote:

Welcome to my world! We have had so many random tables like that in production (See T376627: Drop ad-hoc or obsolete tables in production for more fun ones). I drop that table that clearly was made by mistake or not properly cleaned up but the rest still needs to be cataloged.

Mentioned in SAL (#wikimedia-operations) [2025-08-18T10:42:35Z] <Amir1> dropped _echo_target_page_new in aawiki x1 (T399302)

Welcome to my world! We have had so many random tables like that in production (See T376627: Drop ad-hoc or obsolete tables in production for more fun ones). I drop that table that clearly was made by mistake or not properly cleaned up but the rest still needs to be cataloged.

In T399302#11089353, @Ladsgroup wrote:

Only these tables left:

_echo_target_page_new ['aawiki']
...

Only these tables left:

_echo_target_page_new ['aawiki']
bounce_records ['wikishared']
loginnotify_seen_net ['wikishared']
reading_list ['wikishared']
reading_list_entry ['wikishared']
reading_list_project ['wikishared']
wikimedia_editor_tasks_counts ['wikishared']
wikimedia_editor_tasks_edit_streak ['wikishared']
wikimedia_editor_tasks_keys ['wikishared']