Skip to main content

Workshop: Stack Overflow Insight

Stack Overflow helps people find the answers they need, when they need them. We're best known for our public Q&A platform that over 100 million people visit every month to ask questions, learn, and share technical knowledge.

Step 1: Find Data Source

Historical Stack Overflow Data

Stack Exchange Data Dump: https://archive.org/details/stackexchange

Realtime Stack Overflow Data

Stack Overflow /events API Docs: https://api.stackexchange.com/docs/events

The API considers the following "events":

  • posting a question
  • posting an answer
  • posting a comment
  • editing a post
  • creating a user

Step 2: Load Data to TiDB

Not ready, you can try it.

Step 3: Get Insights with SQL

Not ready, you can try it.