- Kevin Feasel
- Tom Norman
Notes: Questions and Topics
We had one announcement: TriPASS board elections are open until December 3rd. All active TriPASS Meetup members are eligible to vote.
AWS Kinesis Outage
Tom and I talked a bit about another cloud outage: this time, AWS’s Kinesis service went down during Cyber 5. It had some big effects on downstream customers.
Building a Safe Sequence
The majority of this episode is dedicated to building a safe sequence for when you absolutely need contiguous numbers for ID values. Identity and sequence can, by design, leave gaps. 99% of the time (or more), that’s not an issue. But in the rare case where numeric IDs are part of an audit process, I show a technique to eliminate those gaps, though at the cost of slowing down insert performance considerably.
The notebook is part of my upcoming post-con for Data Platform Summit, so I’m not releasing it right now. But I might release a version of it in the future.