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