Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Socia; Network design

Author  Topic 

Tokbek
Starting Member

1 Post

Posted - 2008-03-01 : 14:03:32
Hi,

Im developing a social network, and need your opinion for the right approach.

The basic structure of the my network is:

1. Users
2. Groups

Each user can be related to other users in two ways:

1. They are "Friends"
2. They belong to the same group.

when a user details displayed in the website - through Search results, profile page, forums....etc - ,
there are some actions you can perform - Send him a message, Invite to event and more.
Users can define in their account settings, who will be allowed to perform this actions.

1. Everyone
2. Only my friends
3. My friends and my groups member

What is the best way to enforce this privacy rules with a good performance ?

Thanks for any reply.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-01 : 16:51:01
Check out all posts made by Mike123 and all answers he has got.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-03-03 : 06:28:39
What I think Peso is saying is that this question is way to broad to give you a meaningful response without basically spending the next week writing. You need to brake it down and give some suggestions on your own...noone will do your work for you unless you give it a shot first.

--
Lumbago
"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4"
Go to Top of Page
   

- Advertisement -