4

If you don't know where to look, it's a bit hard to find the database schema for the Stack Exchange Data Explorer (both new and old). As far as I can tell, the Stack Exchange Data Explorer only provides one clue—in the "About" page—as to the whereabouts of the data schema.

The Stack Exchange trilogy data dumps are hosted at ClearBits!. You can subscribe via RSS and be notified every time a new dump is available. Have fun remixing and reusing; all we ask is for proper attribution.

However, I would argue that this answer on Meta Stack Overflow provides the most accessible overview of the database schema. Can someone add this to the Data Explorer FAQ or show at least show me where it is prominently displayed on a Data Explorer page?

Improve this question

1 Answer 1

Reset to default
3

As far as I can tell, the Stack Exchange Data Explorer only provides one clue—in the "About" page—as to the whereabouts of the data schema

Well, the schema is also shown under the Compose Query section as long as you don't block scripts from microsoft.com.

schema-hidden

schema-shown

Improve this answer
4
  • D'oh! You're absolutely right. I had a script-blocker enabled, and that prevented the Microsoft-provided schema from being displayed.
    – Chris Frederick
    Commented Sep 12, 2011 at 7:00
  • @Chris :) thanks for updating my answer as well. Also, Microsoft provided schema? :-s
    – Sathyajith Bhat
    Commented Sep 12, 2011 at 10:18
  • Er, what I meant to say was that the schema was shown by a script from microsoft.com and thus "Microsoft-provided".
    – Chris Frederick
    Commented Sep 12, 2011 at 16:15
  • @Chris ah okay!
    – Sathyajith Bhat
    Commented Sep 12, 2011 at 16:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .