Compare MongoDB with MySQL.
What are some similarities?
I didn't really feel like there were too many similarities other than that they both store data. Actually, the CRUD operations looked similar as well.
What are some differences?
Biggest difference is that Mongo does not use relational tables. It just stuffs all the data into one file without some sense of organization other than having the "collections" and "documents" hierarchy. That sounds a bit wild to me. MongoDB also doesn't have a complete workbench like what MySQL is (I'm assuming since it wasn't shown in the lecture or directions).
When would you choose one over the other?
I much prefer the SQL's relational structure of database where tables are used. Mongo tries to store everything as a "document" (which is like each data entity within a collection). I also much prefer the fact that SQL can be practice on a MySQL workbench that pretty much offers a full ecosystem to work in. With MongoDB, the fact that I have to pull out Microsoft notes and a command prompt side by side feels like it is 2010. Maybe I'm missing something here because surely this can't be industry standard right?
I feel like MongoDB is when you try to tell a teenage boy to clean his room and he goes
"Imma shove everything under the bed and if I run out of space, I'll then shove the rest under the couch. That's horizontal scaling for ya"
No comments:
Post a Comment