• 10 Posts
  • 765 Comments
Joined 4 years ago
cake
Cake day: May 31st, 2020

help-circle

  • I mean, while you’re right, that’s also what would make this funny. If there was genuinely a girl group who went through all this trouble, not for viral videos, but just for the fun of it, that would be absurd, which would make it funny.

    Instead, someone spent 15 minutes typing into an image generator prompt…







  • My experience has been that it makes the perimeter squeaky-clean, but obviously with a finger, you can do some digging. And if you dig deep enough, there’s always going to be mud.

    And also in my experience, this digging doesn’t actually help. You’ve got a great gate down there. If the outside of that gate is clean, you’re clean. Digging out from behind that gate doesn’t do much, because new mud will push up against it pretty soon.










  • Yeah, that is my understanding, too. Otherwise you’d only want to generate them on the database host, as even with NTP there will be small differences. This would kind of defeat the purpose of UUIDs.

    If you’re saying that even without NTP, just by manually setting the time, things will be fine. I mean, maybe. But I’ve seen it far too many times already that some host shows up with 1970-01-01…


  • For others wondering what’s wrong with UUIDv4:

    UUID versions that are not time ordered, such as UUIDv4, have poor database-index locality. This means that new values created in succession are not close to each other in the index; thus, they require inserts to be performed at random locations. The resulting negative performance effects on the common structures used for this (B-tree and its variants) can be dramatic.

    I guess, this means with these new UUIDs, ideally you only create UUIDs on systems that are hooked up to NTP, though I guess, it won’t really be worse than UUIDv4 either way.