ThreadCastAI – Community listening and reply management tool for Stack Exchange

2026-04-10T09:35:00Z

About

ThreadCastAI is a community monitoring and reply management tool that helps businesses and developers discover Stack Exchange questions relevant to their product, service, or area of expertise.

It monitors Stack Exchange for threads matching user-defined keywords and tags, surfaces high-intent questions in a review queue, and lets users draft, edit, and approve replies — before anything is posted.

Live app: https://threadcast.pixalab.ai
Contact: dev@pixelnx.com
Developer: PixaLab (https://pixalab.ai)

What it does

Monitors Stack Exchange for questions matching user-configured keywords
Scores each thread by relevance and surfaces them in a review queue
Lets users write or edit a reply inside the app
Posts the reply only after the user explicitly approves it
Tracks clicks and engagement per reply using UTM parameters

Nothing is posted automatically. Every reply goes through a human review and approval step before submission.

How it uses the Stack Exchange API

Search — uses /search/advanced and /questions to find relevant threads based on user-defined keywords and tags
OAuth 2.0 (explicit flow) — users authenticate their own Stack Exchange account; the app only acts using a user-granted access token
Posting — replies are submitted via /answers/add using the authenticated user's personal token, only after the user approves the reply in the queue
Rate limiting — all requests use the registered API key; backoff values in API responses are fully respected; quota is never intentionally exhausted
No scraping — only official Stack Exchange API endpoints are used

Authentication Flow

User clicks "Connect Stack Exchange" inside the app
App redirects to Stack Exchange OAuth 2.0 explicit grant flow
User reviews and approves permissions on Stack Exchange
App receives the access token, stores it encrypted, scoped to that user only
All subsequent API calls for that user use their personal token

Platform Details

Type: Web application (SaaS)
Client ID: 37941
OAuth redirect URI: https://threadcastapi.pixalab.ai/api/v1/auth/platforms/stackexchange/callback

License

What are the protocol constraints and hard rules for working with the AI from the API

2026-04-09T22:38:08Z

I am thinking that I can use the API with the newly minted AI to play an adversarial role with solutions I propose with ongoing projects. Before I implement anything can anyone illuminate the hidden or subtle rules of engagement?

Tracklister Community Bot - Electronic Music Q&

2026-04-05T17:29:24Z

About

Tracklister Community Bot monitors Music Fans Stack Exchange for questions about electronic music genres, artists, releases, and track identification. It posts answers enriched with data from the Tracklister electronic music database.

How it works

Polls the SE API for new questions tagged electronic-music, similar-artists, identify-this-song, identify-this-genre
Drafts answers using release, artist, and genre data from the Tracklister database
All answers are human-reviewed before posting

PLACEHOLDER: Interaction between user on LLM and Online Knowledge Community

2026-03-30T11:35:23Z

About: This application is a research project exploring more effective ways to discover and interact with knowledge on Stack Overflow. It provides a unified interface for searching for content and allows authenticated users to perform actions such as upvoting or commenting directly via the API. This app is intended for research and non-commercial use.

Features:

OAuth 2.0 login using Stack Exchange View questions and answers from Stack Overflow Upvote answers and questions (requires user authorization) Post questions and answers which is written by user Google OAuth 2.0 support for app login (optional) How it works:

User will chat with LLM as they do as usual, then the tool will suggest corresponding helpful posts and suggest possible action to the user It will not spam the community; every action will need the user to review and confirm. Posting an answer/question or reply is simulated, will not really post on the community.

StackOverflow Agent Swarm — Automated answer bot

2026-03-29T21:48:58Z

StackOverflow Agent Swarm

A multi-agent automated system that discovers unanswered Stack Overflow
questions and posts high-quality answers using Claude AI.

Type: Script / Bot
Author: harshit-anand License: Personal use OAuth App ID: 37695

Professionalize Media AI – Support automation for Aspose / GroupDocs / Conholdate

2026-03-29T20:15:28Z

This is an application registered for Stack Exchange API usage.

Professionalize Media AI is an internal support-assistance tool.

It monitors Stack Overflow for public mentions of Aspose, GroupDocs, and Conholdate products, drafts technical responses, and allows approved publishing through authenticated workflows.

Primary use:

detect relevant developer questions
draft helpful support replies
publish approved answers/comments through the Stack Exchange API

Status: internal / testing

Contact: marko.pilekic@aspose.com

DeepDNA.ai — Stack Exchange Q&A assistant for genomics topics

2026-03-28T19:49:38Z

About

DeepDNA.ai is a personal tool that finds unanswered questions about genomics, pharmacogenomics, and DNA analysis on Stack Exchange and helps draft answers.

Platform

CLI / Node.js

OAuth

Client ID: 37685
OAuth Domain: stackexchange.com

Contact

hello@deepdna.ai

License

Private / Personal use

PLACEHOLDER - SC NP SC Integration

2026-03-24T05:30:00Z

This is a private integration tool I am building to interact with the Stack Exchange community via the API. I will be using this to get questions which I only have interest in and not a whole lot of questions which do not make sense to me.

ThaSha — MuleSoft DataWeave Content

2026-03-24T02:19:38Z

ThaSha

ThaSha is a content publishing pipeline for MuleSoft DataWeave patterns from the mulesoft-cookbook repository.

GitHub: https://github.com/shakarbisetty/mulesoft-cookbook

Type: Script

License: MIT

Version: 1.0

This app publishes DataWeave pattern content to Stack Overflow as Q&A pairs covering common integration traps and fixes.

Cloudflare Support Agent — AI-assisted answers for Cloudflare-tagged questions

2026-03-13T00:59:39Z

AI-powered support agent that monitors Cloudflare-tagged questions and generates draft answers using RAG over official Cloudflare documentation.

FlywheelBot - Automated API content poster

2026-03-09T03:16:15Z

FlywheelBot

A personal automation script that posts API documentation and answers to Stack Overflow.

Type: Script (personal use only)

Author: donny.nguyen.business@gmail.com

Status: Development

Raw comment Markdown

2026-03-02T20:46:26Z

Adds a discreet “MD” toggle next to every comment that allows you to view the comment’s raw Markdown code.

// ==UserScript==
// @name     Stack Exchange: raw comment Markdown
// @grant    none
// @run-at   document-start
// @match    https://*.stackexchange.com/*
// @match    https://*.superuser.com/*
// @match    https://*.stackoverflow.com/*
// @match    https://*.mathoverflow.net/*
// @match    https://*.serverfault.com/*
// @match    https://*.askubuntu.com/*
// @match    https://stackapps.com/*
// @exclude  https://api.stackexchange.com/*
// @exclude  https://data.stackexchange.com/*
// @exclude  https://openid.stackexchange.com/*
// @exclude  https://contests.stackoverflow.com/*
// @exclude  /^https?:\/\/winterbash\d{4,}\.stackexchange\.com\//
// ==/UserScript==

/*jshint curly:false*/

const html = (() => {
  const html = function (pieces, ...values) {
    if (new.target !== void 0)
      return Reflect.construct(String, [pieces], new.target);
    return new html(String.raw({ raw: pieces }, ...values.map(
      s => s instanceof html ? s : `${s}`.replaceAll(
        /[<>&"']/gu, c => `&#${c.charCodeAt(0)};`))));
  };
  html.prototype = Object.create(String.prototype);
  return html;
})();

const processNode = node => {
  if (!node?.matches('.js-comment'))
    return;
  if (node.querySelector('.--rmd-button'))
    return;
  const child = node.querySelector('.comment-date');
  if (!child)
    return;
  child.insertAdjacentHTML(
    'afterend',
    `<button type="button" class="--rmd-button s-btn s-btn__link">md</button>`
  );
};

const processUnder = node => {
  processNode(node);
  for (const subnode of node.querySelectorAll('.js-comment'))
    processNode(subnode);
};

if (document.body)
  processUnder(document.body);

new MutationObserver(mutations => {
  for (const mut of mutations) {
    switch (mut.type) {
      case 'childList':
        processUnder(mut.target);
        break;
    }
  }
}).observe(document, {
  childList: true,
  subtree: true,
});

document.addEventListener('click', (ev) => {
  if (!ev.target.matches('.--rmd-button'))
    return;
  const commentNode = ev.target.closest('.js-comment');
  const { commentId } = commentNode.dataset;

  const oldNode = commentNode.querySelector('pre.--rmd-markup');
  if (oldNode) {
    oldNode.remove();
    return;
  }

  (async () => {
    const response = await fetch(
      `https://api.stackexchange.com/2.3/comments/${commentId}?${
      new URLSearchParams({
        'site': location.host,
        'filter': 'do(JZxI-6d1J5m2-r',
      })}`);
    const responseJson = await response.json();

    commentNode.querySelector(':scope > .comment-text').insertAdjacentHTML(
      'beforeend', html`
        <pre class="--rmd-markup">${
          responseJson.items[0].body_markdown
        }</pre>
      `);
  })().catch(e => {
    alert(`[SE:rcM] ${e}`);
  });
});

const contentLoaded = new Promise((ok, ko) => {
  switch (document.readyState) {
    case 'complete':
    case 'interactive':
      ok();
      return;
    case 'loading':
      break;
    default:
      ko(new TypeError(`readyState=${document.readyState}`));
  }

  document.addEventListener('DOMContentLoaded', () => ok(), { once: true });
});

(async () => {
  await contentLoaded;

  document.head.insertAdjacentHTML('beforeend', `
    <style>
      .s-btn.s-btn__link.--rmd-button {
        font-variant: small-caps;
      }

      pre.--rmd-markup {
        white-space: wrap;
      }
    </style>
  `);
})();

wm - StackOverflow question finder

2026-02-21T17:25:20Z

wm is a bot that finds unanswered Stack Overflow questions that I will find interesting and want to answer! It looks for questions on a few different metrics and then shows me the questions. I write an answer and ask it to post it.

All answers are written by me (a human - funny that we have to say that these days)
Uses Stack Exchange API v2.3
OAuth with write_access scope
Client ID: 36745

stack-exchange-notify-send.js - Live desktop notifications

2026-02-05T04:03:52Z

About:

stack-exchange-notify-send.js is a extremely minimalist 2026 desktop notifier for Stack Exchange inbox/reputation. It's browserless, dependencyless, and permissionless. It's for people who need to have a code editor not Stack Exchange open, but still want to respond promptly to comments.

The motivation was that 4 other desktop notifiers broke. It's difficult to install them because their GUI libraries require 2010s versions of GTK/Qt/etc, so mine requires no GUI library at all. Their parsing might've broke and now they might do nothing, so I chose to not do anything beyond the bare minimum parsing required, and just display the raw JSON. This philosophy should help stack-exchange-notify-send.js survive better. The WebSocket API's undocumented, but it's faster than RSS or polling.

Screenshot:

Install:

Just copypaste the code below into a stack-exchange-notify-send.js file. Add your https://stackexchange.com userid. Ensure Node.js is installed. Linux/macOS users, mark it as executable. Windows/macOS users, run npm init then npm install node-notifier. If desired, use KDE Linux system settings for autostart.

Linux users can double-click to run, and Windows/all users can execute it with node stack-exchange-notify-send.js

#!/usr/bin/env node
// Go to https://stackexchange.com/ , click on your profile picture,
// then copy the number in the URL here
const stackexchange_com_userid = "";

let notifier;
const title = "Stack Exchange notify-send";
console.log(title + ": https://stackapps.com/q/11981/121649");
if (process.platform === "linux") { // Dependencyless on Linux
    const { spawn } = require("child_process");
    // https://reddit.com/r/kde/comments/if5oeb/notifications_from_script_not_saving_to_history/g2lvzvj/
    const persist = ["-h", "string:desktop-entry:org.kde.konsole"];
    // libnotify-bin is default-installed on Ubuntu. Please install it if missing in other distros
    notifier = message => void spawn("notify-send", [...persist, title, message], { stdio: "inherit" });
} else {
    const { notify } = require("node-notifier");
    notifier = message => void notify({ title, message });
}

// Surprising no authentication's required.
const s = new WebSocket("wss://qa.sockets.stackexchange.com"); // https://meta.stackexchange.com/q/218343/1373352
s.onmessage = e => {
    data = JSON.parse(e.data)
    console.log(e.data);
    if (data.action === "hb") {
        s.send("pong");
        return;
    }
    notifier(e.data); // Crude but fault-tolerant
    // Omitted filtering out 1 -> 0 upon clicking in browser.
};
s.onopen = () => {
    console.log("Hello https://stackexchange.com/users/" + stackexchange_com_userid)
    // Listen to all of the current user's inbox/reputation notifications across all sites
    // Chat's not targeted by this app except perhaps if a ping enters the inbox
    s.send(stackexchange_com_userid + "-topbar");
    console.log("Connected. Now waiting for inbox messages or reputation changes...");
};

Platform:

Linux, macOS, and Windows

Contact:

I created this app. You can contact me on Stack Exchange Chat.

License:

SPDX-License-Identifier: CC-BY-SA-4.0 OR MIT OR Apache-2.0

Code:

The Node.js programming language was used to write this. No frameworks or tools are required. You can contribute by submitting an answer or suggested edit. The source code is in the "Install:" section above.

PLACEHOLDER - Antigravity Publisher - Personal Tool

2026-01-26T09:00:22Z

Screenshot / Code Snippet

[None]

About

A minimal VS Code extension to publish questions to Stack Overflow. Personal use only.

License

MIT

Download

Private / In development

Platform

VS Code / Antigravity

Code

Local

Navigate through Challenges

2025-09-22T06:19:08Z

About

Stack Overflow's Challenges can quickly become overwhelming when trying to track which posts you've already read or navigate back to someone's post. There are no pagination and posts are usually quite long, making scrolling at the very best tedious (if you're lucky enough to not scroll past what you need). This userscript provides a relatively clean navigation experience by adding view management and organization tools.

The script adds four main features:

Navigation menu: A simple dropdown menu showing all posts with author names, dates, and preview text, ordered based on the order that they appear on the page with a blue indicator (if you have moderation privileges, you'll see the deleted posts at the bottom with a red indicator).
Individual post management: Each posts gets a "Viewed:" checkbox that you can check when finished reading. Checked posts automatically collapse to show just a compact banner with author name and date information. You can hit "Show" to view the content and collapse it again by hitting "Hide". Viewed posts get a green indicator in the dropdown menu.
Global toggle: An "Expand/Collapse All Viewed" button that lets you quickly show/hide all posts that you've marked as viewed.
Collapsed deleted posts for moderators. All the deleted posts are collapsed by default. You can expand them individually as needed.

Your viewing preferences persist across page reloads, so you can return to a Challenge and immediately see which posts are new since your last visit.

Installation

Click to install with a script manager. N.B. I have only tested this with Tampermonkey on Firefox.

Repository

Here is the source code for this userscript; source code repo

Special thanks to VLAZ for their code review and suggestions.

Obtaining all tagIds given a list of tag names in API v3

2025-06-19T00:44:17Z

I am a Stack Overflow for Teams app developer, and given this recent announcement that API v3 is being extended to the public platform, I am hoping we can start asking API v3 questions here.

Given a list of tag names:

tag_names = [
    "tag1",
    "tag2",
    "tag3",
]

I need to get the list of corresponding tagId integer values.

The /tags route makes this a bit cumbersome because:

The tag name is always a partialName, thus requiring unwanted matches to be filtered.
Only one tag name can be specified per request, thus requiring multiple requests.

This could be simplified if:

A non-partial name parameter was supported.
The name and partialName parameters were enhanced to support an array of strings.

Has anyone else run into this challenge with API v3?

HeapExchange: Stack Q&A Client

2025-05-18T13:31:44Z

HeapExchange is an Android app designed to bring the power of Stack Exchanage to your fingertips.

Browse anonymously trending sites, questions by tag or topic
View answers, vote, and read discussions
Swiflty switch between sites
Get notified

Edit (15-02-2026)

App is now live on PlayStore: https://play.google.com/store/apps/details?id=com.heapexchange

App is currently in beta.

Copy code-blocks from Stack Exchange websites

2025-05-15T00:17:37Z

About

Highlighting and copying code from questions/answers is not as straightforward as one hopes it'd be. Throughout the years, there were (at least) a couple of userscripts/extensions to address this need. However, they are not maintained and the links are dead.

I have found this gist by kpym to be still functional, however it could've used a facelift.

This userscript (written off of the linked gist) adds a copy button to the top right corner of code blocks to copy the code from questions and answers.

Dark mode:

Light mode:

Installation

Click to install with a script manager. N.B. I have only tested this with Tampermonkey on Firefox.

Repository

Here is the source code for this userscript; source code repo

How to Resolve "Applications must have a registered Stack Apps post to write" Error when Requesting Write Access via OAuth?

2024-09-19T07:29:10Z

Question Description:

I am developing an application that integrates with Stack Overflow’s API, and I need to enable write access for it. I’ve successfully registered my application on the Stack Apps site, and I am trying to request OAuth write access with the following URL:

https://stackoverflow.com/oauth/dialog?client_id=26659&scope=write_access&redirect_uri=https://socialmedia.service.clouducaas.com/login_success

However, I keep receiving the error:

"Applications must have a registered Stack Apps post to write."

Here are the steps I've already followed:

I have registered my app on Stack Apps and obtained my client ID.
I used the correct client_id and redirect_uri.
I included the scope=write_access parameter in my OAuth request.

What could I be missing or doing wrong? How can I resolve this error and successfully enable write access for my application?

Any guidance on how to correctly register the Stack Apps post and link it to my app would be greatly appreciated!

Error calling Stack Overflow Teams API using Python requests library

2023-05-07T04:15:21Z

I'm trying to call a PUT/DELETE request using the Stack Overflow Teams API in Python, but I'm encountering errors. As an FYI, I have a working PAT that allows me to make get requests for articles and questions. Specifically, I'm trying to create an article, update an article, and delete an article using the API, but the PUT/DELETE requests don't seem to be working. When I try to run the code, I get an error message that says "no method found with this name" or {"error_id":400,"error_message":"title","error_name":"bad_parameter"}. The title might be the issue, but I don't think it goes against the requirements (string, 5 character+ length)

I have tried running the API calls using Python's requests module, and I have checked that my authentication token is correct. I have also tried adjusting the order of the payload and double-checking that the headers are correct. However, I'm still getting errors.

Here's my code (sanitized for privacy):

import json
import os
import requests
from markdown_it import MarkdownIt

def create_article(title, access_token):
    headers = {
        "X-API-Access-Token": access_token,
        "Content-Type": "application/json"
    }
    data = {
        "title": title,
        "body": "TEST",
        "tags": "REDACTED",
        "article_type": "knowledge-article",
        "filter": "default" 
    }
    json_data = json.dumps(data)
    api_url = "https://api.stackoverflowteams.com/2.3/articles/add?team=[TEAM_NAME]"
    response = requests.post(api_url, headers=headers, data=json_data)
    print(f"API response status: {response.status_code}")
    print(f"API response text: {response.text}")
    
    return response.json()


def delete_article(access_token, artId):
    headers = {
        "X-API-Access-Token": access_token,
        "Content-Type": "application/json"
    }
    data = {
        "id": artId
    }
    json_data = json.dumps(data)
    api_url = f"https://api.stackoverflowteams.com/2.3/articles/{artId}/delete?team=[TEAM_NAME]"
    response = requests.delete(api_url, headers=headers, data=json_data)
    print(f"API response status: {response.status_code}")
    print(f"API response text: {response.text}")
    
    return response.json()

def import_single_wiki_to_teams(input_directory, access_token, test_file):
    input_file = os.path.join(input_directory, test_file)

    if os.path.isfile(input_file):
        with open(input_file, "r", encoding="utf-8") as f:
            content = f.read()

        html_content = convert_md_to_html(content)
    #   title = os.path.splitext(test_file)[0]
        title = "TeArticle"
        print(f"Title from OS is: {title!r}")

        response = create_article('Test Article', access_token)  # Use the title and html_content variables
        print(response)
    else:
        print(f"File not found: {input_file}")


input_directory = PATH
access_token = [REDACTED]
test_file = "FILE_NAME"
import_single_wiki_to_teams(input_directory, access_token, test_file)

OpenAI detector

2022-12-23T20:21:25Z

Screenshot / Code Snippet

About

This script adds a link to each post on SE, revision on SE revision pages, and post Markdown views on metasmoke, to check it against Hugging Face's AI detector.

The first click will test the Markdown text using the Hugging Face detector API for the likelihood it was created by GPT and report that as a percentage likelihood that the post is fake.

Lots of users and spammers edit the text provided by ChatGPT a bit, so if you click the button a second time (or use Alt-Click) an iframe to the detector demo page will open with the Markdown text pre-filled for you, so you can try some manipulations to see if the content was edited from ChatGPT source text. For example, on metasmoke it looks like:

Download

The script can be installed via this link; source code can be found here.

Platform

Tested with Violentmonkey in Firefox on macOS, but it's likely to work on all browsers and platforms. (Please let me know if it doesn't!)

Contact

Post a comment or answer here, or create an issue/pull request on GitHub.

JSONDecodeError: Expecting value: line 3 column 1 (char 3)

2022-08-01T17:21:39Z

I am trying the following simple code to get JSON from the Stack Exchange API and it gives me the following error:

JSONDecodeError: Expecting value: line 3 column 1 (char 3)

Here is my script:

import requests
import json
url='https://api.stackexchange.com/docs/questions#order=desc&sort=activity&filter=default&site=stackoverflow&run=true'

r = requests.get(url)

r.json()

Stack Exchange One-Click Reviews

2021-03-22T06:21:52Z

About

The new UI for reviews introduced in early 2021 requires two clicks to submit reviews for an item: once to select the action, and a second time to submit the review. By contrast, the previous UI simply required a single click on an action button to submit a review.

Some users prefer the old behavior of simply having one click to submit a review. This script removes the requirement for a second click on the Submit button, and makes it so that clicking on a review action will immediately submit the review, restoring the former behavior of the old queue layout.

Notes

To discourage robo-reviewing, there is a slight delay baked into the script: if you click on a review action too early, it will simply select the button without submitting the review.

Download

Link to install the user script. You will need to have a user script manager extension installed in your browser, such as Tampermonkey or Violentmonkey.

Platform

Tested with Tampermonkey on Microsoft Edge (new Chromium-based version) on Windows. Haven't tested with other browsers or user script managers, but should work with other platforms too.

Code

Source code

Why has my daily quota increased from 10k to 2 billion?

2018-12-24T08:55:56Z

I'm using the Stack Exchange API with an access token and API key, and I was just checking my remaining quota. According to the documentation, this should be a number (somewhat) lower than 10,000, which is consistent what I've seen in the past.

However, to my surprise, today it's more like the 32-bit integer maximum:

This happens for multiple API routes, not just for /sites. I do get occasional backoffs, which I obey to. What's going on here? Santa Exchange giving out unlimited quota as Christmas presents? It does not matter which IP address I'm calling the API from.

TrueBadges, a combination of StackExchange badges and TrueAchievements

2013-12-29T02:51:07Z

Screenshot

TrueBadges

I've worked on this website since end of 2013 in my spare time. The initial goal was to have fun with lot of data.

The idea is to count StackExchange badges of an user in the same way as TrueAchievements does. This project has no practical use, you can view it as a fun website in order to have an overview of the efforts you put in StackExchange websites.

About

TrueAchievements (TA)

TrueAchievements is a website dedicated to Xbox and Windows games' achievements. Achievements are rewards given to players for realizing specific actions (complete a game, win 20 rounds in online game, etc.). Each achievement is associated with a score from 0 to 300 (or more). The idea behind TrueAchievements is that the score can be corrected by the percentage of players having unlocked an achievement compared to the numbers of players who own a game. For example, it's easier to get 5 points by starting the game GTA IV than meeting all the random characters. So the first achievement is worth 5 TA score and the second one is worth 13 TA score.

StackExchange Badges (SEB)

Badges are very similar to achievements, but they are only associated to bronze, silver or gold rank, they have no value in points.

TrueBadges

I want to use the same calculation in order to calculate a score based on the SEB earned by an user in all of the StackExchange websites. Note that this score is different from the reputation, even if the two scores are more or less correlated (eg. good answers give reputation and badges).

The value of each badge is calculated from the number of times a badge has been earned divided by the number of times the most earned badge has been earner. In other words, the rarest badges will be worth more points. The formula is still not perfect, I have to decide if I should cap score of each badge. Some badges are awarded only once, their value can be huge.

For each site, the website (TrueBadges) need to grab all the badges and the number of times they are awarded. Then the score of each badge can be calculated. Edit: the formula has been designed with the help of Mathematics (Stack Exchange).

Once a user register to TrueBadges (the only required data is the id of the user on StackExchange), the website has to make several requests:

Get the websites where the user logged in (StackOverflow, Arqade, etc.)
Get all the badges from the user on each site
Calculate the score for each badge of the user (a badge can be earned multiple times, so the value of a badge can be multiplied)
Calculate the score for each site
Calculate the total score of the user

Code

I use Symfony2 (a PHP framework) and Doctrine2 (an abstraction layer for MySQL).

Here is the current database schema:

Status

The website is online since beginning of 2014. Registration is opened and takes less than a minute.

Is there a difference between the API search and the search from within the site?

2012-10-15T17:17:28Z

I'm curious if the search results from the API is calculated the same way as the searches from within the sites themselves?

Is there a difference between the two? If so, what are the differences?

Stacklense - Ubuntu Unity Lens to search Stack Exchange sites

2012-07-12T00:21:20Z

Screenshot / Code Snippet

The application makes searches in question titles.

Please note that the lens will show only answered questions!

The names of the sites are usually one word, for example Ask Ubuntu becomes askubuntu, all names can be found at https://api.stackexchange.com/docs/sites#filter=default&run=true look for the "api_site_parameter":

Examples

search for python django at Stack Overflow site:
Type: python django ~~stackoverflow;
search for ppa at Ask Ubuntu site:
Type: ppa ~~askubuntu;
search for mac os x lion at Super User site:
Type: mac os x lion ~~superuser;

About

Stacklense is written with Python 2 (json, cStringIO, urllib2), using Stack Exchange API, Ubuntu Quickly workflow - platform; the code and the personal package archives are hosted at Launchpad. It is written for people who like to mess with computers - programming languages and all the stuff Stack Exchange and Ubuntu Linux freely provide, with hope that may be useful to someone or hopefully to many out there.

License

Stacklense is free (as in freedom) software distributed under GNU General Public License v3.

Download

You can find the ppa at https://launchpad.net/~iccode/+archive/staclense, instructions for installation at http://answers.launchpad.net/staclense/+faq/1998

Platform

Stacklense is written and tested on Ubuntu 12.04 LTS 64 bit, using the Unity Lenses feature;it will probably work on 32 bit architecture too (i386 build at ppa). There is a package for Ubuntu 12.10 available at Launchpad but not tested.

Contact

You can reach me using stef[at]iccode.net or at Launchpad. I am the only contributor since it is a small application but anyone can join if has ideas to implement - or wants to tweak the code.

Code

Python 2.X (default shipped with Ubuntu 12.04) using standard library modules only. Ubuntu Quickly, Stack Echange API, Launchpad (as mentioned above to get the code or to contribute (open for all [may need to contact me first, i am not sure if i need to add you first])

Made with

Ubuntu Quickly

Stack Exchange API

API Documentation and Help

2010-05-19T21:31:53Z

Method List

All API methods can be found at https://api.stackexchange.com/docs.

Global Method Parameters

All methods accept the following parameters:

type=jsontext: responds with mime-type text/json.
callback=functionname: returns JSON with Padding instead of standard JSON
filter={filter}: specifies which fields to return
Deprecated: key={key}: validates this request to a specific application. (More here)
- API keys should be passed as Authorization headers with a Bearer scheme, e.g. Authorization: Bearer {API_KEY}. (Read more about this change)

Site specific methods also take

site={sitename}: specifies the site to query against, can be the full domain name or just part
- for example stackoverflow.com, askubuntu, and gaming are all valid

Authentication

Updates to authentication options were released in June 2025 and are documented at https://stackapps.com/help/api-authentication

Supported Sites

Every site in the Stack Exchange network supports the API, with the exceptions of stackexchange.com, and Area 51.

Deprecated Help

Old help methods can be found at http://api.stackoverflow.com/1.1/usage. Further details may be found in the revision history of this post.

Fast Multi Platform Data Dump Import for SQL Server (2000/2005/2008), SQLite and MySQL

2010-04-02T23:38:52Z

UPDATE:

Both soapi.info and skysanders.net have been offline for a while.

The application readme file and hosting will be moved to http://soapi.info/tools/soddi.aspx.

Links are in the readme text below.

Stack Overflow Data Dump Import v.11
  ClickOnce Installer: http://skysanders.net/tools/se/soddi/publish.htm

  (c) 2010 Sky Sanders
  licensed under MIT/GPL - see license.txt

  msi :http://skysanders.net/files/soddi.11.msi
  info:http://skysanders.net/tools/se
  bin :http://skysanders.net/files/soddi.11.zip
  src :http://bitbucket.org/bitpusher/soddi/

SODDI is a .NET 3.5 SP1 executable written in C# that quickly and cleanly imports Stack Overflow 
Data Dump XML files into [SQL Server][3] 2000/05/08, [MySQL][4] 5.1 and [SQLite][5] 3 
(MySQL and SQLite drivers are included).

SODDI can be run as a command line utility or, when invoked with no arguments or GUI argument, 
will present a [Windows Forms][6] interface.

Quick Start:
The quickest route to your own copy of the Stack Overflow databases is to use the ClickOnce installer,
browse to the uncompressed data dump, accept the default SQLite provider selection and click 'Import'.

USAGE:

soddi.exe source:"" target:"" [batch:5000] [split] [indices] [fulltext] [[meta] [so] [su] [sf]] [gui]


SOURCE          The directory containing the individual site directories.
                NOTE: do not include trailing slash in quoted path as the arg
                parser will interpret it as an escaped quote and puke.

TARGET          A valid ADO.NET connection string, including the provider invariant
                name.

                Platform specific connection string details:

                SQL Server: the database must exist. Data will be loaded into tables segregated by
                schema named as the site data being imported. e.g. so.Users, meta.Users.
                The tables are dropped before import.

                MySQL: The connection string should include server, each site's data will be loaded
                into a database named as the site imported. The databases will be dropped and 
                recreated before import.

                SQLite: The connection string should specify a directory. The data will be imported
                into separate .db3 files, each named as the site imported. Existing data files
                will be overwritten.

                The target database/datafile/schema names can be modified by explicitly specifying
                sites to import and appending the desired schema as a parameter value or editing
                the Sites list item schema in the GUI.


-- OPTIONAL ARGUMENTS

SPLIT           Normalize post tags by splitting the concatenated Posts.Tags field into individual 
                rows in a separate PostTags table.

INDICES         Enables useful indexes on each table.

FULLTEXT        Enables a full text index on Posts.Body and Posts.Title - SQL Server only.

BATCH           Number of rows inserted in each transaction. Default 5000.

GUI             Presents a Windows Forms interface. If SODDI is invoked with arguments and GUI, the
                UI will be populated with the supplied arguments.

                The console window will remain open to receive all debug and error output.

META|SO|SU|SF   Specifies which sites to import. If none are specified, all site directories found
                in SOURCE will be imported.

                To specify a different target name simply treat the site name as a parameter.

                e.g. 

                SQL Server - SO:StackOverflowData will load the data from the XXXXX SO directory 
                into the database specified in the connection string and the schema 'StackOverflowData'

                MySQL - SO:StackOverflowData will load the data from the XXXXX SO directory 
                into a new database named StackOverflowData on the server specified in the connection
                string.

                SQLite - SO:StackOverflowData will load the data from the XXXXX SO directory into a 
                new db3 file named StackOverflowData.db3 in the directory specified in the connection
                string.

                In GUI mode you may edit the schema item in the Sites list.

Options are not case sensitive.

Example command lines.

GUI Mode:
    soddi 

SQLite - all sites:
    soddi source:"F:\Export-030110" target:"data source=c:\temp;version=3;new=True;Provider=System.Data.SQLite"

MySQL - all sites:
    soddi source:"F:\Export-030110" target:"server=localhost;user id=root;password=p@ssW0rd;Provider=MySql.Data.MySqlClient"

MySQL - Meta StackOverflow and StackOverflow data into specified databases:
    soddi source:"F:\Export-030110" target:"server=localhost;user id=root;password=p@ssW0rd;Provider=MySql.Data.MySqlClient" meta:MetaDb so:SoDb

SQL Server - all sites:
    soddi source:"F:\Export-030110" target:"data source=(local);initial catalog=SOData;integrated security=true;Provider=System.Data.SqlClient"

SQL Server - Stack Overflow data only (SO):
    soddi source:"F:\Export-030110" target:"data source=(local);initial catalog=SOData;integrated security=true;Provider=System.Data.SqlClient" so

SQL Server - Stack Overflow data only into schema dbo:
    soddi source:"F:\Export-030110" target:"data source=(local);initial catalog=SOData;integrated security=true;Provider=System.Data.SqlClient" so:dbo


SQL Server - Stack Overflow data only, split tags and add indices:
    soddi source:"F:\Export-030110" target:"data source=(local);initial catalog=SOData;integrated security=true;Provider=System.Data.SqlClient" so split indices

The latest data dump can be found at
http://blog.stackoverflow.com/category/cc-wiki-dump/


04/01/2010 - Sky Sanders

04/09/2010 - Explicitly set platform to x86 to allow same binaries to run on x64.

Recent Questions - Stack Apps

ThreadCastAI – Community listening and reply management tool for Stack Exchange

About

What it does

How it uses the Stack Exchange API

Authentication Flow

Platform Details

License

What are the protocol constraints and hard rules for working with the AI from the API

Tracklister Community Bot - Electronic Music Q&

About

How it works

Links

PLACEHOLDER: Interaction between user on LLM and Online Knowledge Community

StackOverflow Agent Swarm — Automated answer bot

StackOverflow Agent Swarm

Professionalize Media AI – Support automation for Aspose / GroupDocs / Conholdate

DeepDNA.ai — Stack Exchange Q&A assistant for genomics topics

About

Platform

OAuth

Contact

License

PLACEHOLDER - SC NP SC Integration

ThaSha — MuleSoft DataWeave Content

ThaSha

Cloudflare Support Agent — AI-assisted answers for Cloudflare-tagged questions

FlywheelBot - Automated API content poster

FlywheelBot

Raw comment Markdown

wm - StackOverflow question finder

stack-exchange-notify-send.js - Live desktop notifications

About:

Screenshot:

Install:

Platform:

Contact:

License:

Code:

PLACEHOLDER - Antigravity Publisher - Personal Tool

Screenshot / Code Snippet

About

License

Download

Platform

Code

Navigate through Challenges

About

Installation

Repository

Obtaining all tagIds given a list of tag names in API v3

HeapExchange: Stack Q&A Client

Copy code-blocks from Stack Exchange websites

About

Installation

Repository

How to Resolve "Applications must have a registered Stack Apps post to write" Error when Requesting Write Access via OAuth?

Question Description:

Error calling Stack Overflow Teams API using Python requests library

OpenAI detector

Screenshot / Code Snippet

About

Download

Platform

Contact

JSONDecodeError: Expecting value: line 3 column 1 (char 3)

Stack Exchange One-Click Reviews

About

Notes

Download

Platform

Code

Why has my daily quota increased from 10k to 2 billion?

TrueBadges, a combination of StackExchange badges and TrueAchievements

Screenshot

About

TrueAchievements (TA)

StackExchange Badges (SEB)

TrueBadges

Code