The Wiert Corner – irregular stream of stuff

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

  • My work

  • My badges

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming

    20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now

    20140424-Windows-7-free-disk-space

    More Photos
  • Pages

  • All categories

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

    Join 1,733 other followers

Archive for September 5th, 2014

StackOverflow/StackExchange: two queries to help me improve my questions and answers

Posted by jpluimers on 2014/09/05

On the StackExchange network, I try to keep track of the questions I asked, and answers I gave in order to see if they need follow up.

For instance, questions with answers that have no accepted answer usually indicate there is room for improvement.

On my own questions, it means I could accept an answer, or give out more information on how to better answer that question.

On mu answers to questions from others, it might mean I need to improve my answer, or comment on his question to explain it better.

The first category can be queried easily by the built in search capabilities:
http://stackoverflow.com/search?q=user%3ame%20is%3aanswer%20hasaccepted%3ano

The second category requires the Stack Exchange Data Explorer (SEDE) to execute some SQL:
My answers to questions that have no accepted answer – Stack Exchange Data Explorer.

  • Replace the ‘me’ with your StackOverwlow user ID
    (for StackOverflow.com, you can get that from http://stackoverflow.com/search?q=user%3ame as it will be listed in the search box there)
  • replace stackoverflow with a mnemonic obtained from the main SEDE page (click on the icon you are interested in, then copy that part into the query)

Note some questions (like Wiki: Current state of the art of Delphi 3rd party TCP/IP components libraries – Stack Overflow) are not suited to have one ‘best’ answer.

Note the SEDE can be addictive. If it is starting to become that way, perform a Jon Skeet comparison.

Note the SEDE data is usually at least a few days older than the live data.

–jeroen

Posted in Pingback, Power User, SocialMedia, Stackoverflow | Leave a Comment »

 
%d bloggers like this: