NoSQL has always been a niche use case thing.

For some stuff, no ACID is no problem. They have their place. What I’m more suspicious of is things like Google offering distributed databases that they pretend as if they could break the CAP theorem.

And yet my Uni treats it like the biggest thing in existence. Meanwhile I’ve never used anything other than RDBS and Redis (only for cache), neither in private nor at work.

If you need to run queries that aggregate big amounts of data in a reasonable time and cost, you’ll need something built for it. For example, with column oriented file formats instead of row oriented file formats in traditional relational databases