24

Favorite data is not exactly confidential; I can go to a user's profile and see everything they have as a favorite. Why isn't there an easy way to see who marked my questions as favorite?

0

6 Answers 6

28

My guess is that you could probably work up a query with some SQL-fu.

This site is usually pretty easy to work with:

http://data.stackexchange.com

Example: users who've marked my questions as favorites on Stack Overflow

For reference:

https://blog.stackoverflow.com/category/cc-wiki-dump/

0
24

I'd actually suggest going the other way: make my list of favorited questions private. I don't see why anyone else needs to know which questions I like enough to come back to.

4
  • 9
    Cause after reading them, they may like them too? Sep 2, 2010 at 23:40
  • 3
    I seriously and strongly disagree. Everything on the SE network should be public except in the cases of some negative behavior (which should be removed in the first place). I -1 this on account of it is bad juju.
    – jcolebrand
    Jun 12, 2011 at 17:28
  • 2
    the question is whether everything should be pubic
    – Andrew
    Jan 10, 2014 at 18:58
  • 1
    @PeterAjtai Maybe someone favorited Is shaving your pubic hair bad for you? ("for a friend"), but they don't want people to see that? And there's no reason for a user to think that clicking that star icon will be something other users can see?
    – Kip
    Oct 4, 2017 at 17:26
8

You could query the database:

https://blog.stackoverflow.com/category/cc-wiki-dump/

3

There's no way to do this directly (Stack Overflow provides no mechanism to do so), but sometimes you can use Google to find out. As an example, suppose you wanted to find out who marked "Jon Skeet Facts?" as favorite. Just search for

"Jon Skeet Facts?" site:stackoverflow.com inurl:favorites

on Google.

10
  • repost from here: stackoverflow.com/questions/166109/… Jun 29, 2009 at 19:12
  • It wouldn't exactly be a difficult SQL query to write and implement, either.
    – TheTXI
    Jun 29, 2009 at 19:13
  • 4
    I tested this on a question that has 21 favorites; 4 came up and only 2 actually had it as a favorite. Not a very good success rate. Jun 29, 2009 at 19:13
  • 1
    But it's success nonetheless!
    – devinb
    Jun 29, 2009 at 19:18
  • 4
    @devinb: The number of result represented less than 20%, and 50% of that were false positives. You have a very low standard for success. I wish you were my boss. "What did you accomplish today, Pesto?" "I added a line of code that only core dumps once in every 5 tries!" "SUCCESS!" Jun 29, 2009 at 19:22
  • @thetxi Google query vs. SQL query...is there much of a difference any more...?
    – jjnguy
    Jun 29, 2009 at 19:28
  • Google query - "Did you mean RIGHT OUTER JOIN?"
    – TheTXI
    Jun 29, 2009 at 19:30
  • Honestly, who didn't mark that question as a favorite? ;) Jun 29, 2009 at 19:40
  • 4
    I didn't. In fact, I voted to close it when someone (no names mentioned here) removed the jon-skeet tag (that I have on ignored tags)
    – Powerlord
    Jun 29, 2009 at 20:53
  • @TheTXI: I wonder what the difference is between write SQL and implement SQL
    – Vinko Vrsalovic StaffMod
    Aug 26, 2009 at 1:54
2

This would allow to find people that have the same problems or interests. Nice feature for networking. Alternative: neighborhood graph based on tags in questions and answers.

1
  • Heh, interesting idea, that last one. Reminds me of last.fm which (as one of their many data mining features) produces a list of "neighbours" with similar musical taste
    – Jonik
    Jul 1, 2009 at 9:35
2

It looks like you may be able to get this from the public data dump now, starting from the July 2009 dump: https://blog.stackoverflow.com/2009/07/creative-commons-data-dump-july-09/

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .