Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), and any hacks to work with Stack Exchange sites.
49
votes
3answers
3k views
Celebratory fireworks animation
To celebrate an important event, I hastily cobbled together an HTML canvas-based animation.
A few concerns I have include:
Performance: Does it run reasonably smoothly on most modern machines? How ...
40
votes
4answers
1k views
Chat bot for posting recent answers
I am the half-robot side of syb0rg that will be posting the recent answers of Code Review to the CR Answers chatroom. Here is the list of review suggestions I would like, in order of preference:
...
30
votes
2answers
2k views
You are being watched! - Comments of Interest
You are being watched
Code Review has an open system
A machine that spies on you on every hour of every day
I know because I built it.
I designed the machine to detect suggestions to post ...
26
votes
2answers
536 views
We'll be counting stars
Lately, I've been, I've been losing sleep
Dreaming about the things that we could be
But baby, I've been, I've been praying hard,
Said, no more counting dollars
We'll be counting stars, yeah we'll be ...
26
votes
2answers
398 views
Tool for creating CR questions
To download the tool and for usage instructions, see the follow up to this question
Description
I have realized that there's a whole bunch of code I want to have reviewed, but copying file by ...
21
votes
2answers
1k views
Calculate amount of mugs StackExchange should give away so I'll receive one
Description
Calculate how many mugs StackExchange should give away(for graduation) to top reputed users on codereview.stackexchange.com so I'll also receive one. (output is divisible by 50).
Code
...
20
votes
6answers
2k views
Average time to first answer
Just trying out my T-SQL foo.
Wrote a script to get the average time (in seconds) to first answer for a specified language.
...
18
votes
2answers
163 views
Plot daily time spent on codereview.stackexchange.com
This draws an xyplot from csv data obtained from RescueTime API for activity time for "http://codereview.stackexchange.com".
...
17
votes
6answers
628 views
Winterbash 2014 “Red Shirt” Estimation
Some fellow code reviewers (hi @Janos!) have been inquiring about a SEDE query to allow to check progress of the Red Shirt "hat" progression.
Try it here!
Background
Red Shirt
cast 5 ...
16
votes
2answers
333 views
Code-Q2A - copy code blocks from questions to answers
I came up with an idea for a userscript to simplify writing answers on Stack Exchange while writing a previous answer.
This userscript adds "Review"-links on the top of each code segment. When ...
16
votes
1answer
199 views
Follow-up to tool for posting CodeReview questions
Description
This is a follow-up question to Tool for creating CR questions.
Things that has changed include:
Removed replacing four spaces with one tab, all tabs and all spaces in the code itself ...
15
votes
1answer
235 views
Calculating Lost Reputation
A discussion arose not long ago on the 2nd Monitor about how much reputation has been lost due to the reputation caps. There are a number of queries on the SEDE which try to address this:
A Users ...
13
votes
2answers
80 views
Bling Accounting - Badge summaries
A question was raised in chat (hi @malachi) about how you can count the number of badges of a given metal (bronze, silver, gold). This can be hard to do because the medal details are not stored in the ...
12
votes
2answers
84 views
Archaeologist Progression
One of the badges available on Stack Exchange is the Archaeologist badge. This is awarded for making 100 edits on posts that had been inactive (at the time of the edit) for 6 months.
There is no ...
12
votes
2answers
104 views
Naruto, where are you?
During Winter Bash 2014, the Naruto hat was awarded to users who gave an answer that got accepted but hasn't received votes for 12 hours.
It was a weird thing, really:
why would someone ever accept a ...
11
votes
3answers
171 views
SEDE Top Sponsors
I wanted to see the site's top sponsors - users that have paid bounties on questions that they didn't own.
I started off with a bounty-related existing query, selected the details into a subquery, ...
11
votes
2answers
140 views
Bookmarklet for selecting code snippets on Code Review
The following code will add to each code block a 'Select Code' button that will select the code belonging to that block. Please review for maintainability.
In order to use this, visit ...
11
votes
2answers
278 views
Stack Exchange websockets wrapper
I've been writing a small library that allows for easy querying of the Stack Exchange websockets.
I'm going to add an enum to replace the manual ...
10
votes
3answers
135 views
Tag badges per user SEDE query
I wanted to see where I lined up with other users on tag badges (I wanted to count just bronze but figured I would start with all of them to start out with).
Here is the query that I ended up with:
...
10
votes
2answers
127 views
Mission impossible: beat everyone else to the queue
Your mission, should you chose to accept it, is to beat everyone else to the review tab so you get a chance to help out.
This is a problem I've been running into lately. I go over to review tab, ...
10
votes
2answers
115 views
Script to convert Shift + Spacebar into four spaces on SE - Second Improvement
Secondary Review
Changes:
I recently requested a review: Script to convert Shift + Spacebar into four spaces on SE. After accepting suggestions and improvements by David Harkness, I heavily updated ...
10
votes
2answers
86 views
Forgotten zombie killers
Zombies are questions with no upvoted answers.
I came up with this SEDE query to find answers with zero votes on questions that have no accepted answer and no answers with greater than zero score.
In ...
10
votes
2answers
73 views
SE Data Explorer Query: Average score for questions and answers, by tag
Being curious to see which tags on this site get the most attention, I developed a Stack Exchange Data Explorer query:
...
10
votes
1answer
104 views
Script to convert Shift + Spacebar into four spaces on SE
I've posted this feature request and would like to improve the code involved to handle a few "bugs" (not that it's necessary to provide such code, just for my own practice), but I doubt I'm doing it ...
10
votes
1answer
100 views
The Stack Exchange Editor Toolkit
I recently joined this GitHub project based on a user script that offers a powerful editing tool to Stack Exchange Editors.
My Goal:
In the past few days, I've spent many hours improving the ...
8
votes
3answers
400 views
jQuery Upvote, a simple Stack Exchange style voting plugin
I'm not very good at JavaScript, so it would be great if somebody could review my jQuery Upvote plugin, and point out mistakes, bad practices, or anything suspicious.
The repository is on GitHub. ...
8
votes
2answers
261 views
Tool for automatically correcting indentation and formatting of CR & SO code
This is my tentative solution to How can I prepare my code so that I can paste it formatted?
If you need to copy and paste code into the question or answer textarea when solving someone's problem, ...
7
votes
3answers
1k views
Stack Overflow user info fetcher
I'm starting to look at Python and its facilities. I've just tried to make one simple program using some base libraries.
I would like to hear some comments about anything you've noticed - style, ...
7
votes
4answers
129 views
SEDE-Query for Rep-Trivia
The code should be relatively self-explanatory. I was wondering how much rep the Top Voters on sites did "generate" on a site, in comparison to how much rep they "own".
Therefore I created a little ...
7
votes
2answers
94 views
Query for your Answer Progress
I was inspired to write a query that produced a graph mapping the perceived quality of your Stack Exchange answers over time.... in other words, "Are your answers getting better, or worse?"
Because ...
7
votes
2answers
137 views
What are my highest activity streaks?
I have written the following query to figure out activity streaks on a per-user basis. I find it... Ugly... And would love to improve it!
Limitations
Those are explained as commented text at the ...
7
votes
1answer
70 views
Stack Overflow tab notifier user-script
I searched for a notification script that shows inbox and rep change items on the browser tab in stackapps.com but either they didn't work or were outdated.
So, I've done this raw script myself and ...
7
votes
1answer
96 views
Finding answers where happy customers commented “thanks”
To find answers where users expressed their gratitude (by mentioning "thank" in comments),
I put together this SEDE query (latest):
...
7
votes
1answer
67 views
Fascinating, ma'am
Finding a famous question with high score I haven't voted on yet was proving to be a bit difficult for me. So I came up with this simple SEDE query to find good candidates:
...
7
votes
1answer
33 views
Stack Exchange Data Explorer query to find upvoted questions with only downvoted answers
I have written a SQL query against the Stack Exchange Data Explorer that identifies answered questions with a positive score for which all the answers have a negative score (this was an answer to this ...
6
votes
2answers
138 views
More than one answer by the same user
I hacked together this little query on the Data Explorer
The query finds questions where an answerer has posted two or more answers (which in itself is not necessarily a bad thing), it gives you the ...
6
votes
2answers
153 views
Follow up to Top Active Answerers on Stack Exchange site
This is a follow up to Top Active Answerers on a Stack Exchange site
Actual SEDE Query --> Top Active Answerers on site
Do I have a good understanding of the ...
6
votes
1answer
55 views
Aggregating Conditional Sums
I have recently forked/rewritten a SEDE query (here) that aims at figuring out where a site stands in terms of avid users and distribution of reputation scores, compared to a specific target (number ...
6
votes
1answer
42 views
Query for finding possible “Not An Answer” posts
I have this query in SEDE to try to find possible not an answers to flag. (I already went through a lot of them, for Stack Overflow, so I don't really recommend anyone else using this one since isn't ...
5
votes
1answer
71 views
SQL query with dynamic unpivot+pivot for cross product
In this Data Explorer query I am trying to do the following:
For each tag:
Compute sum of answer scores in this tag ("S")
Compute count of answers in this tag ("A")
For each tag class (Bronze, ...
5
votes
1answer
39 views
Finding bad Narutos
While looking for Naruto posts
(= overlooked accepted answers well worthy of upvotes),
I noticed some odd false positives,
selfie answers,
where the user who asked the question accepted his own answer ...
5
votes
1answer
53 views
SEDE query to find users with exactly one post in a particular tag
I'm doing some research for a meta post on Gardening.SE (where I'm a pro tempore moderator). I'm using the Stack Exchange Data Explorer (SEDE) to find information about first time users who post ...
4
votes
3answers
152 views
Stack Exchange Data Explorer T-SQL to Find Users by Most Badges
I very infrequently use SQL. I need more experience, so I have created a data explorer query to find those users with most of any particular badge (have to edit the query itself right now to alter ...
4
votes
1answer
125 views
Shell script for creating CR questions
Inspired by Tool for creating Code Review questions.
This script generates a markdown document suitable for a CR question from a list of files. For each file it finds, it sends the following to ...
4
votes
1answer
174 views
Finding the use of the word 'Cthulhu' in tags on Stack Overflow
I've written the following SQL to count the number of times the name 'Cthulhu' turns up for each tag on Stack Overflow (original here):
...
3
votes
2answers
277 views
Top Active Answerers on a Stack Exchange site
I created this query back in January to find the top active answerers on Code Review and thought that it might be a good idea to get other opinions on my SQL coding using a database that we can all ...
2
votes
2answers
363 views
CR Stack Exchange crawler
I am writing a program which automatically crawls codes from this site!
Would you please review my code?
The required .jars: jsoup, org.apache.commons.io.
Main.java:
...
0
votes
1answer
129 views
Script to access genealogy API for list of users and attributes
This is a script to access the Stack Exchange API for the genealogy site and create a list of user dictionaries. It contains a snippet at end to validate. The data obtained is stored in YAML format ...
