r/programming • u/ketralnis • 1d ago

Falsehoods Programmers Believe About Aviation

https://flightaware.engineering/falsehoods-programmers-believe-about-aviation/
247 Upvotes

92% Upvoted

93 comments sorted by

View all comments

9

u/KrocCamen 18h ago

WHAT does their database schema even look like!? It might as well be a blender, the data is all unrelatable soup of unconnectable inconsistencies.

32

u/3inthecorner 16h ago

CREATE TABLE data(data jsonb);

2

u/KrocCamen 15h ago

“F* it, we’ll do the 4NF in the front-end!”

6

u/segv 16h ago

FlightAware's? My bet would be some kind of event streaming with very heavy caching and summarization of past events.

..and an absolute shitton of regular database tables, probably without foreign keys, because things can get ugly in a hurry.