Without maps and forms links there are 2347 links across all wikis. 2168 of those are on commons. 46 unique urls.
(No production databases were harmed. The queries took only a few seconds across the analytics replicas. I have a global link search prototype that I want to release on toolforge soon-ish.) Am Di., 23. Juli 2024 um 15:18 Uhr schrieb Dan Andreescu <dandree...@wikimedia.org>: > > I was curious and I ran some queries* to size up this problem. For future > reference: > > select count(*) from wmf_raw.mediawiki_externallinks where snapshot='2024-06' > and el_to_domain_index like '%gl.goo.%'; > > 44011 was the total across all wikis. On just enwiki it's 28554. As far as > how many of these are maps, I grouped by `el_to_path like '/maps%'` and on > enwiki that looks like: 19820 NOT maps and 8734 maps. Spot checking I saw a > bunch of /forms links. If the need arose, we could export this data for a > bot to use or think of some maintenance script that did these kinds of things. > > * this was run on our internal snapshot replica so as to not bother the > production databases. The query in production would be similar. > > On Tue, Jul 23, 2024 at 8:43 AM Count Count <countvoncount123...@gmail.com> > wrote: >> >> That is the gist of it, yes. If, contrary to expectations, Google >> sunsets goo.gl maps links we will still have time to revisit this. >> >> Am Di., 23. Juli 2024 um 09:54 Uhr schrieb Bináris <wikipo...@gmail.com>: >> > >> > So in your opinion there is nothing to do and everything goes well? >> > Really, for me it easy very easy not to do anything. :-) >> > >> > Count Count <countvoncount123...@gmail.com> ezt írta (időpont: 2024. júl. >> > 23., K, 8:23): >> >> >> >> >> >> The intended audience of the announcement on the Google Developer >> >> Blog[3], which made the news recently, are "developers using links >> >> built with the Google URL Shortener in the form https://goo.gl/*". I >> >> assume that links given out by Google itself are not affected. To this >> >> day Google Maps links are given out using the goo.gl domain and it >> >> seems highly unlikely that Google will turn those off any time soon. >> >> They are using a different scheme nowadays (maps.apps.goo.gl vs. >> >> goo.gl/maps/) but I think it is very likely that old-style links will >> >> continue to work for the foreseeable future as well. >> >> >> >> [1] >> >> https://meta.wikimedia.org/w/index.php?title=Talk:Spam_blacklist&oldid=1767754#goo.gl >> >> [2] >> >> https://meta.wikimedia.org/wiki/Talk:Spam_blacklist/Archives/2012-06#Goo.gl%2Fmaps >> >> [3] >> >> https://developers.googleblog.com/en/google-url-shortener-links-will-no-longer-be-available/ >> >> >> >> Count Count >> >> >> >> >> >> Am Mo., 22. Juli 2024 um 18:23 Uhr schrieb Bináris <wikipo...@gmail.com>: >> >> > >> >> > "Starting August 23, 2024, goo.gl links will start displaying an >> >> > interstitial page for a percentage of existing links notifying your >> >> > users that the link will no longer be supported after August 25th, 2025 >> >> > prior to navigating to the original target page." >> >> > In the next year the goo.gl links may cause problems, while as of >> >> > August 25th, 2025 they cease working. >> >> > Do you think this issue needs any central action? Of course, it may be >> >> > handled locally, but not every wiki has bot owners for that. At least a >> >> > global warning would be useful for communities. >> >> > >> >> > My idea is to install an abuse filter that warns users to avoid new >> >> > goo.gl links, and change the existing ones by bot. >> >> > >> >> > Bináris >> >> > _______________________________________________ >> >> > Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org >> >> > To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org >> >> > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ >> >> _______________________________________________ >> >> Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org >> >> To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org >> >> https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ >> > >> > >> > >> > -- >> > Bináris >> > _______________________________________________ >> > Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org >> > To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org >> > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ >> _______________________________________________ >> Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org >> To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org >> https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ > > _______________________________________________ > Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org > To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ _______________________________________________ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/