nurkiewicz,
@nurkiewicz@fosstodon.org avatar

#TIL The first 48 bits of UUIDv7 is a timestamp (millisecond precision). This means that:

  • Sorting UUIDs also sorts them by creation order
  • You can easily extract creation time from UUID
  • v7 solves the poor index locality of fully random UUIDs when used as primary/foreign keys
  • All
  • Subscribed
  • Moderated
  • Favorites
  • til
  • ngwrru68w68
  • rosin
  • GTA5RPClips
  • osvaldo12
  • love
  • Youngstown
  • slotface
  • khanakhh
  • everett
  • kavyap
  • mdbf
  • DreamBathrooms
  • thenastyranch
  • magazineikmin
  • megavids
  • InstantRegret
  • normalnudes
  • tacticalgear
  • cubers
  • ethstaker
  • modclub
  • cisconetworking
  • Durango
  • anitta
  • Leos
  • tester
  • provamag3
  • JUstTest
  • All magazines