database-engineer-pro video for you are building a real-time chat application for a gaming platform. Users send messages that need to be delivered with low
You are building a real-time chat application for a gaming platform. Users send messages that need to be delivered with low latency and stored for audit purposes. The application also provides analytics to show the most active users in real time. You want a scalable and cost-effective solution. What should you do?