Live data from Hacker News

Formula 1 chief appalled to find team using Excel to manage 20k car parts

arstechnica.com

21–29 of 29 posts

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#22

Can’t wait to see their reaction when they realize just how much of society and commerce is also managed by giant Excel sheets.

And or access databases.

+7 years ago, heard JPM had +20k of those on their networks. I just shiver thinking about that.

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#24
post #9
post #7

At least they weren't using Access.

I've been wondering for 25 years if there has ever been a legitimate use case for this abomination.

In 20 years I've encountered precisely one Access Database that was very well designed, adequately documented, and implemented correctly - meaning people used a single instance on a specific machine, or Remote Desktop Protocol'd into same.

Connecting to an Access database over a network from individual client apps is a recipe for pain as the database file gets locked, so then people start saving "copy of copy of copy USE THIS ONE" versions and you get divergent database backends with no clean way to merge. IME this always happens for business critical Access systems with no backup and documentation at the least convenient time, and suddenly it's IT's problem/fault. Yes you can connect to a SQL Server backend, but then it's IT's problem/fault/responsibility to maintain, and it takes Access out of the "simple enough for business users" domain.

That said, as a rapid app development desktop tool Access can work very well if you know its limitations. It's somewhat surprising MS never made a 365 web-first equivalent, but that's probably because they'd rather charge for Dynamics 365 licenses and Azure SQL hosting.

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#25
post #23
post #21

Earlier quoted context omitted.

I'm not saying I work for a company that does, I'm just asking for a friend. Can you recommend any actual, better alternatives?

Sqllite

With what GUI? It needs to be usable for people considering Excel is a challenge. Honest question.

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#26
post #25
post #23

Earlier quoted context omitted.

Sqllite

With what GUI? It needs to be usable for people considering Excel is a challenge. Honest question.

I know of no easier way to quickly release a very usable gui on top of a standard relational database then Elixir/Phoenix.

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#27

Can’t wait to see their reaction when they realize just how much of society and commerce is also managed by giant Excel sheets.

There are still opportunities for us SWEs even with the advent of chatGPT. Heck, lots of businesses are just an IG page + Google Sheets.

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#28
post #25
post #23

Earlier quoted context omitted.

Sqllite

With what GUI? It needs to be usable for people considering Excel is a challenge. Honest question.

DBeaver has an Excel-ish interface for SQL. The usual rows and columns layout, you can double click a cell to edit it.

You do have to Save to flush the changes to the DB though, and the errors when queries are wrong or whatever are hard to read. Your users will likely be totally unable to grok the errors. I work in IT and it's somewhat difficult for me because of the chain of error handlers (SQL -> Java error type -> Java error -> display to user; there's a lot of Java stuff mixed into your SQL errors).

Re: Formula 1 chief appalled to find team using Excel to manage 20k car parts

#29

Can’t wait to see their reaction when they realize just how much of society and commerce is also managed by giant Excel sheets.

There are still opportunities for us SWEs even with the advent of chatGPT. Heck, lots of businesses are just an IG page + Google Sheets.

Then again, why would those businesses change this highly efficient MO?
Post reply on HN