3 ms·

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 run

by gojomo 4y ago

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.

tjrDL6MjB2Zwwa 4y ago
What do you mean might? Is there a major RDBMS out there that struggles with 150MB of data?
- gojomo 4y ago
  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.
  - tjrDL6MjB2Zwwa 4y ago
    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.

3 ms·

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 run

by gojomo 4y ago

tjrDL6MjB2Zwwa 4y ago
What do you mean might? Is there a major RDBMS out there that struggles with 150MB of data?
- gojomo 4y ago
  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.
  - tjrDL6MjB2Zwwa 4y ago
    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.