Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.
9
votes
1answer
59 views
The Handy-Dandy Apocalypse Assistant
Code Review is running rampant with an infection. A zombie infection.
Everywhere posts are becoming rapidly mutated into slobbering, green
freaks of nature. But the citizens of Code Review are ...
15
votes
2answers
1k views
Searching for bad Minecraft questions on Gaming.SE
To preface this post a little bit, I'll explain a little bit of the "backstory" here. The Stack Exchange site, Gaming.SE, also known as Arqade, often has a large influx of bad questions about the ...
6
votes
2answers
107 views
Sum-based sliding rate limiting with Redis and Lua
As I'm new to Redis, I would like to get a review / improvement suggestions from Redis / Lua experts on the following problem and the solution I have found so far.
Problem
The context is: an ...
6
votes
1answer
49 views
Desktop Notifications for Queue Items - Updated Code
A while ago I took one of @Simon's scripts and updated it to make it more geared towards normal users (no offense mods) and this Question was created. But the link to the Github is no longer correct ...
4
votes
2answers
76 views
The Badge Bot 9000
Because I'm both lazy and wanting to mess around more with time management and Ruby, I thought it would be fun to create a simple script that opens Code Review once every day to go towards the daily ...
7
votes
1answer
48 views
Retrieving StackExchange sites and tags
I have setup agenda tasks to periodically retrieve and possibly insert new SE sites and tags in my MongoDB database.
Some things that bother me in particular:
Lots of code duplication
No string ...
27
votes
1answer
259 views
Beta-Blue B. Gone
I've written a Code Review design using Userscripts and CSS.
It works by fetching the CSS from my GitHub repo, and using the built in gm_addStyle function to add ...
17
votes
3answers
3k views
Oh my goodness: How many selfies have I taken?
The title is a joke on how some people take a lot of selfies pictures
Recently, in The 2nd Monitor, there was a brief discussion on selfie answers, starting with this post.
At one point, a user said ...
7
votes
1answer
73 views
First SO chat message in Haskell followup
I have wrote an application which asks for the user id, and returns a link to the first available chat message:
Output
Enter user id:
322395
Fetching data...
...
4
votes
0answers
45 views
Find first SO chat message in Haskell
I have made some simple functions to find the first SO chat message. How can I improve my code?
Even if there is a stackoverflow link that will get the job done (I'd be glad to know), I'd like to ...
13
votes
3answers
133 views
GitHub link oneboxer for chat
I've made a userscript that oneboxes links to GitHub repos, issues or pull requests in Chat after seeing the request One-box repositories, issue tickets and such on GitHub in the chat on Meta.
It ...
7
votes
2answers
147 views
Desktop notifications for queue items
I wasn't satisfied with Simon's alert on the orange alert. I wanted to know if even 1 review item was available, so I made some modifications to the userscript so that it runs on the Review page, and ...
26
votes
3answers
2k views
Excuse me, how many of you are new here? Mind if I JOIN you?
I had perceived an uptick in new reviewers around here, and I wanted to see if the data backed that observation up. It's been a while since I've written any SQL, so this was a nice little exercise in ...
4
votes
0answers
23 views
Tag wikis under a certain length
I wrote a SEDE query to list all tag wikis with a body or an excerpt under a given number of characters. I've used this to find empty wikis or wikis with very little information. The tags can be ...
20
votes
2answers
309 views
Desktop Notifications for flags and queue items
After our recent election, I got elected as a moderator here on Code Review (Thank you, community members!). One of the first things I missed among the moderator tools was desktop notifications for ...
5
votes
1answer
52 views
Searching posts/comments by keywords
I've put together another simple query that allows you to search post/comments with specific keywords. At the moment, only post bodies are checked.
...
9
votes
3answers
386 views
Popular questions by view count
I made this query to create a graph of a user's popular questions and the view count on that question. It allows for a minimum of 500 views, and a score of ...
4
votes
0answers
48 views
Finding which users have the most questions with unaccepted answers
I was looking at a few profiles this afternoon and noticed a few users had plenty of open questions. This led me to wonder which users actually had the highest amount of questions with unaccepted ...
3
votes
2answers
35 views
Percentage of questions that are unanswered or answered - Part 2
I've refactored my previous query and added better checks when selecting the data. The query link can be found here. The formulas used to calculate the two percentages are the same, and can be seen ...
10
votes
1answer
901 views
Soup of the day: best served during election season
Community moderator elections on the Stack Exchange network are really exciting.
Alas, on the page of the primaries, I find it mildly annoying that candidates are randomly reordered on every page ...
10
votes
2answers
300 views
Percentage of questions that are unanswered or answered
I put together this simple query which calculates the total percentage of answered questions and unanswered questions. The formulas used to calculate these are shown below:
$$
\text{Answered ...
6
votes
2answers
240 views
Another JavaScript Stack Exchange chat bot
I've been inspired by @SirPython's SirAlfred JavaScript chat bot, so I went and made my own. This one is slightly different though, in the fact that it can accept input in a more lenient way. For ...
15
votes
2answers
204 views
Election vote-counting, result-posting chatbot
In preparation for the end of Code Review's 2015 election, I've built a simple bot to get the election votes, run OpenSTV on them, and post the result to a chatroom. I'm using this Python ...
14
votes
4answers
218 views
The chatbot for The Community Post Pimping Board
I recently wrote a chat bot for a chat room here at Code Review. The chatroom is meant to be a place where people can come and pimp a post.
That chat bot is meant to handle a list of subscribed ...
52
votes
3answers
3k views
Shielding your CodeReview on GitHub
In response to a feature-request on meta, I spent a few hours today creating the feature in php.
This application adds a review shield to your GitHub repository (or wherever else you want it).
It ...
5
votes
2answers
131 views
Finding questions to answer - Part 2
I've refactored my previous question finder, and added multi-tag support, and support for searching for keywords in the question titles. Essentially, what it does is find questions that could be ...
8
votes
2answers
134 views
Finding questions to answer
In light of the recent "SQL frenzy" of sorts in The 2nd Monitor, I decided to take a stab at writing my own SEDE query. Essentially, what it does is find questions that could be answered based on the ...
17
votes
2answers
273 views
“How can I make this SEDE query better?” (bad title finder)
It was suggested on Meta for July 2015 Community Challenge to make a bot that can find questions with bad titles. I wrote this query to help others find examples to help them make write their code.
...
18
votes
4answers
2k views
Top users under age 30, sorted by age, with rank
In the pursuit of SQL enlightenment, I wrote a quick SEDE query to display Rep, Age and Overall ...
8
votes
1answer
60 views
The opposite of CodeLess Questions query
What's the opposite of CodeLess Questions?
Perhaps CodeOnly Answers? (Also known as code dumps.)
Inspired by the opposite question, here's the opposite query:
...
11
votes
1answer
291 views
CodeLess Questions query
As part of an exercise by Jamal to clean up old questions on Code Review that have no code in them, I helped by writing this query on Stack Exchange Data Explorer: CodeLess Questions
...
1
vote
3answers
77 views
Fast tag replacements
This uses the Stack Exchange API to quickly batch replace tags in questions.
I still need to fully comment and make the Wiki, but are there any glaring mistakes in it?
I have tried to use ...
12
votes
2answers
137 views
A closer look at the chat's mumblings
The Go Playground was boring so I decided to make a small application that throws me into the language. It basically queries the chatroom every second for new messages and displays them in the output ...
7
votes
2answers
54 views
Query to find users from where?
Based on my question here, I have updated my query to take user input so it can be a generic query:
...
5
votes
2answers
56 views
1st questions with answers within X hours
I recently challenged @Hosch520 with writing a query as such:
Find first questions with answers posted within 24 hours
And he did great. I figured I would have a go at it too. Turns out I ...
3
votes
1answer
49 views
Find first questions with answers posted within 24 hours
So, sᴉɔuɐɹɥԀ suggested I write a SEDE query to find first questions with answers posted within 24 hours, and here it is:
...
7
votes
4answers
1k views
Query to find users from Australia
After a discussion of which users were from Australia, I wrote my first SQL query to find out:
...
10
votes
2answers
286 views
StackEgg autoclicker
I wrote a quick and dirty auto-clicker for the StackEgg. Any comments, both on code and effectiveness?
...
10
votes
2answers
154 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, ...
7
votes
1answer
50 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 ...
4
votes
3answers
184 views
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 ...
39
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 ...
5
votes
1answer
63 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 ...
7
votes
1answer
100 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):
...
17
votes
2answers
431 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 ...
10
votes
2answers
94 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 ...
17
votes
2answers
196 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 ...
7
votes
2answers
149 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 ...
17
votes
6answers
644 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 ...
7
votes
1answer
71 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:
...
