I am relatively new to database designing. I am currently using amazon SimpleDB to provide my application with information, so far its been relatively good and efficient until just now. Basically, I keep a registry of users (the items) which have properties related to their accounts on my app.
The problem is that I need a social-like structure, each user must have a list of friends, and a list of pictures that he is allowed to see. Both of these list will keep growing and I just dont know how to handle it in the Amazon SimpleDB Architecture. I thought about having a multi value property, but i fear the size might run out too fast, since the value length is 1024 bytes.
I also thought about having a domain dedicated to the users friends. Having the item name as the userID and using the properties as pages to keep multiple friends, but i think this is totally wrong.
Does anyone have an idea of how to handle this type of architectures in amazon simpleDB? Or should I just change to the traditional database?