Questions tagged [database]
For questions about the actual database used by the Stack Exchange sites.
42
questions
-1
votes
1
answer
122
views
Data explorer query takes a lot of time and needs to be optimized
This is a Stack Exchange Data Explorer query which gets the top users on specific skill scores (example: JavaScript) based on a specific country (example: Egypt), and it took a lot of time until it ...
- 23
7
votes
2
answers
272
views
Query for getting top users on a specific tag by country sorted by tag score (Stack Overflow)
I need a query for getting top users on a specific tag by country sorted by tag score on the Stack Overflow site.
For example.
Top users of JavaScript that live in the United States and sorted by ...
- 81
1
vote
0
answers
54
views
What is the best site to talk about data warehousing?
I am looking for the adequate site for data warehousing topics.
In terms of critical mass, what is better, Database Administrators or generic Stack Overflow? Am I in the best place?
- 27
2
votes
1
answer
147
views
How to get tags of questions answered by a user in Stack Exchange Data Explorer
I can't solve this problem: using a remote DBMS from the Stack Overflow site (URL: http://data.stackexchange.com/stackoverflow/query/new). Write a SQL query that displays the names of users with a ...
- 123
3
votes
1
answer
243
views
Save vote/visit stats of all questions and answers to a file so that one can show one's stats over time, not just the points?
Since this feature request was answered with a good workaround, I am rather asking here for any tool to get the stats of the votes and visits of questions and the votes of the answers as a file.
Old ...
- 632
8
votes
1
answer
147
views
Get overall activity difference between two years
Recently the 'Moderation results' were published across all Stack Exchange sites.
On my main site, Drupal Answers, I noticed a drastic fall in moderation actions, flagging etc. from the results that ...
user569408
9
votes
0
answers
70
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, ...
- 6,543
4
votes
1
answer
189
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 ...
- 143
1
vote
0
answers
41
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 ...
user318172
2
votes
0
answers
148
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 ...
- 161
32
votes
1
answer
727
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 ...
- 1,219
21
votes
1
answer
164
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,345
1
vote
0
answers
37
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 ...
user2421978
0
votes
1
answer
391
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 .
- 111
17
votes
2
answers
354
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,693
2
votes
0
answers
81
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 ...
- 493
9
votes
3
answers
185
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 ...
- 2,108
5
votes
0
answers
344
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
...
- 493
0
votes
1
answer
181
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?
- 503
2
votes
1
answer
351
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 ...
- 181
0
votes
1
answer
159
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?
- 111
0
votes
1
answer
938
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.
- 123
15
votes
1
answer
8k
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 ...
- 159
18
votes
2
answers
7k
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 ...
- 283
8
votes
3
answers
5k
views
Which database does Stack Overflow use behind-the-scenes? [duplicate]
Stack Overflow is developed using ASP.NET and C#. I found this fact in various answers here. So, I was wondering which database Stack Overflow uses. Is it Microsoft SQL Server, as would be expected ...
- 293
5
votes
1
answer
2k
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 ...
- 63
4
votes
0
answers
74
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 ...
- 211
1
vote
1
answer
200
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.
- 271
0
votes
1
answer
383
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 ...
- 132
0
votes
2
answers
128
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 ...
user150743
0
votes
1
answer
3k
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 ...
- 111
2
votes
2
answers
79
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 ...
- 429
2
votes
3
answers
120
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?
- 498
1
vote
1
answer
920
views
Stackoverflow.com web/database server specs [duplicate]
What are the specs of the Stackoverflow web server(s) and db server(s)?
1
vote
3
answers
251
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 ...
- 105
1
vote
1
answer
385
views
Does Stack Exchange use a single database for all its sites? Or does it have a different instance for each?
All in the question title.
6
votes
1
answer
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,348
2
votes
3
answers
223
views
Can I execute queries on Data Explorer from my program
Is there a way to query the Database directly, from my app?
13
votes
2
answers
3k
views
How big is the stackoverflow database?
How many gigabytes is the StackOverflow database file (SQLServer I'm guessing?)
- 265
3
votes
1
answer
1k
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?
- 1,789
4
votes
1
answer
4k
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 ...
Madhu
28
votes
4
answers
9k
views
SO database schema [duplicate]
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.
- 463