I always see the programmer sentiment that “people should not be using excel for (project). It should be a database.”
I am guessing by that they mean SQL? I dont know a thing about that except the acronym. The most ive done is a basic linux script and 2 hours of a VBA course. I suck at understanding programming, so id like to understand exactly how one uses a database vs excel. Like whay are the actual steps id have to do?
The most simple way to understand this is that databases are made to be proof to failures. When you write a single value into the database a lot of things are happening behind to ensure something called ACID, by other hand, excel documents are a monolith file, doesn’t have a mecanism behind to rely and ensure the integrity of the data.
Edit: changed the link to ACID.