Moving Away from UUIDs (2018)
I had a database table where I used UUID as primary key. Big mistake. Haunts us to this day.Not sortable. Takes a lot of space. Table relationships are annoying. Etc.What we do instead is have a secondary UUID key and keep Bigint as primary keys. Then use the UUID column in the external context instead.UUIDs are fine for 99.99999% of the time in your own domain.Don’t expect universal uniqueness across all domains.