Them: Why not use Google Sheets or MS Excel as a Database?

Me: You are right. Go ahead and use it. Have a nice day.

^ You reach that stage in life where you just don't have any will or power left to fight stupidity. You know what? Forget the fight. It's about keeping my peace. There, I said it.

@nixCraft the thing is we all know using Excel as a DB is very bad.

At least, they can do their stuff by themself, without asking me to help them. Thats is a bit priceles.

I am at a moment in my life I know better how to value my time and set the right priorities.

@nixCraft completely. However, on some of my powerful days, I choose to spend my time fighting stupidity. You know, not recommended to feed the dragon

@nixCraft When I was younger: They are wrong and I feel compelled to let them know.

Me now: I think "Enjoy basking in your wrongness." and go on about my day.

@nixCraft Question 1: Can this become my problem? If not, then why bother?...

Question 2: Are they just naive? Good to ask, if you deal with students for example.

@nixCraft Something that is easy to see when you are a teacher is that educating others is a paid job, so you don't have any obligation to do it for free.
@nixCraft hey i have starded my it career thanks to ms excel dbs.
migrating them was a very good lesson of life and... i bought a car
@nixCraft the financial guys start puking when you tell them excel is evil
@hanscees @nixCraft nah, they start puking when you tell them how long it will take to turn their 'production' Excel program into something both supportable and within regulations :D
@nixCraft Sometimes I feel like some people don't know about sqlite.
@nixCraft Rather than vigorously arguing that your thirteen sheet Excel workbook is not "software" from the perspective of our software quality assurance program, perhaps your effort would be better spent migrating your data into an actual database which can be shared safely, documented, tested, and audited? - signed, safety analyst & SQA person who is very tired of being dragged into these meetings over and over again about the problems caused by a critical piece of our analysis infrastructure being written in Excel.
@nixCraft PM: can you make an excel file with just the hits on allowed traffic through the firewall ?
me: <insert cat grep sed magic here> <wait 5 minutes for the pipeline to execute> there are 8 millions records and they are all deduplicated. Excel is not going to work here.

@nixCraft do you recall this gem? Public Health England lost track of a lot of Covid cases in their reporting because they not only used Excel as their reporting DB, but they used the wrong Excel format.

https://www.bbc.com/news/technology-54423988

Excel: Why using Microsoft's tool caused Covid-19 results to be lost

The decision to use a spreadsheet format that dates back to the 1980s has proved to be unwise.

@nixCraft as a Db, excuse me?
@batunii @nixCraft That happens all the time, yes. In all companies that I've worked on, people used Excel as everything-tools, and notably databases.
@nixCraft
It remind me the first company I worked for back in 2008 that was using MS Access as database system for a critical program. 😬
@nixCraft I agree, don't waste time and energy to explain them how dumb it is, generally, they dont have the tech level to understand. πŸ˜‚
@nixCraft Sorry no Google or MS offices, be relax and use Libreoffice or Openoffice !

@nixCraft

What would be some recommendations for databases?
I'm not in to this stuff (not using it) but just hopped off from a call where people where talking about Excel and it sounded a lot like it would be used as some sort of database.

@nixCraft meanwhile, lets use json to do database... cuz thats sooo much better...
@nixCraft I know a very solid business built on that 😁
@nixCraft i am way behind on this but may I ask what you would advise?