MusikAnimal
Software Engineer at Community Tech

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

User Since
Dec 14 2014, 11:39 PM (131 w, 4 d)
Availability
Available
IRC Nick
musikanimal
LDAP User
MusikAnimal
MediaWiki User
MusikAnimal

My conscious is a jukebox

Recent Activity

Yesterday

MusikAnimal added a comment to T168676: Bogus "not a valid project" errors.

The API that it is using works at the time of writing: http://xtools.wmflabs.org/api/namespaces/fr.wikipedia.org

Thu, Jun 22, 11:32 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal closed T168680: The fields in X!'s tools are too small to type in mobile as Declined.

This will not be an issue in the new XTools, which will be released very soon! :) Going to close this as declined because we're no longer supporting the legacy version. Thank you for the report, though!

Thu, Jun 22, 10:56 PM · CSS, Tool-Labs-tools-Xtools
MusikAnimal closed T168680: The fields in X!'s tools are too small to type in mobile, a subtask of T165706: Ensure xTools Rebirth is fully responsive, as Declined.
Thu, Jun 22, 10:56 PM · Tool-Labs-tools-Xtools
MusikAnimal added a comment to T147765: Add new matches_any function to join series of regular expressions.

This perhaps can't or shouldn't be done as described, because there's no guarantee other regex syntax won't be transformed by norm or ccnorm. Let's say we write our filter ccnorm_matches_any(added_lines, "goo+gle", "yahoo+") which would be equivalent to matches_any(added_lines, ccnorm("goo+gle"), ccnorm("yahoo+")) (matches_any does not actually exist either, but that's beside the point). Here we want it to return true if added_lines contains "Go00oogle", "Gooogle", "Yah00ooo", "YahoO", etc (any number of O's, or 0's because ccnorm will turn a 0 into an O). The matches_any function then joins them with a pipe effectively running ccnorm(added_lines) matches "GOO+GLE|YAHOO+". This is great, but what if later someone adds a rule to AntiSpoof to turn +'s into T's? Then you'd unexpectedly end up with ccnorm(added_lines) matches "GOOTGLE|YAHOOT".

Thu, Jun 22, 5:18 PM · Community-Tech, AbuseFilter

Wed, Jun 21

MusikAnimal moved T167345: Create an XTools logo from Ready to In Development on the Community-Tech-Sprint board.
Wed, Jun 21, 8:52 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal claimed T167345: Create an XTools logo.
Wed, Jun 21, 8:52 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal added a comment to T168527: Popular Pages in Watchlist.

@Trizek-WMF I believe the combination of those features would work. I also discovered MassViews which can accept a Page Pile, which you can copy from your raw watchlist. This requires logging into wmflabs, and several steps, so it's not easy for the average user, but it works.

Wed, Jun 21, 8:09 PM · Community-Tech
MusikAnimal created T168546: Allow importing of watchlist into Massviews (requires OAuth).
Wed, Jun 21, 5:05 PM · Tool-Labs-tools-Pageviews

Tue, Jun 20

MusikAnimal added a comment to T165401: Restrict access to users' edit stats unless opted-in.

It seems to be timing out for users with large numbers of edits.

Tue, Jun 20, 6:29 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal added a comment to T168349: enwiki_p logging vs logging_userindex returning dramatically different results.

In which hosts did you do the tests?

Tue, Jun 20, 6:25 PM · DBA, Labs
MusikAnimal added a comment to T168349: enwiki_p logging vs logging_userindex returning dramatically different results.

Maybe DBAs have better ideas, but this is an optimised-to-4-min query:

P5596

Tue, Jun 20, 4:02 AM · DBA, Labs
MusikAnimal added a comment to T168335: PageTriageUtil::getTopTriagers() is not accurate.

How about we restrict the API to only querying for the past day or week (as it was originally), and let your bot handle the longer time frames (albeit for both patrolling and reviewing).

Tue, Jun 20, 3:05 AM · Community-Tech-Sprint, Collaboration-Team-Triage, MediaWiki-extensions-PageCuration
MusikAnimal added a comment to T168350: Page curation marking pages with citations as having no citations.

Yup, the {{sfn}} format is what's throwing it off. Page Cuartion specifically looks for <ref> tags.

Tue, Jun 20, 1:56 AM · MediaWiki-extensions-PageCuration, Collaboration-Team-Triage
MusikAnimal added a comment to T168349: enwiki_p logging vs logging_userindex returning dramatically different results.

I want to also point out this query took 9 seconds to finish on production.

Tue, Jun 20, 1:20 AM · DBA, Labs
MusikAnimal updated the task description for T168349: enwiki_p logging vs logging_userindex returning dramatically different results.
Tue, Jun 20, 1:06 AM · DBA, Labs
MusikAnimal updated the task description for T168349: enwiki_p logging vs logging_userindex returning dramatically different results.
Tue, Jun 20, 1:03 AM · DBA, Labs
MusikAnimal created T168349: enwiki_p logging vs logging_userindex returning dramatically different results.
Tue, Jun 20, 1:03 AM · DBA, Labs

Mon, Jun 19

MusikAnimal added a comment to T168335: PageTriageUtil::getTopTriagers() is not accurate.

That AND log_params NOT LIKE '%::auto";i:1%' is everything but efficient. You should be able to replace it with AND log_action = 'patrol' (ie. log_action != 'patrol'), after which you could at least use type_action index.

Mon, Jun 19, 10:38 PM · Community-Tech-Sprint, Collaboration-Team-Triage, MediaWiki-extensions-PageCuration
MusikAnimal added a comment to T168335: PageTriageUtil::getTopTriagers() is not accurate.

I ran https://quarry.wmflabs.org/query/19672 on production and it took 25 seconds. That's probably too slow... but we might could add a cron job to pre-compute and cache the stats, say every hour. Consumers of the API will only get the cached result so they are never stuck there waiting. How does that sound?

Mon, Jun 19, 9:05 PM · Community-Tech-Sprint, Collaboration-Team-Triage, MediaWiki-extensions-PageCuration
MusikAnimal added a comment to T168335: PageTriageUtil::getTopTriagers() is not accurate.

This is perhaps why the old code only supported stats for the past day and week. My fault that this was overlooked :-/

Mon, Jun 19, 8:52 PM · Community-Tech-Sprint, Collaboration-Team-Triage, MediaWiki-extensions-PageCuration
MusikAnimal closed T157699: Compare using recentchanges table against fully using the cu_changes table for range contribution queries, a subtask of T145912: Create new Special:RangeContributions page to support viewing contributions across an IP range, as Resolved.
Mon, Jun 19, 6:55 PM · Community-Tech, Patch-For-Review, MediaWiki-Special-pages, IPv6
MusikAnimal closed T157699: Compare using recentchanges table against fully using the cu_changes table for range contribution queries as Resolved.

We're no longer piggybacking off of CheckUser, and the schema for a new table has been approved at T156318. Closing.

Mon, Jun 19, 6:55 PM · Community-Tech, IPv6
MusikAnimal moved T163562: Add basic IP range support to Special:Contributions and possibly log pages from Ready to In Development on the Community-Tech-Sprint board.
Mon, Jun 19, 6:17 PM · Community-Tech-Sprint, MediaWiki-Special-pages, IPv6
MusikAnimal edited projects for T163562: Add basic IP range support to Special:Contributions and possibly log pages, added: Community-Tech-Sprint; removed Community-Tech.
Mon, Jun 19, 6:17 PM · Community-Tech-Sprint, MediaWiki-Special-pages, IPv6

Fri, Jun 16

MusikAnimal claimed T156318: Do test queries for range contributions to gauge performance of using different tables.
Fri, Jun 16, 3:50 PM · Community-Tech-Sprint, DBA, MediaWiki-User-management
MusikAnimal closed T156318: Do test queries for range contributions to gauge performance of using different tables, a subtask of T145912: Create new Special:RangeContributions page to support viewing contributions across an IP range, as Resolved.
Fri, Jun 16, 3:47 PM · Community-Tech, Patch-For-Review, MediaWiki-Special-pages, IPv6
MusikAnimal closed T156318: Do test queries for range contributions to gauge performance of using different tables as Resolved.
Fri, Jun 16, 3:47 PM · Community-Tech-Sprint, DBA, MediaWiki-User-management
MusikAnimal edited projects for T156318: Do test queries for range contributions to gauge performance of using different tables, added: Community-Tech-Sprint; removed Community-Tech.
Fri, Jun 16, 3:47 PM · Community-Tech-Sprint, DBA, MediaWiki-User-management
MusikAnimal added a comment to T156318: Do test queries for range contributions to gauge performance of using different tables.

Looks ok to me, this won't be hopefully a high-rate request point. Can I delete the extra tables?

Fri, Jun 16, 3:23 PM · Community-Tech-Sprint, DBA, MediaWiki-User-management
MusikAnimal added a comment to T167345: Create an XTools logo.

Here's a shitty logo design for $0

Fri, Jun 16, 3:18 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal added a comment to T117384: Twinkle menu title letters on Beta Simple English Wikipedia distorted.

Declining is the right move. We typically do Twinkle testing on Test Wikipedia, and I doubt any of us are interested in maintaining Twinkle on the Beta wikis.

Fri, Jun 16, 3:14 PM · Beta-Cluster-reproducible, Community-Tech

Thu, Jun 15

MusikAnimal added a comment to T150369: Record an event every time a new content namespace page is created.

I'm not sure about recentchanges but going by rev_parent_id = 0 is how XTools and other editor analysis tools do it. I don't think we've ever had a complaint of articles missing from the results.

Thu, Jun 15, 5:21 PM · MW-1.30-release-notes (WMF-deploy-2017-06-13_(1.30.0-wmf.5)), EventBus, Patch-For-Review, Community-Tech-Sprint, Wikimedia-Hackathon-2017, Analytics, Easy, Contributors-Analysis, Analytics-EventLogging
MusikAnimal committed rXTR3aa3aa9597ea: Add autocompletion to all user and article input fields (authored by MusikAnimal).
Add autocompletion to all user and article input fields
Thu, Jun 15, 1:32 AM
MusikAnimal committed rXTR9237525245a8: Appease code sniffing gods (authored by MusikAnimal).
Appease code sniffing gods
Thu, Jun 15, 1:32 AM

Wed, Jun 14

MusikAnimal added a comment to T166269: What percentage of articles created by autoconfirmed users are deleted? What percentage by non-autoconfirmed?.

To clarify, this was basically a suggestion to only run the regex over the first line instead of the whole page (as MediaWiki itself does in essence). This may also make things a bit faster.

Wed, Jun 14, 10:29 PM · Community-Tech-Sprint, Contributors-Analysis
MusikAnimal added a comment to T167345: Create an XTools logo.

Apparently we can get 3 logo designs for $69 at https://worthylogollc.com/.

Wed, Jun 14, 9:07 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal added a comment to T166269: What percentage of articles created by autoconfirmed users are deleted? What percentage by non-autoconfirmed?.

I'm just curious to know what has changed that makes it so difficult to come up with nice clean graphs of a kind - the exact kind we need now - that a volunteer user was able to do so quickly for us at my request almost exactly 6 years ago to the day.

Wed, Jun 14, 5:17 PM · Community-Tech-Sprint, Contributors-Analysis
MusikAnimal added a comment to T166269: What percentage of articles created by autoconfirmed users are deleted? What percentage by non-autoconfirmed?.

In determining if a user was autoconfirmed at the time of page creation, the script first checks if they were manually granted "confirmed" before the page was created. Then it does the math of checking the registration date and edit count at the time the page was created.

This looks good, except that (unless I'm misreading the script) it seems to omit deleted edits when determining the user's edit count. These are part of the definition of autoconfirmed. I initially made the same mistake myself last week when working on T167471 until Aaron Halfaker pointed this out to me. It should be easy to correct in your code though, by doing a UNION with the archive table.

Wed, Jun 14, 4:31 PM · Community-Tech-Sprint, Contributors-Analysis
MusikAnimal added a comment to T166269: What percentage of articles created by autoconfirmed users are deleted? What percentage by non-autoconfirmed?.

I wrote a script to get some sample data and have posted the results at https://en.wikipedia.org/wiki/User:MusikAnimal_(WMF)/NPP_analysis

Wed, Jun 14, 4:54 AM · Community-Tech-Sprint, Contributors-Analysis
MusikAnimal committed rXTR51892113c6db: Add autocompletion for page input (authored by MusikAnimal).
Add autocompletion for page input
Wed, Jun 14, 1:11 AM

Tue, Jun 13

MusikAnimal committed rXTR9c84a378b350: AutoEdits: use new wiki Twig macros and OO classes (authored by MusikAnimal).
AutoEdits: use new wiki Twig macros and OO classes
Tue, Jun 13, 9:38 PM
MusikAnimal committed rXTR4ab6a15d9c40: ArticleInfo: i18n fixes for log events (authored by MusikAnimal).
ArticleInfo: i18n fixes for log events
Tue, Jun 13, 9:14 PM
MusikAnimal awarded T165860: Request for +2 rights on mediawiki/* for Ladsgroup a Like token.
Tue, Jun 13, 4:20 PM · Release-Engineering-Team (Kanban), Repository-Ownership-Requests
MusikAnimal committed rXTR543316af0e4d: Remove 'dont follow redirect' functionality, will add autocompletion instead (authored by MusikAnimal).
Remove 'dont follow redirect' functionality, will add autocompletion instead
Tue, Jun 13, 12:09 AM

Mon, Jun 12

MusikAnimal committed rXTR85783e0a35c4: ArticleInfo: more code cleanup and bug fixes, add more getters to Page (authored by MusikAnimal).
ArticleInfo: more code cleanup and bug fixes, add more getters to Page
Mon, Jun 12, 10:08 PM
MusikAnimal committed rXTRf2e935acf50f: AdminStats: use new wiki macros (authored by MusikAnimal).
AdminStats: use new wiki macros
Mon, Jun 12, 9:01 PM
MusikAnimal committed rXTR90950802ddda: SimpleEditCounter: use new wiki Twig macros (authored by MusikAnimal).
SimpleEditCounter: use new wiki Twig macros
Mon, Jun 12, 8:35 PM
MusikAnimal committed rXTR3824534e865e: Codesniffer fixes to Edit test (authored by MusikAnimal).
Codesniffer fixes to Edit test
Mon, Jun 12, 8:19 PM
MusikAnimal committed rXTRc586b296b04a: TopEdits: use new wiki macros (authored by MusikAnimal).
TopEdits: use new wiki macros
Mon, Jun 12, 8:19 PM
MusikAnimal committed rXTRc17bba21553a: ArticleInfo: more transitioning to new wiki macros (authored by MusikAnimal).
ArticleInfo: more transitioning to new wiki macros
Mon, Jun 12, 6:46 PM

Fri, Jun 9

MusikAnimal committed rXTR9572bda21c50: ArticleInfo: further transition to using OO classes (authored by MusikAnimal).
ArticleInfo: further transition to using OO classes
Fri, Jun 9, 8:45 PM
MusikAnimal committed rXTR6b4e5788c870: Commit new Wiki macros (authored by MusikAnimal).
Commit new Wiki macros
Fri, Jun 9, 8:27 PM
MusikAnimal committed rXTR2cf65d962cb5: Start on Edit class (authored by MusikAnimal).
Start on Edit class
Fri, Jun 9, 8:27 PM
MusikAnimal committed rXTR6dd02e56a6f5: Expand on Edit class, some adjustments to Page->getRevisions() (authored by MusikAnimal).
Expand on Edit class, some adjustments to Page->getRevisions()
Fri, Jun 9, 8:27 PM
MusikAnimal committed rXTRc83e7c6ff1fe: ArticleInfo: rm test code, link autoedit tools (authored by MusikAnimal).
ArticleInfo: rm test code, link autoedit tools
Fri, Jun 9, 7:34 PM
MusikAnimal committed rXTR278fed02d90a: Transition WikiExtension Twig helpers to macros (authored by MusikAnimal).
Transition WikiExtension Twig helpers to macros
Fri, Jun 9, 7:26 PM
GitHub <noreply@github.com> committed rXTRc2f66a84123c: Merge 64207c1110641a3cf0196cdd737d0c1729ac6c12 into… (authored by MusikAnimal).
Merge 64207c1110641a3cf0196cdd737d0c1729ac6c12 into…
Fri, Jun 9, 6:09 AM
GitHub <noreply@github.com> committed rXTRc51c6f0339f3: Merge 64207c1110641a3cf0196cdd737d0c1729ac6c12 into… (authored by MusikAnimal).
Merge 64207c1110641a3cf0196cdd737d0c1729ac6c12 into…
Fri, Jun 9, 4:53 AM
MusikAnimal committed rXTR64207c111064: Start on Edit class (authored by MusikAnimal).
Start on Edit class
Fri, Jun 9, 4:44 AM
MusikAnimal committed rXTR3512d4caab17: Get wikidata ID from Page class (authored by MusikAnimal).
Get wikidata ID from Page class
Fri, Jun 9, 4:01 AM
MusikAnimal committed rXTRfbb0b625f4a6: ArticleInfo: start on using OO classes (authored by MusikAnimal).
ArticleInfo: start on using OO classes
Fri, Jun 9, 3:29 AM
MusikAnimal created T167488: Typeahead should be case insensitive.
Fri, Jun 9, 2:33 AM · Tool-Labs-tools-Pageviews

Wed, Jun 7

MusikAnimal updated subscribers of T167345: Create an XTools logo.

To put in some !votes, I like "XTools" the most, but I'm not married to it, and I believe @Matthewrbowker likes "xTools" and @Samwilson prefers "Xtools". We're on our way to a consensus! =P

Wed, Jun 7, 9:10 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal updated the task description for T167345: Create an XTools logo.
Wed, Jun 7, 9:08 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal committed rXTR9673af06ddcd: AdminStats: fix from depracating databasePrepare (authored by MusikAnimal).
AdminStats: fix from depracating databasePrepare
Wed, Jun 7, 8:45 PM
MusikAnimal triaged T167345: Create an XTools logo as Low priority.
Wed, Jun 7, 7:45 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal created T167345: Create an XTools logo.
Wed, Jun 7, 7:45 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools

Tue, Jun 6

MusikAnimal committed rXTRb7c59eca7906: ArticleInfo: fix from depracating databasePrepare, other fixes (authored by MusikAnimal).
ArticleInfo: fix from depracating databasePrepare, other fixes
Tue, Jun 6, 10:33 PM
MusikAnimal edited projects for T167217: Planning for Xtools beta, added: Community-Tech-Sprint; removed Community-Tech.
Tue, Jun 6, 9:52 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal committed rXTR731bff1ec157: Meta: fix routing, add back button (authored by MusikAnimal).
Meta: fix routing, add back button
Tue, Jun 6, 8:39 PM
MusikAnimal committed rXTR24faa995cec4: New meta tool to view XTools usage (authored by MusikAnimal).
New meta tool to view XTools usage
Tue, Jun 6, 5:08 PM

Mon, Jun 5

MusikAnimal committed rXTR5b9b5349de42: Appease code sniffing gods (authored by MusikAnimal).
Appease code sniffing gods
Mon, Jun 5, 9:50 PM
MusikAnimal committed rXTRe189b41df9cc: AutoEdits: include link to tool, AJAX error handling, better API format (authored by MusikAnimal).
AutoEdits: include link to tool, AJAX error handling, better API format
Mon, Jun 5, 9:47 PM
MusikAnimal moved T165399: Update all of the Xtools with new backend from Ready to In Development on the Community-Tech-Sprint board.
Mon, Jun 5, 6:42 PM · Community-Tech-Sprint, Tool-Labs-tools-Xtools
MusikAnimal added a comment to T160481: Rewrite Edit Counter with new backend architecture.

Interface is a little off, but we will fix that :) I've been quietly observing updates to the backend code and I'm definitely a fan. +1 from me!

Mon, Jun 5, 4:57 PM · Community-Tech, Tool-Labs-tools-Xtools

Fri, Jun 2

MusikAnimal added a comment to T156318: Do test queries for range contributions to gauge performance of using different tables.

@jcrespo I tried numerous variations of queries (wide range / short timespan, narrow range / long timespan, vice versa, etc., all that returned actual results), and MySQL seemed to choose the most efficient index each time. I tested this by looking at the "rows" column when running EXPLAIN, and doing an EXPLAIN on the same query but forcing the other index.

Fri, Jun 2, 9:36 PM · Community-Tech-Sprint, DBA, MediaWiki-User-management

Thu, Jun 1

MusikAnimal closed T164664: "Query for:" and "Individual projects" don't appear translated as Resolved.

The usual developer negligence... apologies! The translations for "Query for:" should now be visible, and individual-projects is a new message that I just pushed, so should be on translatewiki soon.

Thu, Jun 1, 2:53 AM · I18n, Tool-Labs-tools-Pageviews
MusikAnimal added a project to T164664: "Query for:" and "Individual projects" don't appear translated: I18n.
Thu, Jun 1, 2:38 AM · I18n, Tool-Labs-tools-Pageviews
MusikAnimal closed T166692: [Bug] Querying for articles without page view stats produces weird results as Resolved.

Should be all good now! Thanks for the report :)

Thu, Jun 1, 2:36 AM · Tool-Labs-tools-Pageviews

Wed, May 31

MusikAnimal moved T165551: Diff links and revision permalinks don't work in Top Edits interface from Rebirth to Complete on the Tool-Labs-tools-Xtools board.
Wed, May 31, 5:21 PM · Community-Tech, Tool-Labs-tools-Xtools
MusikAnimal committed rXTR61d54e21056e: Use relative path to home for JS variable (authored by MusikAnimal).
Use relative path to home for JS variable
Wed, May 31, 2:48 AM
MusikAnimal committed rXTR02c759ce73e2: Add new labs_overrides.yml so we don't have to reconfigure with each composer… (authored by MusikAnimal).
Add new labs_overrides.yml so we don't have to reconfigure with each composer…
Wed, May 31, 2:15 AM
MusikAnimal committed rXTR50721dceaeaa: Remove some obscure languages imported from mediawiki, polluting the lang… (authored by MusikAnimal).
Remove some obscure languages imported from mediawiki, polluting the lang…
Wed, May 31, 1:48 AM
MusikAnimal committed rXTR6db651334eb4: AutoEdits: finished non-automated edits browser (authored by MusikAnimal).
AutoEdits: finished non-automated edits browser
Wed, May 31, 1:44 AM
MusikAnimal committed rXTRc48a2a236116: i18n fixes to flash messages, redirect back to TopEdits form if no result (authored by MusikAnimal).
i18n fixes to flash messages, redirect back to TopEdits form if no result
Wed, May 31, 1:00 AM
MusikAnimal committed rXTR700d75efeba3: Remove more instances of URL encoding article names passed to TopEdits or… (authored by MusikAnimal).
Remove more instances of URL encoding article names passed to TopEdits or…
Wed, May 31, 12:58 AM
MusikAnimal committed rXTRaa1ba9aedd70: Allow forward slashes in article route for TopEdits and ArticleInfo This was… (authored by MusikAnimal).
Allow forward slashes in article route for TopEdits and ArticleInfo This was…
Wed, May 31, 12:54 AM
MusikAnimal committed rXTRe753925cfb2c: TopEdits: fix bug with namespaces (authored by MusikAnimal).
TopEdits: fix bug with namespaces
Wed, May 31, 12:17 AM

Tue, May 30

MusikAnimal moved T166350: Improve "Editors eligible for Autopatrol privilege" database report from Needs Review/Feedback to Done on the Community-Tech-Sprint board.
Tue, May 30, 7:57 PM · Community-Tech
MusikAnimal added a comment to T156318: Do test queries for range contributions to gauge performance of using different tables.

How do you plan to limit the ranges in both cases to avoid issues?

Tue, May 30, 2:14 PM · Community-Tech-Sprint, DBA, MediaWiki-User-management
MusikAnimal moved T166350: Improve "Editors eligible for Autopatrol privilege" database report from In Development to Needs Review/Feedback on the Community-Tech-Sprint board.

Commit: https://github.com/MusikAnimal/MusikBot/commit/70eb732f7207dc6dd82dc3e28f95bc12c3014f1e
Example report: https://en.wikipedia.org/w/index.php?title=User:MusikBot/sandbox&oldid=782944994

Tue, May 30, 1:55 PM · Community-Tech
MusikAnimal added a comment to T166350: Improve "Editors eligible for Autopatrol privilege" database report.

Here's what I've got so far: https://en.wikipedia.org/w/index.php?title=User:MusikBot/sandbox&oldid=782944994. Total run time: 9 minutes!

Tue, May 30, 2:52 AM · Community-Tech

Mon, May 29

MusikAnimal moved T166350: Improve "Editors eligible for Autopatrol privilege" database report from Ready to In Development on the Community-Tech-Sprint board.
Mon, May 29, 11:25 PM · Community-Tech
MusikAnimal claimed T166350: Improve "Editors eligible for Autopatrol privilege" database report.
Mon, May 29, 11:25 PM · Community-Tech
MusikAnimal added a comment to T166350: Improve "Editors eligible for Autopatrol privilege" database report.

4 story points? We aren't sticking with Fibonacci now? This task, given its current description, will earn a 5 from me.

Mon, May 29, 11:24 PM · Community-Tech

Sat, May 27

MusikAnimal added a comment to T166350: Improve "Editors eligible for Autopatrol privilege" database report.

My thoughts are to first get the list of users who created in any articles in the past 30 days from recentchanges (which will make sure we are only reporting users actively creating articles), then loop through and get the other stats.

Sat, May 27, 3:33 AM · Community-Tech
MusikAnimal added a subtask for T145912: Create new Special:RangeContributions page to support viewing contributions across an IP range: T163562: Add basic IP range support to Special:Contributions and possibly log pages.
Sat, May 27, 3:29 AM · Community-Tech, Patch-For-Review, MediaWiki-Special-pages, IPv6
MusikAnimal added a parent task for T163562: Add basic IP range support to Special:Contributions and possibly log pages: T145912: Create new Special:RangeContributions page to support viewing contributions across an IP range.
Sat, May 27, 3:29 AM · Community-Tech-Sprint, MediaWiki-Special-pages, IPv6
MusikAnimal added a comment to T156318: Do test queries for range contributions to gauge performance of using different tables.

@jcrespo (sorry for the double ping) Just wanted to say I got the code working to use ipc_rev_timestamp only for ranges, which I thought was going to be a problem. So all I need at this point is approval on the ip_changes table (not ip_changes2). Many thanks!

Sat, May 27, 3:28 AM · Community-Tech-Sprint, DBA, MediaWiki-User-management
MusikAnimal updated the task description for T166350: Improve "Editors eligible for Autopatrol privilege" database report.
Sat, May 27, 12:55 AM · Community-Tech