Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

For questions about the actual database used by the Stack Exchange sites.

6
votes
0answers
36 views

Total Up and Down votes in posts table

There is a limitation in showing the up and down votes seperately for posts: https://meta.stackexchange.com/a/1007/389297 The reason is that it requires looking up the votes table in the database, ...
3
votes
1answer
89 views

Does Stack Exchange use event sourcing?

This is a more technical question. I just found that I can browse the history of all my actions. Does Stack Exchange use event sourcing and store all my actions in the database? I wonder if CQRS is ...
2
votes
0answers
37 views

Add VisitedDays to database schema [duplicate]

I visited StackOverflow over (more than) 801 days and would like to know if I'm the most active one, after all others. So it should be possible to get the visited days of each user on the query?? Not ...
2
votes
0answers
117 views

How does Stack Exchange get their database statistics?

I was watching "The Architecture of StackOverflow" by Marco Cecconi (Stack Exchange developer), and came across this statistics/performance slide: How was the "Performance" table data ...
0
votes
0answers
59 views

Would SE communities Database perform better under MongoDB?

The EER Model of SE communities has lots of denormalisation rules, which is why I ask if the queries would perform better under MongoDB using the exact same model? What would be the things to ...
31
votes
1answer
605 views

Easy way to make local copy of entire SE database?

Recently, I have been using the Data Explorer to try to find fishy users on SO. However, the Data Explorer is limited when it comes to cross-site and time-consuming queries, so I want to create a ...
21
votes
1answer
151 views

Database inconsistencies after tag-merge operations involving non-ASCII characters

Originally non-ASCII tags weren't allowed, but French Language chose to use French-language tags despite the limitation. Most words are recognizable without diacritics anyway. Recently, non-ASCII ...
1
vote
0answers
35 views

Where and how does Stack Overflow store its data? [duplicate]

Where does Stack Overflow store its data - MySql, CouchDB? And how does the "related questions", shown at every page, work? Basically I want to know the ontology used here to store the data so that ...
0
votes
1answer
292 views

How can i generate SQL DEMO online temporarily base ?

I have some query in SQL data retrieving related so how can i display in stackoverflow, any one know me. please .
17
votes
2answers
320 views

StackExchange being switched over to non-production ready and unsupported version of SQLServer?

So, after StackStatus's announcement about tomorrow's database upgrade earlier, I looked up more information about SQL Server 2014 CTP2. This is what I found. The important parts of this page are as ...
2
votes
0answers
80 views

How does SO maintains tagging table [duplicate]

While checking SO data dump I have noticed that SO stores tags as an array inside Post table. And at the same time there is a mapping table with TagId and PostId. I assume this is used for tag ...
9
votes
3answers
170 views

Why is this question better suited for DBA than SO?

I've asked this question two days ago. The question deals with a simple subquery and when to use a DISTINCT operation. In my opinion, this is a thing a programmer that works with relational ...
4
votes
0answers
219 views

How are votes calculated on Stack Overflow

As far as I understand SO keeps votes in a separate table and calculates the post votes based on that data. So DB query can look like this assuming votes can be 1/-1. SELECT SUM(value) FROM votes ...
0
votes
1answer
108 views

Can we ask for reviews of data models or ER diagrams on Stack Overflow?

Is it OK to ask questions concerning the data model of a specific system on Stack Overflow?
2
votes
1answer
333 views

How to ask SQL questions with table definitions and example code?

I am always struggling when asking SQL questions. How are we supposed to ask questions related to SQL including table definitions and code examples? Is there a jsfiddle.net equivalent for sql that ...
0
votes
1answer
143 views

Where I can ask for recomendation on books on databases? [duplicate]

Normally I would ask on Stack Overflow, but after reading the rules I am positive that it is not the right place. I am not even sure if this is the right place to ask this "meta" question?
1
vote
1answer
207 views

How can I query the Stack Overflow database?

Some time ago I saw someone had queried their country's users of Stack Overflow in a sub-site of Stack Exchange (if I'm not wrong). I want to know how I can query Stack Overflow's database.
14
votes
1answer
6k views

Stack Overflow database model

I'm currently involved in a project to design and implement an in-house question-and-answer community for our university. We've explored some open source frameworks such as OSQA, but we are also ...
19
votes
2answers
5k views

Stack Overflow DB performance and redis cache

I am trying to understand some of the data storage and caching details of Stack Overflow. Are the pages build completely from redis cached data or does it need to make some db calls? Assuming that ...
7
votes
3answers
4k views

Which database does Stack Overflow use behind-the-scenes? [duplicate]

Possible Duplicate: Which tools and technologies are used to build the Stack Exchange Network? Stack Overflow is developed using ASP.NET and C#. I found this fact in various answers here. So, I ...
5
votes
1answer
1k views

How have tags been stored in the Stack Overflow database design?

Understanding the StackOverflow Database Schema I would like to know more about how tags are stored in the database, and how each tag is retrieved in a search query. I would also like to know if I ...
4
votes
0answers
68 views

What is your feedback/experience with the new Stack Overflow setup?

It has been one month now that the new hardware for Stack Overflow database is up and running. (New Hardware for Stack Overflow Database) This setup is a really interesting case (SSD in RAID for a ...
1
vote
1answer
150 views

stack exchange data dump to Oracle database?

How can I import the data dump to Oracle DB? Most of the tools are done to SQL Server.
0
votes
1answer
274 views

What database does Stack Overflow use? [duplicate]

Possible Duplicate: Which tools and technologies build the Stack Exchange Network? I'm very curious to know which database system stackoverflow.com uses. Does anyone know? Is it key/value or ...
0
votes
2answers
126 views

Can we have a Stack Overflow-like site for database related questions? [closed]

There are many questions already on Meta Stack Overflow regarding the database schema, but here is another, that I don't think is a duplicate, so please read on. Can we have Stack Overflow for ...
0
votes
1answer
2k views

What SQL query does stackoverflow use to retrieve a question and all its answers in order?

According to this, stackoverflow uses one table for both questions and answers. This design seems somewhat unusual. What SQL query does stackoverflow use to retrieve question #123456 and all its ...
2
votes
2answers
71 views

Where is the frontend to the database for stackexchange-2.0 sites?

At some point, a few days ago, I stumbled across a database frontend for the Stackexchange-2.0 sites. One could get various statistics and write general queries to the database. I've been looking for ...
2
votes
3answers
117 views

SE Post Data Compressed?

I'm curious if SO uses any compression algorithm to reduce storage space of posts? Or is this an unnecessary overhead since storage is cheap?
1
vote
1answer
793 views

Stackoverflow.com web/database server specs

What are the specs of the Stackoverflow web server(s) and db server(s)?
1
vote
3answers
214 views

Where to ask: “How to explain to business people that SQL Server thinks for itself”

i need to figure out how to explain to business people that Oracle and SQL Server very complex, one might like to say intelligent creatures, that decide on their own how to run queries. And while we ...
6
votes
1answer
85 views

Is data stored in the database for posts that are overwritten within 5 minutes?

Is data stored in the database for posts that are overwritten within 5 minutes? For example, if you update your post after an hour, the history will be shown, so obviously the original post is stored ...
2
votes
3answers
154 views

Can I execute queries on Data Explorer from my program

Is there a way to query the Database directly, from my app?
11
votes
2answers
1k views

How big is the stackoverflow database?

How many gigabytes is the StackOverflow database file (SQLServer I'm guessing?)
2
votes
1answer
996 views

What data access method does Stack Overflow use? [duplicate]

Possible Duplicate: What was Stack Overflow built with? What is the data access method used by the Stack Overflow family of sites? Is it LINQ to SQL?
2
votes
1answer
1k views

DB Architecture of stackoverflow [duplicate]

Possible Duplicate: What are the architecture details of Stackoverflow? I admire the instant responses of SO. I wonder how the database was built? What's the architecture? You don't need to ...
26
votes
4answers
7k views

SO database schema

Has the database schema for Stack Overflow been made publicly available? If not, could it be? If not the whole schema, how about a list of the tables used? I want this as a learning resource.