Week 25 (Week 7 of CST363)

 

Prompt for this week's journal entry.

• Compare MongoDB with MySQL. 
• What are some similarities? 
• What are some differences? 
• When would you choose one over the other? 

- - -

 MongoDB and MySQL are both available across different platforms, are scalable for large datasets, and are widely used across similar industries that involve large data-driven applications.

The main differences between them is that SQL is structured with a rigid schema, whereas MongoDB is more flexible. Additionally, SQL is vertically scaled,  meaning it uses larger CPUs to improve speeds and storage, whereas MongoDB uses more components to achieve higher speeds and storage capability.

MongoDB is desired when you want rapid development and want a flexible schema that can be changed frequently. SQL is desired when you want a highly structured dataset where you can create a lot of relational data and do complex transactions or joins.