Stack Exchange Data Explorer
C# JavaScript HTML CSS XSLT PowerShell Other
Latest commit 069bf5e Jun 9, 2016 @NickCraver NickCraver Merge pull request #77 from tms/tutorial
Add SEDE SQL tutorial

README.md

Data Explorer

The Stack Exchange Data Explorer is a tool for executing arbitrary SQL queries against data from the various question and answer sites in the Stack Exchange network.

Quick Guide

Prerequisites

Layout

  • The App directory contains the Data Explorer solution
  • The Migrations directory contains the database evolution scripts and a batch file for running them
  • The Tools directory contains some precompiled utilities for working with Data Explorer
  • The Lib directory contains some 3rd party binaries used in the application
  • The SeedData directory contains seed files to populate the Data Explorer schema with some sample data

Configuration

The database can be brought up to date by running the migrate.local.bat file in the Migrations directory. This assumes an existing SQL Server database named DataExplorer with integrated security enabled. If your environment is configured differently, you will need to modify the connection string in your batch file and web.config file to reflect your setup.

Once done, you'll need to populate the Sites table with a record for each site you intend to query against. You can run the sites.sql file in the SeedData directory to prepopulate the table with a small list of popular Stack Exchange sites. To actually run queries, you will need to create additional databases that reflect the connection values in the Sites table; these can optionally be populated with data from the Stack Exchange data dumps using a custom import process or one of the data dump import tools available on Stack Apps.

Contributing

Development

  • Install git, or a git client of your choosing (such as TortoiseGit, SourceTree, or GitHub for Windows)
  • Fork this repository on GitHub
  • Commit changes to your fork, preferably in easy-to-merge branches
  • Submit a pull request on GitHub with a description of your changes

Providing Feedback

Miscellaneous

Third Party Components

For more information, see "Which tools and technologies are used to build Data Explorer?"