This goes to show that using uuid4 is not a good thing for db tables, but that is what uuid7 was designed for. Also using ROWID or autonumber or whatever built in system the database is using is the best bet. Only use uuid7 if you need distributed inserts and you want the clients to be able to generate their own keys.