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?
For small projects, I’ll use csv files for my data.
It’s much faster for me to prototype concepts in simple text files than designing and building a database.
Once the project matures or scales large enough, I’ve usually reached the point I’m going to rewrite it from scratch “the right way”, so will build a database if it makes sense.
Maybe one in twenty projects reach the point it’s worth moving.