Should I use a Conversation model?
Yes, if you need a chat list. The Conversation model stores participants (two user IDs), lastMessage (reference to Message), lastMessageAt (for sorting), and unreadCount (Map of userId → count). Update it when a new message is created and when messages are marked as read.
Verify This Answer
Cross-check this information using these trusted sources:
More FAQs in Chat Message Model and Database Design MongoDB Schema for Chat
senderId (ObjectId ref User), receiverId (ObjectId ref User), text (String, maxLength 1000), read (Boolean, default false), readAt (Date), and timestamps (createdAt, updatedAt from Mongoose schema options).
Compound index on (senderId, receiverId, createdAt) for efficient message history queries with sorting. Index on (receiverId, read) for finding unread messages. Index on senderId and receiverId individually for user-specific queries.
Query Message with $or for both directions (senderId=A receiverId=B OR senderId=B receiverId=A), sort by createdAt -1 (newest first), skip (page-1)*limit, limit. Reverse the result to show oldest first. Use the compound index for efficiency.
Still have questions?
Browse all our FAQs or reach out to our support team