News for hackers. Stuff that matters.
Re:The problem with invariants is that they change over time by xxs on Tuesday April 23, 2024 @07:14AM (#40130533)
>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.

Re:The problem with invariants is that they change over time by antonyt on Tuesday April 23, 2024 @08:45AM (#40131328)
This is a solved problem. See UUIDv6 and higher.