[threeseed]

You would think after all these years people would stop using the term NoSQL. They are just databases.

Many of the so-called NoSQL ones like MongoDB or Cassandra can support schemas, transactions, strong consistency, joins, secondary indexes etc. And SQL databases like PostgreSQL support schema-less data structures.

And with Presto, Spark SQL etc you can use SQL with almost any data store.

[reidjs]

Just because they support those things does it mean it’s straight forward to use them

Our team had a lot of trouble trying to map highly relational data to a noSQL database (mongo)

It could have been a failing of our team, but I also think it just made our lives way harder. We’re on Postgres now and a lot of issues have faded away.

[revscat]

Same experience here.

We had a small-ish application that was originally built in top of MongoDB. Once it made it into production and started to see some success, it became quickly apparent that the schemaless design caused problems that an RDBMS would have solved.

It was decided fairly quickly to remove the MongoDB underpinnings and migrate everything to Postgres. It was the right call, and the final nail in any remaining affection — and interest — I had for NoSQL stores.