News for hackers. Stuff that matters.
Re:FAA says computer failure was caused by 2 contractors who... by krisoft on Saturday January 14, 2023 @04:38PM (#34384408)
> could be implemented as a distributed-consensus database.

Yes it can. That is not the question. The question is why do you think a bog standard, but correctly implemented and administered database could not handle the same?

Imagine the following: the task is to move two wheels of cheese 5 km from A to B. Your proposal is akin to someone comming and suggesting that a suborbital rocket can do the job. And you are right. It can. But so can a Toyota Corolla without breaking a sweat.

So tell me, why should we use a “hypothetical modern crypto-consensus solution” here, with all its complexity, instead of a well understood and bog standard and well implemented database?

Re:FAA says computer failure was caused by 2 contractors who... by gojomo on Saturday January 14, 2023 @11:58PM (#34386843)
Any bog-standard database might work. But if so, curious the FAA hasn't just done that: say, SQLite replicated across many places.

But the centralized team running it could still "fat-finger" it. Any "master DB" system has problems that blockchain-like approaches have definitively solved, allowing progress on valid messages when large portions of the usual maintenance systems have gone down or been compromised.

Re:FAA says computer failure was caused by 2 contractors who... by tjrDL6MjB2Zwwa on Sunday January 15, 2023 @04:41AM (#34388135)
What do you mean might?

Is there a major RDBMS out there that struggles with 150MB of data?

Re:FAA says computer failure was caused by 2 contractors who... by gojomo on Sunday January 15, 2023 @11:56AM (#34390851)
Of course any major RDBMS would have no problem with the data. If the reports here are accurate, you could fit the last 5-20 years of all NOTAM messages into the RAM of a Raspberry Pi running SQLite.

But if that's enough, why hasn't the FAA solved the problem already?

And even a "major RDBMS" is vulnerable to stodgy management leaving design in a state where it's vulnerable to a single central point of failure, where "2 contractors who introduced data errors" (!) can bring it down.

Modern highly-distributed consensus systems are not vulnerable to that. Neither accident nor malice from 2 government contractors could prevent all authorized updates worldwide in a distributed consensus system like Ethereum.

DC & northern Virginia (or wherever the FAA's systems hosted) could even spontaneously disappear into a lava pit and the official consensus set of NOTAMs would continue to update.

Re:FAA says computer failure was caused by 2 contractors who... by tjrDL6MjB2Zwwa on Monday January 16, 2023 @01:42AM (#34397596)
Because this was all standardized back when interoperability meant standard fixed-length data formats that everyone had to understand rather than versioned API's and the inertia of the established file formats is too great.

Hell, if you _really_ wanted to insist on an exchange data format, XML would work just fine.