News for hackers. Stuff that matters.
Re:SQL is syntactic sugar for relational algebra by bitwize on Saturday March 23, 2024 @03:25AM (#39798141)
Understanding relational algebra helps you write better SQL the way understanding lambda calculus helps you write better JavaScript. The language is warty and but a shadow of the pristine purity underneath, but it gets the job done and the theory guides your reasoning on how to use the language.
Re:SQL is syntactic sugar for relational algebra by lkuty on Saturday March 23, 2024 @05:55AM (#39798703)
In particular, I find the closure property of SQL very helpful and always think in terms of queries gettings tables and producing tables (derived most of the time). https://en.wikipedia.org/wiki/Closure_(mathematics)