I know enough to be useful/dangerous but I have basically no intuition for like, when where or modeling outside of what I've already seen
reality is the battlefield
- she/they (pl)
- breadthcharge.net/
the first line goes in Cohost embeds
🐥 I am not embroiled in any legal battle
🐦 other than battles that are legal 🎮
I speak to the universe and it speaks back, in it's own way.
mastodon
email: contact at breadthcharge dot net
I live on the northeast coast of the US.
'non-functional programmer'. 'far left'.
conceptual midwife.
https://cohost.org/NireBryce/post/4929459-here-s-my-five-minut
If you can see the "show contact info" dropdown below, I follow you. If you want me to, ask and I'll think about it.
You must log in to comment.
in reply to @NireBryce's post:
At what level? Like, start with "what makes a relational database relational, and here are the major pieces of a query language" I actually wrote up for my blog (https://john.colagioia.net/blog/2020/04/05/database.html, in a weird state until I redeploy everything in a few minutes, but still readable), and reading up on "normal forms" would probably go a long way to understanding some weird decisions that you'll see. "Basically what an undergraduate should know," all the textbooks that I've seen are pretty much interchangeable, written in the same pseudo-intellectual language that scrambles to make SQL look like something that falls out of math, rather than admitting that SQL came first...
actually I think I'm realizing my problem is that I sorta need to dig into the history of db evolution or early sql to get why we ended up here, got anything on that progression handy?
Nothing comes to mind, and I now wonder if it even exists, since at least in my head, the history kind of looks like IBM publishes SEQUEL for a database, Codd publishes his article, and everybody reimplements a cleaned-up SEQUEL as SQL that hasn't changed (much) in decades...
i followed this link because i’m interested in the same thing, and this article seems relevant, if a little sparse on info. However, it includes a link to a reddit post that looks like a pretty substantial set of resources to explore.