[PhasmaFelis]

> 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.

[swiftcoder]

What do you mean, VARCHAR(8) is a perfectly valid way of storing counters...

[ineedasername]

much better to future proof it by using a BLOB. You know, just in case you ever need to shove something else in there.

[AdamJacobMuller]

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.

[oneplane]

Nah, describe it using some custom binary format and have a 1000 page spec to document it!

[justinclift]

Yay, seralised bluetooth! ;)

[dharmab]

Allocating pieces of a resource without accounting for reusing released resources?

[MacroChip]

Great question. Maybe they did pick a sensible constant, but it still wasn't enough. I.e. INT_MAX wasn't big enough.