See the post on BlueSky: https://bsky.app/profile/provisionalidea.bsky.social/post/3lhujtm2qkc2i
According to many comments, the US government DOES use SQL, and Musk is not understanding much what’s going on.
See the post on BlueSky: https://bsky.app/profile/provisionalidea.bsky.social/post/3lhujtm2qkc2i
According to many comments, the US government DOES use SQL, and Musk is not understanding much what’s going on.
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, wel, relations and constraints.
Imagine you have 2 tables (2 excel sheets) one with people, and one with home ownership. You can set the following constraints: (1) each person shows up only once in the people table. (2) every home owner must refer to an existing person in people table.
When modifying the table contents, the system checks if no constraints 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 get what you say but excel even the 98 version can do duplicate/missing data constraints.
The big difference between the a relational database and a spreadsheet is that “can do” clause in your sentence. In a relational database they MUST have those constraints to be related.
In the Microsoft ecosystem Access is the relational database. Excel is a table manager with fancy features.