Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.
6
votes
1answer
45 views
Who likes that post?
Following on from my last question, I've been continuing to look at what information is available from the SE Data Explorer, I thought it would be interesting to know who else had favorited a question....
7
votes
2answers
48 views
Retrieve high views per day questions with few answers
I've been messing around with the SE Data Explorer and I've come up with a query that basically returns information about questions that have a high number of views per day, that have few or no ...
3
votes
0answers
16 views
Data Explorer query that makes bar graphs
I wrote a query for SEDE that I think is pretty cool. It uses the currently available graphing capabilities (scatter plots) to create a bar graph. I have used it as the subject for a self-answer on ...
3
votes
0answers
20 views
Userscript to add Prettify extensions on SE
I wrote a userscript (to be run with Greasemonkey/Tampermonkey on Stack Exchange sites) to include a Prettify extension and enable syntax highlighting for a language which isn't supported by default. ...
8
votes
1answer
102 views
Accessing the Stack Exchange API
Part of a project I'm getting started on requires access to the Stack Exchange API for certain data, as a result I built a .NET implementation to interact with it.
The implementation is pretty simple,...
8
votes
1answer
103 views
Top 10 editors partitioned by year
I wanted to get some stats on who has done the most edits on Code Review, so I wrote the following query on SE Data Explorer. All improvement suggestions are welcome.
Note that I used a cursor to ...
5
votes
2answers
88 views
Adding links to tags on StackExchange sites
This Greasemonkey script adds links to tags on StackExchange sites which allow for activating, deactivating and ignoring favorite and related tags by using UI components.
Since JavaScript is not my ...
10
votes
3answers
67 views
From Q to compiler in less than 30 seconds
As an adjunct to From new Q to compiler in 30 seconds, I've created a Python script to automatically download the markdown from any question on Code Review and save it to a local file using Unix-style ...
7
votes
1answer
83 views
Smoke the SmokeDetector
In Tavern on the Meta, our spam detector is a bot named SmokeDetector.
While you can ignore the bot, you can't ignore specific replies to Smokey without ignoring users, so I wrote a UserScript to ...
15
votes
2answers
492 views
Stack Exchange Chat Caret Pathfinder
In The Nineteenth Byte, we have an excessive amount of carets (carrots, if you will) that direct one's attention to another message. For example:
Amidst the confusion, I made a userscript that ...
19
votes
3answers
530 views
Stack Exchange User Activity Score
About
This is a SEDE query which will calculate your activity and participation on a site. It's geared for Programming Puzzles & Code Golf where questions are values more, but the values can be ...
21
votes
3answers
636 views
Calculate questions per day on CodeGolf.SE
I wrote a short script in Python 3 that connects to the Stack Exchange API, gets all questions on Programming Puzzles & Code Golf over the past two weeks, and determines the average number of ...
6
votes
1answer
65 views
Stack Exchange API Python library
I wrote a package a few years ago to make my interactions with the Stack Exchange API more straightforward. I've maintained it over the years and used it in several scripts I've written that interact ...
52
votes
6answers
5k views
You hate h̶a̶t̶s̶ reputation? Click here to get rid of it
Soo... I recently read a meta-post about the inherent problems of reputation. It listed some things like:
Confirmation bias.
Demotivating for low-rep users.
Hubris and elitism of high-rep users over ...
3
votes
2answers
55 views
What are the top voted comments on closed questions, and who made the comments?
Following this linked question and the feedback it generated, I put together a new query which utilizes a JOIN.
...
3
votes
1answer
61 views
What percentage of down votes are users responsible for?
I put together this simple query to calculate the percentage of downvotes each user is responsible for and displaying them in order of downvote percentage. It's generating the desired results, but I ...
7
votes
1answer
31 views
SEDE Query to Find… Weird Question/Protect Combinations
I was interested in finding some of the weirdest question/protection combinations, basically out of curiosity.
I heuristically defined this as:
Low view counts
Not a moderator/SE employee
From ...
4
votes
2answers
61 views
Top Python badged users from NYC
I forked this StackExchange Data Explorer (SEDE) query from another one, and made it a bit more complex. I'm looking for feedback on my style, as well as answers to other questions (see below).
...
2
votes
0answers
33 views
UserScript that tracks Views Since Last Visit
I try keep an eye on any questions or answers that I have posted here within the StackExchange network and I like to prioritize my updates and improvements based on ones that get frequent visits.
I ...
9
votes
2answers
63 views
Badge Oneboxer for Chat.SE
This script makes it possible for badges to onebox in Chat.
The install requires Tamper/GreaseMonkey. Click here to install,
and it's on GitHub and StackApps!
...
10
votes
1answer
95 views
Chat.SE in Terminal
This is a script that accesses the SE impromptu APIs to receive the fkey, a variable need for connection to chatrooms, and uses it to build a websockets connection ...
4
votes
2answers
80 views
UserScript that summarizes Stack Exchange flag counts
I am working on a UserScript that displays total flag counts and other information on the Flag Summary page.
Example:
Everything is working correctly but this bit of code seems rather repetitive ...
6
votes
2answers
55 views
Stack Exchange userscript for showing spoilers on questions with particular tags
Stack Exchange sites support hiding text as a spoiler with >!; for example:
This gets a lot of use on the Sci-Fi & Fantasy stack, usually to cover up ...
6
votes
1answer
39 views
Helper functions to extract SEDE query results into more user-friendly format
This Python module contains helper functions to download the result page of SEDE queries and extract columns from it, most prominently:
...
12
votes
2answers
258 views
BigBrother - A chat room watcher
Originally, this script stemmed from a small script that watched stars and who made them, but a few days after launching, SE patched it so the people behind the stars aren't sent.
Regardless, ...
18
votes
2answers
162 views
Stack Exchange Post Reminder
I've created a UserScript for adding follow-up reminders to any post (question or answer) here on the Stack Exchange network. I did this in response to a stackoverflow meta post feature request which ...
9
votes
2answers
69 views
Hot Post-ato Guessing Game
On almost every page in the Stack Exchange Network, there lives a list of some the current "hot" questions across the network (sometimes abbreviated HNQs). Some of these posts have very exotic titles (...
19
votes
1answer
62 views
Cross-posts from Stack Overflow to CR
What this code does it explained in detail in the top portion of the query.
I have left out part of the list of language tags as I felt it was just noise. You can see the full collection here.
You ...
19
votes
2answers
150 views
Simon, Mat's Mug, what's the (rating) difference?
This is a part of the code for the almighty bot @Duga (That's me!).
Every evening, 15 minutes before "RELOAD" (00:00 UTC), I post the reputation differences for some Code Review users.
Example ...
10
votes
1answer
68 views
Vote Count Viewer
I've written a small script to enable the vote count viewing functionality that comes for users at 1k reputation:
...
6
votes
1answer
36 views
Scraping SEDE query results with caching
I use this script to scrape the results of a SEDE page and return as a BeautifulSoup object.
A small twist is that if I don't use a SEDE query manually in the browser for a few days, then non-...
6
votes
2answers
42 views
Scraping columns from SEDE results
I use the following script to download the result of a SEDE query and scrape a specific column from it using BeautifulSoup:
...
12
votes
2answers
69 views
Stack Exchange moderation-action auto-comments
I've written a userscript that pops up a dialog before you take a moderation action (closing, deleting) with some pro-forma comments, so that you can add one of those before you cast your vote.
I'm ...
10
votes
1answer
90 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 not ...
17
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 ...
7
votes
2answers
180 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 e-...
6
votes
1answer
63 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
88 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 ...
8
votes
1answer
57 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 ...
32
votes
1answer
404 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 ...
18
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
88 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...
http://chat.stackoverflow....
4
votes
0answers
56 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 ...
15
votes
3answers
167 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
164 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 ...
28
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
1answer
33 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 ...
21
votes
2answers
410 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
60 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
389 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 ...
