Programming, System Design Interview, Software Development, Software Engineering, Development.
are used as join tables between users. A NoSQL database such as Cassandra is a potential solution to store chat messages. But I’ll use MySQL to store account metadata and chat messages because: It offers strong tooling support The relational data model is a solid discipline AWS S3 Object storage