The issue is with distributed systems where you have multiple actors all needing to insert records with minimal coordination. Using random ids is also very hel

The issue is with distributed systems where you have multiple actors all needing to insert records with minimal coordination. Using random ids is also very helpful when you want to be able to generate records on the client and then sync them to the server later. In either case, it's difficult to know what that sequential primary key should be.