search

sst / guide

Repo for guide.sst.dev
https://guide.sst.dev
MIT License
3.68k stars 443 forks source link

[future ideas] social networking #145

Open quantuminformation opened 6 years ago

quantuminformation commented 6 years ago

Might be interesting on how to allow users to see each other's notes. Could borrow some ideas from https://github.com/Qolzam/react-social-network

quantuminformation commented 6 years ago

Although I don't think dynamo db would be enough for this, probably SN stuff would need to sit on RDS + psql

jayair commented 6 years ago

@QuantumInformation We have been thinking about how to extend this into other concepts. I'll take a look at the repo.

quantuminformation commented 6 years ago

One of the things I've been trying to decide is whether to extend this into a social network for my own use by using more dynamo tables or RDS.

I could imagine using dynamo as follows:

A user profile table (unless I can store arbitrary info in the user pool)

{profileID, customField1 etc}

But I'm not to share how to structure a table to map user profiles to other user profiles.

I also would need a tags table to store profiles. ie

{tagname: profiles: [profileID1,profileID1,]}

I could do this easy with psql but if I can do it in dynamo the all the easier for me, and easier for scale. In psql I would simple have many to many tables to do the profile - profile mappings and the same for profiles to tags.