The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,650 other followers

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:

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

–jeroen

via My answers with non Delphi tag – Stack Exchange Data Explorer.

2 Responses to “Cool: your own queries on Stack Exchange Data Explorer (StackOverflow: My answers with non Delphi tag)”

  1. 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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: