Moving Away from UUIDs (2018)
I had a database table where I used UUID as primary key. Big mistake. Haunts us to this day.<p>Not sortable. Takes a lot of space. Table relationships are annoying. Etc.<p>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.<p>UUIDs are fine for 99.99999% of the time in your own domain.<p>Don’t expect universal uniqueness across all domains.