News for hackers. Stuff that matters.
Re:The UX of UUIDs by perfectspiral on Friday April 12, 2024 @07:07AM (#40011262)
How do you know it would have worked out better with UUIDs? Did you load test it? What's the size of your dataset?
Re:The UX of UUIDs by bruce511 on Friday April 12, 2024 @06:33PM (#40018357)
With bigint primary keys the process starts either taking the old site offline, and ends with bringing the new site online.

In-between is a non-trivial renumbering step, which takes measurable time that invalidates all existing backups.

By contrast uuid based databases do not need this step, and all existing data (some steady distributed, some in backups etc) remain valid.