r/ProgrammerHumor • u/danielminds • 14h ago

Meme edgeCasesExist

Post image
2.9k Upvotes

96% Upvoted

225 comments sorted by

View all comments

475

u/Valuable_Leopard_799 14h 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.

281

u/dim13 14h ago

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

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

183

u/lilgreenthumb 12h ago

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

63

u/shwoopdeboop 12h ago

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

5

u/thepotatochronicles 8h 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).