Re:Codd almighty! Has it been half a century of SQL already?
by collyw on Wednesday June 05, 2024 @01:55PM
(#40588131)
SQL isn't the nicest language to write, but I do find it one of the most readable languages out there.
> The worst SQL I've ever seen is when someone attempts to program it imperatively. It takes a different mentality to write SQL then to write imperative code.
Use to any me when my team lead who was a fairly shitty programmer used to describe queries to me in an imperative way.
"IF, blah blah blah, THEN". You need to think of your queries as "Return this to me WHEN". Once you get your head around this, there is something quite elegant about the relational model.
> The worst SQL I've ever seen is when someone attempts to program it imperatively. It takes a different mentality to write SQL then to write imperative code.
Use to any me when my team lead who was a fairly shitty programmer used to describe queries to me in an imperative way. "IF, blah blah blah, THEN". You need to think of your queries as "Return this to me WHEN". Once you get your head around this, there is something quite elegant about the relational model.