2 ms·
I wish your thinking would be more widespread. I never understood how come that restful HTTP became very popular without having any universal query language aro
by fogetti 10y ago
I wish your thinking would be more widespread. I never understood how come that restful HTTP became very popular without having any universal query language around and merely providing an HTTP client with each service built, while in the DB world everybody is obsessed with SQL? Why not just provide the developer with an API/library for the underlying algorithms/datastructures?
For example I hate so much when I have to read mySQL documentation jus to find out what went wrong when I used ORDER BY and the optimization didn't kick in? I mean, if I have to keep in my head the whole optimization mechanism of the DB engine and all the steps of the filesort algorithm going on behind the scenes just to write a single wretched SQL statement, then what's the point of SQL in the first place?
And this was just one example. The truth is that the SQL abstraction is leaking. Most of the commands don't encapsulate anything at all.