me: ahh i love technology
my phone: :blobcatpeek:
my laptop: :blobcatpeek:
my raspberry pi: :blobcatpeek:
my PS3 controllers: :blobcatpeek:
my aircon remote: :blobcatpeek:
me: :bsod:

oh but i don't like computer theory

database theory is probably the driest, most dull thing about computing

databases in practice are awful enough

@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.

@a_breakin_glass @lynnesbian That's my theory of what happened, at least. I've not seen any evidence to the contrary yet.

@a_breakin_glass @lynnesbian "largely conspired to make SQL"

should read:

"largely conspired to make SQL a standard."

Sometimes I type too fast.

@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.

@vertigo @a_breakin_glass @lynnesbian you can definitely do this now, at least in sqlite(which is apparently more free-form than most SQL engines)

@popefucker @a_breakin_glass @lynnesbian yep, also in Postgres too. We're planning on expanding our use of this feature as we evolve our API services at work. Also of units support (e.g., not just '5', but '5 cm').

@popefucker @a_breakin_glass @lynnesbian Also, the syntax isn't even consistent between RDBMS implementations, diminishing it's value as a standard at all. Even simple matters as when to use " vs ' in a query seems vendor specific, let alone accepted orderings of keywords, etc.

@a_breakin_glass @lynnesbian

C. J. Date’s “Database in Depth” is one of the best books I’ve read about anything IT, ever.

Subheading is: “Relational theory for practicioners”

It is a _fun_ book

Sign in to participate in the conversation
Lynnestodon

@lynnesbian@fedi.lynnesbian.space's anti-chud pro-skub instance for funtimes