MongoDB supports SQL queries. Tableau has an MongoDB connector. You can connect MongoDB to Excel via our DataAPI and of course our Cloud platform provides embeddable charts.
Only the DataAPI is a relatively recent addition. The rest are very mature features.
MongoDB actually doesn't store JSON. It stores a binary encoding of JSON called BSON (Binary JSON) which encodes type and size information.
This means we can encode objects in your program directly into objects in the database. It also means we can natively encode documents, sub-documents, arrays, geo-spatial coordinates, floats, ints and decimals. This is a primary function of the driver.
This also allows us to efficiently index these fields, even sub-documents and arrays.
All MongoDB collections are compressed on disk by default.
Every field in a MongoDB document (we encoded documents in BSON at the driver level) is typed and you can apply a schema to any collection if you choose to do so.
I can see the source of confusion. Apologies. I mentioned ACID transactions were released in 4.0 but did not explicitly mention when the problems arose which of course was in 4.2 which was actually released a year later. The version numbers are clearly referenced in the Jepsen article.
1 Updates
2020-05-26: MongoDB identified a bug in the transaction retry mechanism which they believe was responsible for the anomalies observed in this report; a patch is scheduled for 4.2.8.
You must not have looked at MongoDB. We have been delivering fully consistent ACID transactions since 4.0 which shipped several years. Yes, Jepsen did find some issues with the initial release of ACID transactions and yes, we fixed those problems pretty rapidly.
I don't think I mentioned role model. We most definitely don't model ourselves on IBM. I was just pointing out their longevity which is impressive to me.
MongoDB supports SQL queries. Tableau has an MongoDB connector. You can connect MongoDB to Excel via our DataAPI and of course our Cloud platform provides embeddable charts.
Only the DataAPI is a relatively recent addition. The rest are very mature features.