What is mongoSQL?
Using SQL to query and filter unstructured data, such as that in Big Data databases like MongoDB, is sometimes debated. Many people believe that SQL is not really the best tool. While that is true sometimes, for many jobs it is definitely up to the task. It carries with it some of the same limitations as MongoDB, such as no joins. But it supports simple and complex SQL along with aggregation that can optionally use either MongoDB’s aggregation framework or map reduce. There are no architectural changes necessary because mongoSQL is a client UI.
The most likely users of mongoSQL are people who:
– Do not want to commit architecturally yet to additional Big Data tools.
– Are not proficient with the available Big Data tools or do not require much of the functionality of these tools.
– Want to use a friendly SQL UI.
– Need to vet and possibly modify MongoDB data directly.