MongoDB as bread-and-butter solution
Overall Satisfaction with MongoDB
MongoDB is used as persistent storage for most applications and services of our organization. Because it's versatile it can be used for all general purpose cases. We only use a different solution if there is a clear benefit of a different database type, like an RDMS or key/value store. The dynamic schema makes working with MongoDB easy for the development team.
Pros
- It is a mature project with good documentation and great support.
- Querying the database is relatively easy compared to other NoSQL solutions.
- A dynamic schema removes much of the DB migration issues to typically come with software updates.
Cons
- MongoDB can be difficult to setup properly and manage.
- The default settings are not secure. You need to actively configure the server for authentication and access control.
- Good tooling is available, but relatively expensive compared to other open source products.
- Increased productivity.
- Added to possibility to implement flexibility into the software. "You need a custom field? Sure no problem."
MySQL is a great for querying related data, but it's unable to store structured data and has a fixed schema. Also SQL can be non-intuitive. DynamoDB, CouchDB and Redis all make querying the data quite difficult and lack important features. The problem CouchDB tries to solve is very specific, making it not a good candidate for the bread-and-butter DB.
Comments
Please log in to join the conversation