Questions tagged [database]
For questions about the actual database used by the Stack Exchange sites.
42
questions
-1
votes
1
answer
120
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
253
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
53
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
145
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
236
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,533
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
163
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
390
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,695