Week 7

 Week 7 (6/11-6/17)

Comparison between MongoDB and MySQL. 

What are some similarities? 

MongoDB and MySQL both support indexing, sharding, replication, and unique keys to help manage and access data efficiently. Each one also allows users to select specific fields in a query (called projection) and provides an “explain” tool to see how a query runs.

What are some differences? 

MySQL is a relational database that utilizes SQL, supports joins, and provides full transaction support, ideal for structured data and complex queries. MongoDB is a NoSQL database that stores flexible, JSON-like documents. It doesn’t support joins or full transactions, but it is easier to scale and better for unstructured or changing data.

When would you choose one over the other?  

Choosing MySQL for strict data structure (tables with clear columns), when we need transactions or joins or when strong consistency is needed, MySQL is the best choice. Choosing MongoDB when flexibility and scalability are required, such as when data is nested (like JSON), when easy scaling across servers is needed, and when speed is crucial, is when MongoDB is a better choice.