~/talk

Why UUIDs are Secretly Incredibly Fascinating

Talkat PyCon AU 2024 · 2024-11-22..11-26· [databases]
linkedin:tveastman
slides:none on file

UUIDs are decoded into actual designs not just vague topics: uuid v7 is 48 bits of Unix milliseconds then random bits and is monotonic with clock jitter handling, uuid v6 is v1 with time bits reordered for index locality, uuid v8 is a vendor‑defined 128‑bit layout, uuid v5 deterministically hashes a namespace and name via SHA‑1. Random v4 collisions are astronomically unlikely but real collisions come from bad entropy. Practical advice: store UUIDs as binary/native types in Postgres, prefer v7 for sortable distributed IDs, and avoid 32‑bit primary keys.

AI-written summary · about

  1. 0:00Introduction
  2. 1:28UUIDs in real-world use
  3. 3:14UUIDs in Django & DB keys
  4. 5:00UUID history & limitations
  5. 7:48UUIDv1 structure deep dive
  6. 10:53UUIDv3 & v5 deterministic IDs
  7. 13:25UUIDv4 collision probabilities
  8. 15:15Sequential IDs vs UUIDs
  9. 17:00Twitter & MongoDB ID design
  10. 19:27UUIDv6 & v7 explained
  11. 21:54UUIDv8 & custom IDs
  12. 23:17UUIDs as DB primary keys
  13. 26:10Storing UUIDs best practices
  14. 27:36Inventing custom UUID variants
  15. 27:56Final advice on primary keys
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.