I wanted to take a tangent on this topic and write down a paragraph or two about my hands-on experience with one of the NoSQL databases, MongoDB.

I have been experimenting using Mongo for a non-security-related pet project for several months now. I chose it as an alternative to a MySQL that was being used as a mix for inherently relational data, but mostly vector-type data where the number of vector items is not known ahead of time. For example, take a vector of times [t1 = 1, t2 = 0, t3 = 15] associated with an object X. The zeros in this problem don’t matter, so we only need to store t1 and t3. The relational schema has a table of time with time_id and time_name – t1 has ID of 42 and name “t1”, and a table of time_values with object_id, time_id and time_value. This way we can re-create the vector of times for object X by selecting all the non-zero values from the time table and joining with the time table to get the location of the value within the vector. In contrast, in MongoDB (or any other NoSQL document-oriented database), given a document X we can store another document called times within it. X looks like this: X = { id: ..., times: { t1: 1, t3 = 15 }}. This problem has suddenly become trivial.

Out of all databases I’ve tried I picked MongoDB. It’s very well suited for the above-mentioned problem. It requires almost no installation, has a small footprint and excellent performance. It’s an extremely well engineered product by the smartest people in the room. It follows the same all-in-one philosophy that we successfully applied with the Alkaline search engine a decade ago and is a pleasure to work with.

You can see why I was hesitant to write anything that could be even remotely negative about Mongo. So I showed the draft to a dozen people before publishing the article and everyone told me that it stroke a good balance, calling people’s attention on what’s important: secure your sensitive data. It’s pretty clear that MongoDB team is working on features in the priority order based on real customer input, so I am confident that it’s a matter of time till enterprise-grade security is built into this awesome database by either the Mongo team or independent contributors, provided there’s enough corporate interest. If you’re in a big company with lots of money and are using MongoDB, pay some money to 10gen for commercial support and/or partner with them and sponsor the development of features that you need.

Was this blog helpful? Help me raise $2,620 to run the NYC TCS Marathon 2018 with TeamForKids.