cst 363: week 7

• Compare MongoDB with MySQL. 

Both MongoDB and MySQL are options that people can use for database solutions.

• What are some similarities? 

Some similarities are that both of these are used to store large amounts of data. Both of these options also have large communities and documentation, making it easy to integrate fast into your application. Also, you're able to run Create, Read, Update, and Delete operations with both of these.

• What are some differences? 

Some differences are that MongoDB uses MQL, while MySQL uses SQL. Also, after researching, I learned that MongoDB is better for horizontal scaling (data sharding) wheras MySQL is better for vertical scaling. Vertical scaling is adding more resources to an existing DB, like CPU, RAM, storage, etc. Horizontal scaling simply means adding more machines.

• When would you choose one over the other? 

You would chose MongoDB over MySQL if you wanted to manage data that doesn't have as great of a structure. It is also great for dealing with large volumes of data over many tables. Also, if you anticipate your data structure changing over time, MongoDB might be a great option.

You would chose MySQL over MongoDB if you had a very rigid and structured database that you don't anticipate changing over time. Also, if you plan on using more complicated joins or running queries, MySQL is the best option. Because of how long MySQL has been around, there are far more integrations and third party applications that are compatible as well.