If we choose to use/add UUIDs, which ones should we choose?.Turns out the question of which identifier (and in this case, UUID) to use is complicated - we're going to dive into some of the complexity and inherent trade-offs, and figure things out: Sometimes it makes sense to use a “natural key” (like an email column in a users table) and sometimes it's better to use a “ surrogate key”, a value made for the purpose of identifying a row (and has no other meaning).Īt first glance, the question of which primary key to use is easy! Just throw a integer/ serial on there, right? Numeric IDs are cool, but what about random value IDs or Universally Unique IDentifiers (UUIDs)? The job of a database is to archive and recall data and you're going to have a hard time finding data without a good primary key or a good index.
They uniquely identify rows of data in tables, and make it easy to fetch data.
0 kommentar(er)
