ADVANCED INT->BIGINT CONVERSIONS

It's 2021 and we're still dealing with integer overflow. Just a few months ago I came within 24 hours of watching one of the worlds tech unicorns come to a stop because of a possible overflow problem. In this talk I'll talk about the nature of the problem, why we still see it today, and cover many of the various options to work your way through a pending int overflow. I also talk about some of the more advanced work we did to make sure our bases were covered, and walk through techniques you can use to keep from hitting the wall. As a rough outline, we will cover: - overflow overview - understanding integer overflow - data types vs sequences - techniques for dealing with int overflow - views - triggers - replication - other problems you must consider - longs, signed vals, and other aspects - a rough timeline towards unicorn explosion - testing in prod - ways to avoid the problem - why those ways suck