4 ms·
Idle thought: I sometimes wonder if SQL could be implemented visually. It's basically sets, after all. I suspect it would quickly become too complex, but there
by flir 3y ago
Idle thought: I sometimes wonder if SQL could be implemented visually. It's basically sets, after all.
I suspect it would quickly become too complex, but there's plenty of people smarter than me...
- hermitcrab 3y agoYou often see SQL joins represented with Venn diagram, but it realy isn't a great representation of join.
- flir 3y agoYou sure? I tend to think in terms roughly like this when I'm selecting a JOIN: https://dk81.github.io/dkmathstats_site/set-theory-sql.html https://dk81.github.io/dkmathstats_site/set-theory-sql.html Eg (A LEFT JOIN B) = (A ∩ B) + A Maybe I'm missing something though.
- hermitcrab 3y agohttps://blog.jooq.org/say-no-to-venn-diagrams-when-explaining-joins/ https://blog.jooq.org/say-no-to-venn-diagrams-when-explainin...
- flir 3y agoHmm. It's true, the set model breaks down when you remove the key relationship, or add filters.