Comment Comment by eric4smith 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. parent eric4smith 4 years ago
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.