The case against SQL

"There are two kinds of languages: the ones people complain about and the ones nobody uses"

I understand that SQL is suboptimal for interacting with data programmatically. But the web is still built entirely on Javascript so I don't want to hear anyone talk about suboptimal languages.

Took me couple minutes to understand SQL. Still can't understand how effin Elastic Search queries work.

I got into database, and then programming, 20 years ago, because it was easy to understand SQL

SQL is amazing!! Last night, I replaced 4 loops, multiple mappings, and 3 db calls, with one single query on 3 inner joined tables, which is much more readable than whatever old code was.

I feel like his take would be more like "There should be an API to allow you to build a query not using a SQL string intermediate"

Theo, you can't just say "clean code has done irreparable damage" without making a follow up video!

Year 2000: start using SQL Year 2010: stop using SQL and start using NoSQL Year 2020: stop using NoSQL and start using Redis or KeyDB Year 2030: stop using Redis and use flat file like SQLight since NVME SSD are 4x faster then RAM and massive storage. Year 2040: stop using SQLight and start using LightPath DB which uses light to store and retrieve data which is Infinite times faster than anything else. Year 2050: End of civilization due to war (birth of prime 1)

Java has a library called JOOQ, that while it produces SQL under the hood, really attempts to do this.

34:11 i think the UB's point was that this "ORM" should be some standartized thing like (and instead of) SQL so everyone would be knowing its interfaces instead of sql syntax. So it wouldn't be tied to some programming language.