this post was submitted on 11 Feb 2025
1089 points (98.8% liked)
Programmer Humor
20460 readers
2684 users here now
Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
Rules
- Keep content in english
- No advertisements
- Posts must be related to programming or programmer topics
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
In the context of this tweet most important differences are:
SQL is a language for querying databases.
Most common used databases are relational databases. With relational databases you can setup, well, relations and constraints.
Imagine you have 2 tables (2 excel sheets) one with people, and one with home ownership. You can set the following constraint: (1) each person shows up only once in the people table. And the following relation: (2) every home owner must refer to an existing person in people table.
When modifying the table contents, the system checks if no constraints or relations are violated.
Excel, just like a badly designed relational databse, would, for example, have no problem with duplicate people, or home ownership referring to non-existant people.
I spent more than I'd like to admit wondering "what the fuck is a wel relation?!"
I get what you say but excel even the 98 version can do duplicate/missing data constraints.