You are building a collaborative messaging feature for a mobile app. Clients must receive new messages within a chat room in near real time without polling, and the app needs to work while the device is briefly offline, syncing changes when connectivity returns. Message volume per room is moderate (thousands of messages), and you expect millions of rooms. Which storage system best fits these requirements?