Questions about Stack Exchange APIs, Stack Exchange Data Explorer, and any hacks to work with Stack Exchange sites
4
votes
1answer
102 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 ...
11
votes
2answers
199 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 ...
5
votes
4answers
95 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 ...
6
votes
2answers
66 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. ...
15
votes
2answers
172 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 ...
4
votes
1answer
40 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 ...
35
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:
...
6
votes
1answer
47 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 ...
5
votes
2answers
67 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 ...
12
votes
1answer
105 views
Follow-up to tool for posting Code Review questions
Description
This is a follow-up question to Tool for creating Code Review questions.
Things that has changed include:
Removed replacing four spaces with one tab, all tabs and all spaces in the ...
15
votes
2answers
172 views
Tool for creating Code Review questions
Description
I have realized that there's a whole bunch of code I want to have reviewed, but copying file by file, selecting the code and pressing Ctrl + K is a slow process, and I want to remember ...
13
votes
1answer
159 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 ...
8
votes
2answers
161 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, ...
11
votes
3answers
150 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, ...
8
votes
2answers
56 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:
...
8
votes
2answers
121 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 ...
0
votes
1answer
110 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 ...
