Back in the early 2010s, NoSQL hype was at an all-time high. One of the things that I never understood was how did organizations that chose to use a NoSQL as the primary business database deal with analytics?
You know, analyzing sales, user data, etc. With MySQL or Postgres, business analysts can just write SQL and get the data they need. But what about with MongoDB? Do you expect business analysts to write Javascript? Or that every data request needs to go through a product engineer? Or maybe you need to create data pipelines from MongoDB to MySQL just for analysts?
Dealing with analytics was the primary reason I never chose a NoSQL database as my main data store.
You know, analyzing sales, user data, etc. With MySQL or Postgres, business analysts can just write SQL and get the data they need. But what about with MongoDB? Do you expect business analysts to write Javascript? Or that every data request needs to go through a product engineer? Or maybe you need to create data pipelines from MongoDB to MySQL just for analysts?
Dealing with analytics was the primary reason I never chose a NoSQL database as my main data store.