All Questions
79
questions
17
votes
1
answer
268
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 ...
25
votes
2
answers
702
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 ...
14
votes
1
answer
152
views
Expose moderator-only and required tags in SEDE
The API has two methods to get a list of required tags (the gray ones) and moderator-only tags (the red ones):
required tags
moderator only tags
That means there must be an enumeration (or two ...
9
votes
1
answer
209
views
Rename "Favorite" vote type to "Bookmark" in VoteTypes table SEDE
Over at SEDE, in this query, it shows the vote type (or what should be the vote type) "bookmark" as "favorite":
Can we update that to say "bookmark", since favorites are ...
1
vote
2
answers
140
views
SEDE help page still links to version 3.0 of Creative Commons license
Related to the post : SEDE footer still links to version 3.0 of Creative Commons license.
In the Stack Exchange Data Explorer help page, currently the Creative Commons license is referred with ...
6
votes
2
answers
80
views
Change taglines for non-English sites and new Meta sites on SEDE homepage
The homepage of the Stack Exchange Data Explorer has mixed-language taglines for non-English sites; e.g. for Russian Stack Overflow it is "Q&A for программистов".
Can this be changed to something ...
10
votes
0
answers
126
views
Can the Description for the CloseReasonTypes be added for the newer Close Reasons?
The table CloseReasonTypes in The Stack Exchange Data Explorer holds the id, name and description for the various close reasons.
When the close reasons got a major overhaul the new close reasons got ...
7
votes
2
answers
238
views
Could we get different font colors for SEDE comments and strings?
In SEDE, using Chrome on Windows, comments and strings are both formatted in the same shade of green:
(Snip is from this query)
Now, I'm sure many out there will have bones to pick with my query ...
9
votes
1
answer
124
views
Expose information about Community bumps, preferably in the Data Explorer
I would like to have some way of knowing when Community has bumped a post. Currently, unless you "catch Community in the act" (i.e. examine the question before anybody else makes a change to it or one ...
3
votes
1
answer
117
views
Link SEDE page to specific site
I am browsing the SEDE on the CiviCRM meta page. On the main page, I can click Visit Site and go to it:
But looking at that site's page, I can't see how to get to it. The CiviCRM meta text doesn't ...
6
votes
0
answers
62
views
Add a BadgeTypeId to the Badges table on SEDE [duplicate]
When trying to derive badge statistics on SEDE it would be helpful if there was an identifier (say BadgeTypeId) that would mark the badge as being
Bronze badge
Silver badge
Gold badge
Bronze tag ...
21
votes
1
answer
493
views
In the PostHistory table what is that number in the comment column?
In SEDE the PostHistory table holds for PostHistoryTypeId's 33 and 34 the Notice added and Notice removed events.
When inspecting those rows with this query the comment field holds a number.
...
5
votes
1
answer
177
views
Hide the broken OData link in Data Explorer
The OData protocol was used in the past as a feature to get data from SE data dumps, but is currently lightly maintained since the Stack Exchange API is usually better.
The problem is that it seems to ...
17
votes
1
answer
164
views
Magic "sede://" syntax (akin to site://) for linking to http://data.stackexchange.com/<sitename>/
On SEDE, we currently have the magic syntax site://, which expands to the domain name of the site on which the query is currently being run. So, for example, in queries run from https://data....
9
votes
1
answer
100
views
Default to lang-sql syntax highlighting for Meta.SE posts tagged with [data-explorer]
It would be nice if posts here on Meta.SE that are tagged with data-explorer would automatically have SQL syntax highlighting (a la <!-- language: lang-sql -->) applied, in the same way that ...