if i'm creating a direct messaging app
would i have to create a database for every single conversation?
RI wouldn't think so, wouldn't think table either.
Bhow should i approach it then?
GYou have a single messages table with a foreign key to a conversation table.
Bfor all messages in every single conversation?
Bincluding all rdirect messages beteween each user to another?
GEvery forum or chat app I've seen has a single table for the topics/rooms and then all the comments/replies/messages in a single table all linked back to the "parent" table.
Bhow can i accoutn for every single room?
Bor should there just be a post to the table when a ne wone is creted
GYou create a room in the rooms table. Then you add message into the messages table with a foreign key back to that room id.
