Shop Talk: 2020-11-30

The Recording

The Panelists

  • Kevin Feasel
  • Tom Norman

Notes: Questions and Topics

Announcements

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.

Leave a Reply

Your email address will not be published.