I would like to have a database for social graph in my Rails app. Hopefully, the app will eventually have a few hundred of thousands of users, plus their Facebook and LinkedIn connections. Right now, I am using MySQL, but I know it is not efficient in dealing with social graph.
How should I go about this, and which framework/gems etc. that work with Rails and have been well tested?
Thank you.