Where is the chat messages stored?

[Whimpers]

Where are the chat messages between users stored in the database?

[baris]

They are stored in rooms, and each user has their own list of message ids. So if you have the roomId and a uid then you can get the list of message ids from the sorted set 'uid:' + uid + ':chat:room:' + roomId + ':mids' This sorted set contains message ids, to get the actual message data you need to load them from message:<mid>.

[Whimpers]

I'm currently using db.objects.find({_key: /^message:\d+$/}, {content: true})
How can I also get the username of the sender and receiver, @baris

[baris]

@whimpers If you get the entire message object it should have a fromuid field, using that id you can get the user object at user:<uid> everyone in the room receives the message, you can get the users in the room from chat:room:<roomId>:uids