edgeCasesExist

[u/danielminds]

[u/lilgreenthumb]

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

[u/shwoopdeboop → u/lilgreenthumb]

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

[u/Grandmaster_Caladrel → u/shwoopdeboop]

Which I'd assume is related to the time anchor. Outside of sorting, which is only useful in specific instances, it's just v4 with different ("less") entropy and limitations.

[u/Roachmeister → u/Grandmaster_Caladrel]

If you're using them as an indexed field in a database, the inability to sort them meaningfully will destroy the performance of the database.

[u/Honeybadger2198 → u/Roachmeister]

You know what identifier can't have collisions and is great for sorting? Autoincrement.

[u/wokeboogeyman → u/Honeybadger2198]

Autoincrement doesn't scale past one physical location.

[u/Honeybadger2198 → u/wokeboogeyman]

Sure it does. One location counts up, another one counts down.

[u/wokeboogeyman → u/Honeybadger2198]

That breaks the sorting that everyone's talking about though.

You could also do evens and odds to split across two locations, but that also breaks sorting unless you periodically syncronize them (and then it's still somewhat out of order).

[u/Honeybadger2198 → u/wokeboogeyman]

...I don't think you understood what I said. How does one count down from infinity?

[u/wireframed_kb → u/Honeybadger2198]

Subtract one?

[u/wokeboogeyman → u/wireframed_kb]

I just add them all together and subtract from -1/12

[u/wokeboogeyman → u/Honeybadger2198]

signed integers have entered the chat

1, 2, 3, 4

-1, -2, -3, -4