ahsteele / ahsteele-ysod Goto Github PK

Quick Guide to Data Explorer: 

- Getting Started

Pre-reqs: 

- For Javascript hacking only: A web browser

- For back end changes:
- Visual Studio 2010
- SQL Server Express or above


The File layout

- If you would like to hack on the grid or the SQL editor (change syntax highlighting, experiment with new javascript features) checkout the Static directory. 
   The Static directory contains a single page with the grid and editor. It refrences the main js and css files in the project. 


- The Lib directory contains all the 3rd party libraries we use
- The Tools directory contains exes that help in the build process 
- The App directory contains the actual SEDE app
- The Data directory contains a blank schema for a "Stack" site and the schema for data explorer.


Configuring the databases:

- Either: deploy the DataExplorer database project OR run the Data/dataexplorer.sql 
- Import data into the StackOverflow database (and any other databases you wish to query) alternatively if a DB exists you can simple run queries that do not depend on data like "SELECT 1"  


- Contributing Patches

1. Install a mercurial client such as tortoiseHG: http://tortoisehg.bitbucket.org/
2. Create a clone of the current trunk in google code on this page: https://code.google.com/p/stack-exchange-data-explorer/source/checkout
3. Check out your clone
4. Commit your changes to the clone 
5. Open up a question on meta.stackoverflow.com asking for your change to be merged, tag it data-explorer


Full list of all third party software used to build Data Explorer:

- ASP.NET MVC Version 2: http://www.microsoft.com/downloads/details.aspx?FamilyID=c9ba1fe1-3ba8-439a-9e21-def90a8615a9&displaylang=en
- Code Mirror: http://marijn.haverbeke.nl/codemirror/
- jQuery 1.4.2: http://jquery.com/
- jQuery validation: http://bassistance.de/jquery-plugins/jquery-plugin-validation/
- JSon.Net: http://james.newtonking.com/projects/json-net.aspx
- DotNetOpenAuth: http://james.newtonking.com/projects/json-net.aspx
- YUI Compressor: http://developer.yahoo.com/yui/compressor/
- Slick Grid: http://github.com/mleibman/SlickGrid