Which technologies you are using for building Data Explorer? This is interesting if it gets open sourced at some point in future. Do you use same stuff as with SO? C#, ASP.NET, MVC?
2 Answers
Data Explorer
Like the rest of the Stack Exchange network, Data Explorer uses a WISC stack:
- Operating System Microsoft Windows Server 2012 x64
- Web Server IIS 8.0
- Database SQL Server 2016 running on Microsoft Windows Server 2012 R1 x64
- Language C#
Data is populated into Data Explorer using an automated import script that converts and sanitizes data from the internal Stack Exchange databases, producing an output that is similar to the data dumps.
Software Development Tools
- IDE Visual Studio 2010
- Framework Microsoft ASP.NET (version 4.0) on .NET 4.5
- Web Framework ASP.NET MVC 5.2 with MiniProfiler
- View Engine Razor
- Browser Framework jQuery 1.7.1
- Data Access Layer Dapper and Entity Framework (only for OData access)
- Source Control Git, on GitHub
External Bits
- CodeMirror 2
- SlickGrid
- Flot 0.7
- Stripped down version of Elmah
- Json.NET
- DotNetOpenAuth
- reCAPTCHA
-
do you update the db as and when database dump is released ? Or do you have, er, "some other arrangement" ;p Commented Jun 2, 2010 at 0:51
-
no arrangement yet, but I will make sure that the latest data is up in very short order after the release– wafflesCommented Jun 2, 2010 at 1:28
-
@Sathya: refer to this question -> meta.stackexchange.com/questions/59480/… Commented Sep 7, 2010 at 4:49
-
@Tim nice update! Where did you get all the information from? :) Commented Dec 22, 2013 at 17:42
-
@ShadowWizard Well, I know most of it, but otherwise I just copied from the network post under the assumption that it's the same. Commented Dec 22, 2013 at 17:43
-
@Brent aren't you consulting for Stack Exchange? If so, I think you should ask for a diamond here on Meta so you can edit anything at will. :) Commented Jan 18, 2014 at 21:10
-
@ShadowWizard well, I've got database access, so technically I can edit anything at will anyway. I try to be good and use the UI though. ;-) Commented Jan 19, 2014 at 13:51
-
@BrentOzar cheers, so now we know who to blame when there are unexplained reputation changes! :P Commented Jan 19, 2014 at 13:55
-
2
While not strictly part of Data Explorer, it is possible to query Stack Overflow data as part of BigQuery's public datasets.
-
Also, it seems that the data available through BigQuery Public datasets program is updated from the internet archive dumps, on a quarterly fashion. As of december 2022, the latest data available via BQ is from September 2022 Commented Dec 17, 2022 at 22:24