Hi I'm trying to build a new facebook app. I want to keep a database of the friends of friends for each user. what's the best way to store and maintain such a graph ?
thanks Gady
Hi I'm trying to build a new facebook app. I want to keep a database of the friends of friends for each user. what's the best way to store and maintain such a graph ?
thanks Gady
Hi Gady,
There was an interesting article in February's edition on Linux Journal (166) about Rails and Facebook API integration. http://www.linuxjournal.com/article/9924
They suggested a few of resources http://wiki.developers.facebook.com/index.php/Using_Ruby_on_Rails_with_Facebook_Platform http://rfacebook.rubyforge.org/ http://www.chadfowler.com/2007/9/5/writing-apis-to-wrap-apis
Cheers, Ewan
Gady Sujo wrote:
Hi I'm trying to build a new facebook app. I want to keep a database of the friends of friends for each user. what's the best way to store and maintain such a graph ?
I imagine if you have a table of just the friends of each user (columns: user_id, friend_user_id), you can get the collection of friends of friends of each user.
Something like:
select u.* from user u, friends f1, friends f2 where f2.user_id = :given_user_id and f2.friend_user_id = f1.user_id and f1.friend_user_id = u.id and
Stephan