Open main menu

User talk:SQL

  (Redirected from User:SQL)
Wikipedia Administrator.svgThis user has been an admin for
12 years, 2 months and 11 days.
Wikipedia Checkuser.svgThis user has checkuser rights on the English Wikipedia. (verify)
Clerk-fez.pngThis user is a clerk for the Arbitration Committee.
289
289 Users were created in the last hour


Broken query at User:SQL/AIVStaleEdit

Hi SQL, the query linked at User:SQL/AIVStale seems to have broken during the database structure changes. ~ ToBeFree (talk) 20:16, 30 November 2019 (UTC)

ToBeFree, I've updated the example query so it works now. That isn't why the bot isn't posting, however. I need to make some backend updates to the framework I use with regards to login tokens. SQLQuery me! 22:22, 30 November 2019 (UTC)
Oh, okay, thank you very much   ~ ToBeFree (talk) 22:23, 30 November 2019 (UTC)
ToBeFree, I ended up having to rewrite a lot of it, but it's fixed now. SQLQuery me! 16:25, 1 December 2019 (UTC)
  ~ ToBeFree (talk) 17:16, 1 December 2019 (UTC)
I have a feeling Special:Diff/928831040 is unintentional. :) While not problematic, you may like to investigate this. ~ ToBeFree (talk) 23:03, 1 December 2019 (UTC)
ToBeFree, Yep, sure is. I'll take a look at it in a bit. SQLQuery me! 23:09, 1 December 2019 (UTC)

New tool: MulticompareEdit

Allows the user to generate a changes feed for many users, as well as shows overlap of those users.

At the moment, it only works on the recentchanges table (~30 days), and the colors are somewhat terrible (I'd love suggestions + hex codes for 20 colors that look good!). Allows a much larger number of editors to be compared than any of the current editor comparison tools do for performance reasons. I came across the need for a tool like this a few times recently when looking at large sock farms.

I'm working on a mechanism to do longer contribs searches in the revision table via chunking, which should be coming soon. SQLQuery me! 17:20, 5 December 2019 (UTC)

Now allows you to search contribs overall. Cumulative query time is limited at the moment, so on people with large amounts of edits, it won't get all of them. SQLQuery me! 20:53, 5 December 2019 (UTC)
There's a bug at the moment when using non-recentchanges contribs, where it isn't displaying data. SQLQuery me! 23:22, 5 December 2019 (UTC)
Fixed! SQLQuery me! 04:29, 7 December 2019 (UTC)

Please comment on Wikipedia:Village pump (technical)Edit

The feedback request service is asking for participation in this request for comment on Wikipedia:Village pump (technical). Legobot (talk) 04:28, 7 December 2019 (UTC)

Return to the user page of "SQL".