imagine hating working with databases so much you'd want to spin not being able to use modern databases amazing features as a "potential positive" just so you don't have to deal with them...
> Where is this meme that RDBMSs do not scale coming from? (I see lots of people saying this as though it is a given. Has there been any published data on this for me to read?).
It mostly comes from people who don't know how and when to create an index.
Dollars aren't used for any transactions you or I would make, people do still like making cash savings in Dollars or Euros if they can get their hands on them.
they've also somehow modified Lucene's search algorithm to perform some ML calculations, but it's not clear what they've implemented. still not a "new database category" though.
I've forced the habit upon myself to first compose a SELECT statement and verify that it will give me exactly the dataset that I want to run my operation on. Then I wrap that statement into a CTE and run the DELETE / UPDATE on the CTE.
Bokeh and Plotly obviously do much, much more than matplotlib, and if you want what they provide, you would go for those. Seaborn is more presentable-looking by default and easier to get things laid out in. I personally haven't used straight-up matplotlib for a long time.
I think it's nonsense to present this as a general truth the way the author does. There are likely plenty of geographical locations, skillsets and business domains where the opposite is true. If he's writing for the US, it's most likely not even generally true for the US.