3

I'm following this guide: How to Query the StackExchange Databases, but when trying to connect with SQL Server 2014 it doesn't let me connect to the db.

Does SODDI work for the data of January 2015?

Is there any other way to get the schema of Stack Overflow with or without the data?

8
  • If you are only looking for the schema you can check this for the schema or my answer here for a graphical representation. I'm not sure if support question with regard to soddi aren't better raised at the github project.
    – rene
    Commented Apr 19, 2015 at 9:56
  • You can leave a comment on the blog post and use the blog's contact page - anyhow since Brent works for SE as well, this might fit here as well and he might answer this. Commented Apr 19, 2015 at 10:17
  • @rene Really Thanks, other question that i have is, how does SE manage all the sites?, i mean each community has it's own database, but, is there a mother db? where the account is related? because the table Users has a FK "AccountId" so, are we able to see that db? Commented Apr 20, 2015 at 4:04
  • @ShadowWizard I post a comment there, thanks Commented Apr 20, 2015 at 4:05
  • Cheers, keep us updated here. :) Commented Apr 20, 2015 at 6:37
  • @Nonexistent yes, there is a mother db but that one is NOT pushed to SEDE. SEDE has one extra database Data.StackExchange that holds the accounts for SEDE (they are separated from SE accounts), the sites and the queries created by users. Us mortals don't have access to that. AccountId is a stable key across databases. I used that fact in this answer of mine
    – rene
    Commented Apr 20, 2015 at 7:51
  • @rene So that we don't have access to "Data.StackExchange" ?, what you mean by stable key? it is managed on the app side? Commented Apr 22, 2015 at 0:10
  • 1
    The accountid is the unique id for any user across all sites. So on each site you have a unique userid but that can and will change per site. The accountid is the key that should be used if you want to link the same user across sites. That is why I say that accountid is stable opposed to userid which will change per site while it is the same user. But there is no table for us available that holds extra data belonging to an accountid
    – rene
    Commented Apr 22, 2015 at 7:25

0

You must log in to answer this question.

Browse other questions tagged .