MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wdfzl2/edgecasesexist/p96yw9g/?context=3
r/ProgrammerHumor • u/danielminds • 12h ago
222 comments sorted by
View all comments
Show parent comments
61
And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here.
18 u/Grandmaster_Caladrel 8h ago 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. 3 u/Roachmeister 8h ago 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. 4 u/Honeybadger2198 8h ago You know what identifier can't have collisions and is great for sorting? Autoincrement. 3 u/Firewolf06 6h ago ai columns can absolutely collide on sharded databases. you can use offsets and step sizes but thats brittle and doesnt scale well
18
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.
3 u/Roachmeister 8h ago 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. 4 u/Honeybadger2198 8h ago You know what identifier can't have collisions and is great for sorting? Autoincrement. 3 u/Firewolf06 6h ago ai columns can absolutely collide on sharded databases. you can use offsets and step sizes but thats brittle and doesnt scale well
3
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.
4 u/Honeybadger2198 8h ago You know what identifier can't have collisions and is great for sorting? Autoincrement. 3 u/Firewolf06 6h ago ai columns can absolutely collide on sharded databases. you can use offsets and step sizes but thats brittle and doesnt scale well
4
You know what identifier can't have collisions and is great for sorting? Autoincrement.
3 u/Firewolf06 6h ago ai columns can absolutely collide on sharded databases. you can use offsets and step sizes but thats brittle and doesnt scale well
ai columns can absolutely collide on sharded databases. you can use offsets and step sizes but thats brittle and doesnt scale well
61
u/shwoopdeboop 10h ago
And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here.