My Personal Thoughts on the Pros and Cons of MongoDB Compared to Other RDBMS
Hello, this is Munou.
I've quickly looked into it and summarized my thoughts.
Flexible handling like a developer, even if the structure isn't decided from the start?
For example, if you have a table with a field name like "password" in MariaDB, and you mistakenly try to use "passw"a"rd", data integrity will be lost, and an an error will occur.
In other words, as an RDBMS, it has the characteristic of handling data according to a schema.
In contrast, MongoDB, being a "NoSQL" and document-oriented database, will store even a mistyped "passw"a"rd". This is because it doesn't require strict accuracy.
Wouldn't you say it's easy to scale up when dealing with dynamic data or from a developer's perspective? Of course, there's a feeling that a database that can't maintain data integrity when storing data is questionable, but it is possible to convert data from MongoDB to other RDBMS, and if it has that versatility, I don't think it should be completely avoided.
For things that have matured in MongoDB, you can migrate to another RDBMS if needed later, but if a certain database structure is decided from the beginning, there might be no need to specifically use it.
In any case, from a developer's perspective, I believe MongoDB has at least some advantages in terms of ease of handling as a database.
It might also be powerful when you want to store everything in the DB without omission.
For example, when dealing with data from multiple sites, you can just dump everything into MongoDB, whether it's "user" or "userid", and then edit it all later. Storing everything in the same collection allows for later editing, which is a strength. I was actually able to perform replacements easily.
When you want to store something as a log in the DB, you can dump everything without omission, so you might be able to cover almost all data without any leaks.
I've seen a lot of criticism and even statements that it's meaningless to use, but when I actually tried it, I found many aspects where it was easy to handle, so I might continue to use it or I might not.
That's all for now.
I look forward to your continued support.