has_many (but parent & child should be same table )

i have user table each user have lots of friends how to design ? act_as_tree , will it work ?

any other suggestion appreciated.

i have user table each user have lots of friends how to design ? act_as_tree , will it work ?

You could, but it would be messy since you and I could be friends so who has many?

Start here:

http://agilewebdevelopment.com/plugins/search?search=friends

Find one that only requires a *single* row in the database to indicate you and I are friends as opposed to "Philip is a friend of Thani" *and* "Thani is a friend of Philip".

Last time I did this I used http://agilewebdevelopment.com/plugins/has_many_friends. Worked well for me.

-philip

Philip Hallstrom wrote:

http://agilewebdevelopment.com/plugins/search?search=friends

Find one that only requires a *single* row in the database to indicate you and I are friends as opposed to "Philip is a friend of Thani" *and* "Thani is a friend of Philip".

Last time I did this I used http://agilewebdevelopment.com/plugins/has_many_friends . Worked well for me.

-philip

Thanks