UUIDs are a pretty easy choice to use in your database. Apparently there are 2 problems with 'em though, so I put 3.000.000 rows into a database to find out.

-- links
blog post: https://planetscale.com/blog/the-problem-with-using-a-uuid-primary-key-in-mysql

-- my links
second channel (in depth videos): https://www.youtube.com/@Joshtriedupstash
newletter: https://www.joshtriedcoding.com/
discord: https://discord.gg/4vCRMyzgA5
github: https://github.com/joschan21

RumNCode

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

The post discusses the problems with using UUIDs as primary keys in a database. Problem number one is the insert performance, while problem number two is the higher storage utilization.

The Problem With UUIDs