4 ms·

Is there any book that has the exact specifications of this dumpster fire that is called sql? With no other language I have faced so many gotchas with implicit

Is there any book that has the exact specifications of this dumpster fire that is called sql? With no other language I have faced so many gotchas with implicit conversions and unexpected behaviors.

brigandish 5y ago
Surely you've used Javascript?
ziggus 5y ago
I've found that most traditional developers have a rough time with SQL, because they're trying to use it like a procedural language, which it isn't - it's relational algebra/calculus based. Cornell has a good explanation: https://www.cs.cornell.edu/projects/btr/bioinformaticsschool/slides/gehrke.pdf https://www.cs.cornell.edu/projects/btr/bioinformaticsschool...
- ttfkam 5y ago
  Exactly! It's a DSL for set theory. A true 4th-gen language. Perhaps the only truly successful 4GL.
em500 5y ago
https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/d/0 https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/... If you want to take a peek at an older revision: http://web.cecs.pdx.edu/~len/sql1999.pdf http://web.cecs.pdx.edu/~len/sql1999.pdf (I'm guessing this will be another case of be careful what you wish for).