2. Query first efficient database design for a private chat application | Real time private chat app

Hello everyone, in this series you will be able to build a real time chat application like facebook with lots of cool features.

[SaiTeja-iryv]

This tutorial was extremely useful for me. Thank you!!

[jesrealibabao]

Great video! but how can i exactly query the conversation between the two user?

[yertayyeras]

Hello, so sorry, bad design. Part with deleted message, it is not so good. You mean, if one user delete, it should be also for deleting for second one? I don't think it is correct

[maheshmahadar]

where is the date/time and ordering logic ? which is major part of chatting.

[shadyeldawy]

great!
but i am still confused about the hash one, can you explain how can i query the conversation between me and another user using this hash? query example please

[selahadinjemal]

It would be great if you link the next video at the end. So that users shouldn't go look for it. Thanks.

[garetht.]

What if instead of an inboxHash in the chats table, I made the Primary Key of the inbox table a composite one of (inbox_id and user_id) then I can use the inbox_id as the Foreign Key in the chats table as now inbox_id can be unique to each conversation

[JB-uxri]

Hello, good video - thank you. I have a question, with the messages how would you make sure they display on screen in the correct order? Would you need a 'created at' row & then would you order them by the date/time? Or does it just somehow work without a date/time?

[yourgflikesit]

Problem with this is if you want to get the list of conversations in order of last message received with a preview of that message. Another table called conversations would fix that issue. Also you can’t do group chats with your database either.

[negi]

can you provide the source code for this messanger app??