An auto incrementing integer (for internal use) and a string (for external) will be enough for the vast majority of use cases, is simple to understand, and works well.
You’re not wrong. This is my preferred method (from a DBRE perspective) if there are concerns about time-based solutions like UUIDv7, and keys must be publicly exposed.
sgarland|1 year ago