i love computers in theory
@lynnesbian database theory > practice
database theory: elegant
database practice: a mess
@a_breakin_glass @lynnesbian And that mess is largely because of Oracle, the world's first dedicated database as a product company. Oracle and IBM largely conspired to make SQL, which is arguably the **worst** thing you can do to express relational operations and queries. While the intent was good, it's pretty obvious they just took Codd's ideas and run them over with a steam roller.
@popefucker @a_breakin_glass @lynnesbian SQL is a conceptually great idea. However, it has a deeply nonlinear complexity curve. For simple queries, it's obvious. For complex queries, it quickly becomes burdensome to manage as a developer.
For the longest time, SQL also would not allow you to pass structures as values to be stored in a table. I think this has been resolved recently, though again, it is clunky.
@firstname.lastname@example.org's anti-chud pro-skub instance for funtimes