Cool: your own queries on Stack Exchange Data Explorer (StackOverflow: My answers with non Delphi tag)
Posted by jpluimers on 2013/02/12
This is way cool, and has been there for a long time, and I completely missed it until recently (:
On the Stack Exchange Data Explorer, you can write your own queries for any of the StackExchange sites as they share a common database infrastructure.
The queries can even contain an execution plan, and given the large number of questions (the total of Questions (table Posts) is total over 10 million now: select count(*) as QuestionCount from Posts as Questions).
There are many examples, for instance this one by sam.saffron and TLama that lists posts outside the Delphi area:
[sourcecode language=”sql”]
DECLARE @MyUserID INT = ##UserID:int##
SELECT
Answer.Id AS [Post Link],
Answer.Score AS [Score],
Question.Tags,
Answer.CreationDate AS [Creation Date]
FROM
Posts Question
LEFT JOIN Posts Answer ON Question.ID = Answer.ParentId
WHERE
Answer.PostTypeId = 2 AND
Answer.OwnerUserId = @MyUserID AND
Question.Tags NOT LIKE ‘%<delphi>%’
ORDER BY
Question.CreationDate
ASC
[/sourcecode]
–jeroen
via My answers with non Delphi tag – Stack Exchange Data Explorer.
Fritz said
Really cool!
But it’s not quite real time, is it?
How much time does it take to make modifications in the user profile appear in this query interface?
jpluimers said
I have no idea. Try and report back here (;
–jeroen