Re:911 emergency services go down across the US after Centur...
by PhasmaFelis on Friday December 28, 2018 @04:05PM
(#18779407)
> Operated by a systems provider named Intrado, the server kept a running counter of how many calls it had routed to 911 dispatchers around the country. Intrado programmers had set a threshold for how high the counter could go. They picked a number in the millions.
I'm really curious if there's some explanation that makes this sound less catastrophically stupid, particularly the part where they picked a threshold less than INT_MAX.
Re:911 emergency services go down across the US after Centur...
by swiftcoder on Friday December 28, 2018 @04:44PM
(#18779703)
What do you mean, VARCHAR(8) is a perfectly valid way of storing counters...
Re:911 emergency services go down across the US after Centur...
by ineedasername on Friday December 28, 2018 @05:56PM
(#18780161)
much better to future proof it by using a BLOB. You know, just in case you ever need to shove something else in there.
Re:911 emergency services go down across the US after Centur...
by AdamJacobMuller on Friday December 28, 2018 @06:15PM
(#18780268)
if you're going to use a BLOB how can you know the type and how to decode it? Make sure to serialize that data with something like protobuf.
Re:911 emergency services go down across the US after Centur...
by oneplane on Friday December 28, 2018 @07:06PM
(#18780530)
Nah, describe it using some custom binary format and have a 1000 page spec to document it!
Re:911 emergency services go down across the US after Centur...
by justinclift on Friday December 28, 2018 @08:22PM
(#18781024)
Yay, seralised bluetooth! ;)
Source: "The Coming Software Apocalypse" published by The Atlantic (https://www.theatlantic.com/technology/archive/2017/09/savin...)
walrus01 also linked to https://www.fcc.gov/document/april-2014-multistate-911-outag... in another comment.