I still say Rose is one of the luckiest guys in business. He's jumped from thing to thing with no real long term success but has managed to do pretty well off of some early media exposure.
There was a period around 2010 where developers all declared sql dead, and started playing with nosql solutions. My personal experience at the time was, most people didn't have Facebook's scaling problems, and they created terrible tech debts as a result.
Eventually most people remembered why SQL was so great, and they added Redis if they needed a cache. The Ruby people though still liked those NoSQL stuff, and I'll never understand them.
I’ve been working in Ruby that whole time, and Postgres is like the right arm of the prototypical Ruby app. We did have a fad where Mongo was used at my company in the early ‘10s, and indeed we had little choice but to do rewrite that part. We actually had an amazing intern do that one year.
I started in PHP land 20+ years ago, moved into Ruby for the next 10, and now am firmly in JS/Node land. I have used Postgres nearly the entire time. It's my experience that you will never go wrong picking Postgres as your primary data store. Love that DB.
MySQL backed, in turn, by a log structured storage engine (RocksDB). But the they reason they do that is storage space efficiency rather than availability or performance.
By the way, thanks for sharing the video. It took me back to a simpler era, two guys drinking and talking about the issues they had to overcome. We now take these social media for granted, but back then some of those problems were too knew for those guys.
https://www.youtube.com/watch?v=eQNBcIPSROs