Hello! This will be a short post, I’ll be giving a quick summary of how friends work in the davespace remake. This is a feature that hasn’t actually been completed at the time of writing, adding and having friends has been implemented but you can’t remove them and there’s no requests yet. Friends have their very own table with two columns, user_id and friend_id. user_id is the id of the user who sent the request and friend_id is who the request was to.
When checking if users are friends, it checks if both ids are ever in the same row, which means they are friends. Friends are displayed on users profile and there will be a “Friends” section on the homepage to filter recent posts to the ones by friends.