• 0 Posts
  • 37 Comments
Joined 1 year ago
cake
Cake day: January 14th, 2024

help-circle
rss











  • I think wed just need the following

    • rel.id (primary key)
    • rel.user_id (foreign key to person.id)
    • rel.user_id2 (foreign key to person.id)
    • rel.type (type of relationship)
    • rel.start (non null)
    • rel.end

    From there you don’t need a rel.status because you’re not updating this rel.id entry except for the rel.end. if they started dating again later it would be a whole new entry, and then you could query their entire dating history to see if they keep coming back to the same person, dating around, playing the field, etc. Separately there could be a friendship relationship that is tracked so you could if they ended being friends after a breakup.


  • To that point a person table with a relationship table. So this way you can reference relationship between two or more persons within the relationship table and that could be joined to the person table if needed. I don’t think you’d really be able to keep it within one table while exploring multiple relationships unless you’re storing a list of ids that is interpreted outside of sql. Also a relationship table would allow exploring other types of relationships such as exes, love interests, coworkers, family, friends, etc





  • They did, and they still have the rpi foundation with that goal, as well as the for-profit subsidiary.

    It’s a flaw with effective altriusm-- you have a goal of fixing some large scale problem and at some point you realize you need large amounts of capital to expand your impact. But the interim period you are just going to be amassing wealth with this idea of doing good. And even then, you may never reach a point where you feel like you earned enough to solve your problem. I.e sam bankman fried

    Now I’m not saying that rpi foundation hasn’t done good in the world. I’m just saying that they did start off with a lofty goal and it is clear that they are wanting to expand and make more money. Maybe this means someday they’ll be able to do even greater things through the rpi foundation… but I’m not optimistic