3 ms·
Lots of the examples here are yhe author writing very poor, non idiomatic SQL and then criticizing it. I could write a point by point rebuttal but I'll just pi
by ltbarcly3 5y ago
Lots of the examples here are yhe author writing very poor, non idiomatic SQL and then criticizing it.
I could write a point by point rebuttal but I'll just pick one point, compressibility: VIEWs.
- chris_wot 5y agoYeah, some of these subqueries could be fairly easily rewritten.
- kinjba11 5y agoI've been around quite a bit of SQL, and views are great. But they're not exactly as easy as assigning to a variable. If I followed your logic per compressibility I'd have to be creating views - permanent global objects - for almost every query I write. Do you create views every time you need to write some ad-hoc SQL?
- wruza 5y agoAnd much worse problem is naming them correctly. And maintaining in such global-only space. But just give up, you hit the wall. Many people tried for decades to make this argument, but every time it was raised you’d see this thread full of people who see no problems. There is a lot of powerful, unrepeatable-in-your-lifetime software behind stupidest frontends that you can’t bypass, because most people write only straightforward code with no need for any abstractions beyond what was given to them.