News for hackers. Stuff that matters.
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.