Database Structure for Messaging Application

#database #structure #messaging #chat
Database Structure for Messaging Application
messaging application, The features I want to provide are:

Sending a message to multiple people
Receiving message sent to a user
Showing message in groups divided by the users, Like in facebook message
But when a user will send a message to multiple people, It will not be a group message but those messages will go in groups divided by users

firebase chat database structure
one to one chat database structure
chat database design nosql
database design for email messaging system
whatsapp chat database-design
mongodb schema for chat application
facebook messenger database schema
chat database design mongodb

[arpanbanerjee]

Great explanation. Clear and straight to the point! Thank you.

[sechabamotaung]

Found this very usefull and staright to the point. Thank you.

[MunibHassan-jzdd]

what tool use for making this type of diagram/structure?

[mozartiano]

if you are using clustered indexes it is better to have one index in (user_id, id) since it will group all messages for same user together, improving data retrieval performance. Inserts would be a bit slowed down, though, due to page splits, so u need to benchmark it.

[manee]

Which tool are you using for database relations and etc ..?

[tosinadekunle]

Please what is the name of the ERD software used in the video?
Thank you.

[adeniyiadekoya]

How do you know who a user is having a conversation with when you get the list for inbox last_sent_user_id might just be the user's id

[wuf]

Why use all these 'uid' columns, you can just directly reference the primary key (id) on the foreign table.
Otherwise, looks great.

[fabsync]

Thanks a lot for the video! I wonder what's the name of the software you used to design the database?

[nirajpatil]

Sir please tell what are the specifications u have applied on all the fields in user and inbox tables 🙏

[randynguyen]

Hello sir, what is the name of the app you use on this video?

[muhammadsultanalmahfuz]

What is the name of this software that you designed this Database Structure?

[ratopetista]

why does the inbox_uid foreign key in messages table have its data type as binary?

[Staycoolvisuals]

It is unclear wish you would have showed the tables with data while your still explaining the relationships