The Problem with Using a UUID Primary Key in MySQL

by rareitemon 11/28/2024, 2:44 AMwith 1 comments

by elmerfudon 11/28/2024, 3:52 AM

One approach I didn't see discussed here is storing the UUID across 2 columns as 2 64 bit integers and forming a composite primary key. There's still tradeoffs with this as with all the methods but depending on use case it's viable way to do it.