▲ 458 ▼ Yet another reason to hate on the worse DB in existence (lemmy.ml) submitted 9 months ago by cm0002@mander.xyz to c/programmer_humor@programming.dev 45 comments fedilink hide all child comments
[–] Pat_Riot@lemmy.today 18 points 9 months ago (3 children) Blockchain isn't a Database, and the worst one is AS400. permalink fedilink source parent hideshow 3 child comments replies: [–] Rooster326@programming.dev 12 points 9 months ago* (last edited 8 months ago) (2 children) A400 is at least relational. MongoDB on the other hand... All data is, or will become, relational. permalink fedilink source parent hideshow 2 child comments replies: [–] LeFantome@programming.dev 2 points 8 months ago* (1 child) I am a big SQL fan but not all data has to be relational. Let’s say I want the GPS coordinates of ten million vehicles every 5 seconds. I have a vehicle id, a timestamp, and coordinates. I do not care if a few writes get lost. Why does this have to be relational? And perhaps I also record other info that may change from vehicle to vehicle. Perhaps just values that are true if present. DoorOpen, BrakeApplied, LightsOn, LightBarOn, EngineOn, etc. I may only be displaying this data in a UI. I may get different values from every vehicle or even every write. There is no “schema”. I mean, I can have a JSON field or something in my relational table? But this is not exactly relational anymore. permalink fedilink source parent hideshow 1 child comment replies: [–] Rooster326@programming.dev 4 points 8 months ago Correct not all data has to be relational but it will always eventually become relational. You will at one point want to pair that vehicle id to a vehicle and then again to something else. permalink fedilink source parent
[–] Rooster326@programming.dev 12 points 9 months ago* (last edited 8 months ago) (2 children) A400 is at least relational. MongoDB on the other hand... All data is, or will become, relational. permalink fedilink source parent hideshow 2 child comments replies: [–] LeFantome@programming.dev 2 points 8 months ago* (1 child) I am a big SQL fan but not all data has to be relational. Let’s say I want the GPS coordinates of ten million vehicles every 5 seconds. I have a vehicle id, a timestamp, and coordinates. I do not care if a few writes get lost. Why does this have to be relational? And perhaps I also record other info that may change from vehicle to vehicle. Perhaps just values that are true if present. DoorOpen, BrakeApplied, LightsOn, LightBarOn, EngineOn, etc. I may only be displaying this data in a UI. I may get different values from every vehicle or even every write. There is no “schema”. I mean, I can have a JSON field or something in my relational table? But this is not exactly relational anymore. permalink fedilink source parent hideshow 1 child comment replies: [–] Rooster326@programming.dev 4 points 8 months ago Correct not all data has to be relational but it will always eventually become relational. You will at one point want to pair that vehicle id to a vehicle and then again to something else. permalink fedilink source parent
[–] LeFantome@programming.dev 2 points 8 months ago* (1 child) I am a big SQL fan but not all data has to be relational. Let’s say I want the GPS coordinates of ten million vehicles every 5 seconds. I have a vehicle id, a timestamp, and coordinates. I do not care if a few writes get lost. Why does this have to be relational? And perhaps I also record other info that may change from vehicle to vehicle. Perhaps just values that are true if present. DoorOpen, BrakeApplied, LightsOn, LightBarOn, EngineOn, etc. I may only be displaying this data in a UI. I may get different values from every vehicle or even every write. There is no “schema”. I mean, I can have a JSON field or something in my relational table? But this is not exactly relational anymore. permalink fedilink source parent hideshow 1 child comment replies: [–] Rooster326@programming.dev 4 points 8 months ago Correct not all data has to be relational but it will always eventually become relational. You will at one point want to pair that vehicle id to a vehicle and then again to something else. permalink fedilink source parent
[–] Rooster326@programming.dev 4 points 8 months ago Correct not all data has to be relational but it will always eventually become relational. You will at one point want to pair that vehicle id to a vehicle and then again to something else. permalink fedilink source parent