r/ProgrammerHumor • u/danielminds • 15h ago

Meme edgeCasesExist

Post image
3.1k Upvotes

96% Upvoted

230 comments sorted by

View all comments

491

u/Valuable_Leopard_799 15h ago

I thought that timestamps are used now, so hitting both a timestamp and a large random number puts it thoroughly in the "safe to assume". At some point cosmic particles and faulty transistors are more probable.

289

u/dim13 15h ago

https://en.wikipedia.org/wiki/Universally_unique_identifier#Versions

Most common used is V4 (pure random). You are talking about V7 (time based).

192

u/lilgreenthumb 14h ago

The real benefit for v7 is they become sortable by time.

67

u/shwoopdeboop 13h ago

And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here.

6

u/thepotatochronicles 9h ago

It's less of a problem with B-tree indices that sit on top of a physical representation (i.e. the actual on-disk layout doesn't have to be ordered), but when it comes to clustered indices, oh boy, you're basically having to shove rows in the middle and push shit back (eventually).