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 🙏

Mubashir Hassan

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

UUIDs are designed to be universally unique but can negatively impact database performance when used as primary keys, especially in MySQL. The post discusses the various versions of UUIDs and their specific use cases, highlighting potential issues such as insert performance and storage utilization. It also explores alternatives like ordered UUIDs, nano IDs, and snowflake IDs to mitigate these concerns and improve efficiency in distributed systems.

The Problem With UUIDs

<p>Thankfully uuid as PK is optimized in the most popular free database technology right. Excuse the elephant in the room 🐘</p>
