News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.