NoSQL: The Baby and the Bathwater
brooker.co.za
NoSQL: The Baby and the Bathwater
1–7 of 7 posts
Re: NoSQL: The Baby and the Bathwater
#2(from the article)
What did NoSQL throw out? Again, that varies from database to database, but it was approximately these things:
Explicit schema
Transactions
Strong consistency
Joins, secondary indexes, unique keys, etc.
The SQL language itself
Re: NoSQL: The Baby and the Bathwater
#3(from the article) What did NoSQL throw out? Again, that varies from database to database, but it was approximately these things: Explicit schema Transactions Strong consistency Joins, secondary indexes, unique keys, etc. The SQL language itself Looking through the lens of scalability, let's consider the effect of these. Which were the dirty bathwater, and which the baby?
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.
Re: NoSQL: The Baby and the Bathwater
#4(from the article) What did NoSQL throw out? Again, that varies from database to database, but it was approximately these things: Explicit schema Transactions Strong consistency Joins, secondary indexes, unique keys, etc. The SQL language itself Looking through the lens of scalability, let's consider the effect of these. Which were the dirty bathwater, and which the baby?
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 Javascrip…
You knowledge of MongoDB is a little out of date.
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.
Re: NoSQL: The Baby and the Bathwater
#5Earlier quoted context omitted.
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 Javascrip…
You knowledge of MongoDB is a little out of date. 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.
So it's no longer a NoSQL database. ;)
Re: NoSQL: The Baby and the Bathwater
#6Earlier quoted context omitted.
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 Javascrip…
You knowledge of MongoDB is a little out of date. 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.
I did not find a reliable way to query MongoDB with SQL:
https://github.com/ClickHouse/ClickBench/blob/main/mongodb/q...
It looks like it's only available in the Atlas service. Please correct me if I'm wrong.
Writing analytic queries in JS is painful.
Re: NoSQL: The Baby and the Bathwater
#7Earlier quoted context omitted.
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 Javascrip…
You knowledge of MongoDB is a little out of date. 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.
Problem with mongo is if you start using more SQL like things like pipelines and aggregations your perf goes out the window
you really have to think about how you structure your data in mongo for it to work with lots of queries since joins are untenable (even if aggregations support them)