>For example, I'm a big fan of surrogate keys and UUIDs, in database design. Why I fully support surrogate keys and versioning, I do not support UUIDs as prima

>For example, I'm a big fan of surrogate keys and UUIDs, in database design. Why I fully support surrogate keys and versioning, I do not support UUIDs as primary keys - they are trivial to generate, not so much to place in B-trees. It's very common to need/process recently added data together, UUID make that much harder as they inherent placement is all over the place w/o any locality. UUIDs are ok/fine as external references, of course.