Hey Ashy, The system we use for doing this (flock) is open-sourced on github. It is a graph database designed for storing information like follows.
You can find more information and the code at: http://github.com/twitter/flockdb Hope that is helpful, @themattharris On Sep 14, 2010, at 7:10, ashy <ashwinmo...@gmail.com> wrote: > Hi All, > > I want to represent the relationship seen in twitter into the > database. For eg : user1 is following user2, user3, user 4, user 5 and > user6. But user5 and user6 are following user1 in turn. How would > design the database to represent this relationship. Any ideas? > > thanks > ashy > > -- > Twitter developer documentation and resources: http://dev.twitter.com/doc > API updates via Twitter: http://twitter.com/twitterapi > Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list > Change your membership to this group: > http://groups.google.com/group/twitter-development-talk?hl=en -- Twitter developer documentation and resources: http://dev.twitter.com/doc API updates via Twitter: http://twitter.com/twitterapi Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list Change your membership to this group: http://groups.google.com/group/twitter-development-talk?hl=en