UUID vs INT: What’s Better For Your Primary Key?
📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
There are two common approaches to data types for a primary key: an auto-incrementing integer, or a UUID.
In this video, I'll explain what they are, the different types of UUIDs, the pros and cons of each approach, and demonstrate how to use them in SQL.
⏱ TIMESTAMPS:
00:00 - Auto Incrementing IDs
02:20 - UUID
04:55 - UUID v7
05:52 - ULID and Snowflake ID
06:29 - SQL demonstration
08:13 - Other vendors
🔗 VIDEO LINKS:
SQL script from this video: https://github.com/bbrumm/databasesta...