Questions tagged [data-explorer]
For questions about the functionalities, queries, databases and datamodel of The Stack Exchange Data Explorer (SEDE). SEDE allows you to create and run queries against copies of the databases of popular Stack Exchange sites.
1,573
questions
9
votes
1
answer
190
views
What is going on with SEDE (and SO)? Can it be used only after the weekly update ends?
It seems that at the moment:
After clicking on compose query you get: "Server Error in '/' Application. - Runtime Error". But it works if you use a different site instead of SO.
Running any ...
- 15.2k
-5
votes
0
answers
135
views
How can I run SEDE queries on my computer? [duplicate]
Some SEDE queries time out on SEDE. How can I run SEDE queries on my computer?
-2
votes
1
answer
164
views
Increase max SEDE query running time
I see an increasing amount of:
Line 0: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
errors (screenshot) on SEDE due to ...
17
votes
1
answer
267
views
Can we exchange one index for another one?
In the Stack Exchange Data Explorer only the most logical/beneficial yet minimal set of indexes is created for the tables found in the schema.
One of those indexes is on the Users table:
CREATE ...
- 91k
7
votes
2
answers
124
views
How should I go about retrieving the date of when a question became/was no longer hot with SEDE?
I am currently making a SEDE query to determine which questions from a specific user have made it onto the Hot Network Questions list and when. While I can get the specific questions, I am unable to ...
- 399
-1
votes
1
answer
118
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
248
views
Data Explorer Query crashes with collation conflict error
I have a website built off my Q & A posted in Stack Exchange sites such as; Ask Ubuntu, Stack Overflow, SE Security, etc.
Data Explorer is used to scrape ALL Stack Exchange Q & A I've posted ...
- 347
5
votes
1
answer
101
views
Are SEDE results ever cached on client side, or solely on server side?
I know that SEDE query results are cached on the server side. I wonder if in some cases they are also cached on the client side.
5
votes
1
answer
163
views
How can one see when a query was cached in SEDE?
Query results in SEDE are cached:
How can one see when a query result was last cached in SEDE?
25
votes
2
answers
696
views
Create a view that provides a list of databases
In an answer to Strange new database 'Data.StackExchangePOC' is messing up cross-site SEDE queries our DBA extraordinair Aaron Bertrand suggested to have a feature request for a view to list ...
- 91k
14
votes
1
answer
268
views
Tags column of Posts table changed delimiter format. Many historical queries broken. Special tag rendering also broken
To the best of my memory, and in reading my past queries- some of which I re-run on a regular basis- the format of the Tags column of the Posts table in SEDE used to be like <starball><is>&...
- 26.7k
14
votes
1
answer
554
views
What caused the drop in questions in April 2023?
Rerunning this query by starball for new questions and answers posted across the network generated the following graph:
It plots posts by their creation date, and includes deleted posts.
The decline ...
- 1,396
2
votes
0
answers
95
views
Logging out doesn't log out from data.stackexchange.com
Logging out says it logs out from stackexchange.com but that's incorrect as it doesn't log out from data.stackexchange.com.
Tested on Chrome with Android on a Galaxy S23.
10
votes
2
answers
171
views
How can I write and run a SEDE query without the query itself being visible to other regular SEDE users?
How can I write and run a query in SEDE without the query itself being visible to other regular SEDE users, such as in the "everything" tab of the "queries" page?
- 26.7k
7
votes
1
answer
117
views
What exactly is the "sql" parameter in SEDE and what purpose does it serve?
SEDE supports query parameters. I found that if I try to define a query parameter of string type named "sql", whatever I pass as the argument for that parameter will be prepended by a string ...
- 26.7k