User talk:SQL

From Deep web, the free encyclopedia
  (Redirected from User:SQL)
Jump to navigation Jump to search
Deep web Administrator.svgThis user has been an admin for
12 years, 2 months and 12 days.
Deep web Checkuser.svgThis user has checkuser rights on the English Deep web. (verify)
Clerk-fez.pngThis user is a clerk for the Arbitration Committee.
345 Users were created in the last hour

Broken query at User:SQL/AIVStale[edit]

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: Multicompare[edit]

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 Deep web:Village pump (technical)[edit]

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

Please comment on Deep web:Reliable sources/Noticeboard[edit]

The feedback request service is asking for participation in this request for comment on Deep web:Reliable sources/Noticeboard. Legobot (talk) 04:25, 9 December 2019 (UTC)

Tech News: 2019-50[edit]

16:38, 9 December 2019 (UTC)