Navigate Select ESC Close

The Problem With UUIDs

2024-05-07 Science & Technology
218.6k
6.3k
1.0k
Theo - t3․gg
Theo - t3․gg
552.0k subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

THANK YOU PLANETSCALE FOR SPONSORING THIS VIDEO UUID's have a time and place, but I rarely see them used correctly. I've wanted to do this rant for awhile and I'm happy I did because CUID2 is NOT a good option either 🙃 SOURCE https://planetscale.com/blog/the-problem-with-using-a-uuid-primary-key-in-mysql Check out my Twitch, Twitter, Discord more at https://t3.gg S/O Ph4se0n3 for the awesome edit 🙏

Top Comments (10)

@cherubin7th 2024-05-07

I propose v9, it is the same as v4, but instead of a 4 it has a 9. This changes everything.

1.0k 21 replies
@xdaniels13 2024-05-07

Oh I am still waiting on the video about PlanetScale removing the free plan and the cheaper price twice as much as competitors...

794 14 replies
@einrealist 2024-05-07

UUID versions are NOT supposed to replace each other. They are just different implementations that address different problem domains. Once humans become a serious space-faring civilization, we probably need yet another UUID version for problems like time dillation. But such a UUID V99 is not supposed to replace V4, but to complement it. V4 can still be used within certain bounds.

781 35 replies
@flymetothemoon5138 2024-05-09

It's amazing watching somebody talk shit about something he obviously doesn't understand beyond his sponsors blog post

506 16 replies
@eamon-burns 2024-05-09

17:58 Just so you know, "I'm not telling you the difference between them, that's your problem", takes a lot more time to say than "1 byte is 8 bits"

248 14 replies
@rikschaaf 2024-05-07

3:49 To my knowledge, not all versions in UUID should be seen as "the next version". Some are more like variants than versions. That's why both v1 and v4 are still used often. You could say that variant 5 is a new version of variant 3 though, because we now have better hashing algs that might have not been considered in v3. Variant 6 similarly is a new version of v1, where they reordered the date to be sortable (with v7 being a variant of that). You shouldn't think of every new --"version"-- variant being better than the previous, but that they complement each other.

195 7 replies
@danhorus 2024-05-07

This channel does read a lot of blog posts

134 2 replies
@workmad3 2024-05-07

Thinking about the different UUID variants as 'versions' that replace previous versions isn't quite right... the idea is that the different variants are used in different circumstances, so a deterministic variant is useful in some circumstances. Which is why there's a 'variant' number in it, so different variants can be checked differently.

97
@ChrysusTV 2024-05-09

"I spent years researching this to make sure I got it right. Turns out, I don't need to. Here's what my sponsor has to say." Sheeesh, DarkViper's video accurately notes a lot of key issues, like this one. Something always felt off about this channel and getting a different perspective really made things clear for me. This channel really is just regurgitation with, as you admit yourself in the first few seconds, little research.

70 2 replies
@dragons_advocate 2024-05-07

"Planetscale is not very liked atm..." -- "Thank you planetscale for sponsoring this video"

25

Unlock the Data Inside
Turn Videos into Knowledge

  • Get FREE 10/day: transcripts, summaries, chats
  • Chat with videos, export text & PDF
  • $1 free API credit for RAG, chatbots & research

Free forever plan • All features unlocked

App screenshot