Hi,
On 7/28/23 12:42, F. Xavier Dengra i Grau via Wikimedia-l wrote:
Is there any available tool to precisely count how
many days in a row a
Wikimedian from a specifif project has been editing? The sourcethat is
linked in the Diffs
page (
https://en.wikipedia.org/wiki/Wikipedia:Database_reports/Longest_active_use…
<https://en.wikipedia.org/wiki/Wikipedia:Database_reports/Longest_active_user_editing_streaks>)is
only within the English Wikipedia…
In addition to my "Wiki streaks" tool Natalia linked, I'm happy to set
up the database report for other wikis - just ask :)
Has anyone checked that there is no other user in the
rest of the
other projects (hundreds of them) with a similar or better streak, so
that the sentence “the Wikimedian with the longest editing streak” is
fully accurate regarding both language and Wikimedia project?
Here's a version of the streaks report that checked all wikis:
<https://meta.wikimedia.org/wiki/User:Legoktm/Longest_active_user_editing_streaks>.
Johnny Au is still #1, beating all other humans and bots :) Ignoring
bots, Bruce1ee (also en.wp) is #2. Kocurwaclaw from pl.wp is #3.
I should say that these reports are for the longest *active* daily
editing streak. At least I never got around to looking for long
non-active streaks, though it could be an interesting research project!
If someone has ideas on some SQL to look this up, happy to turn it into
a proper report.
-- Kunal / Legoktm