I would be grateful to know folks' opinions on the pros and cons of using UUIDs rather than the 'traditional' FM serial numbers for the main id of a record.
Are there any cons? What should we be aware of that maybe we can do with serial numbers that we cannot do with UUIDs, or UUIDs rather than serial numbers?
I admit this may be a no-brainer but I, and may be a few other people out there, would be interested to hear opinions on this. Particularly in the case for converting an 'old' database to using UUIDs rather than existing serial numbers.