Storing UUID's in their binary format quickly becomes a PITA for debugging or doing manual queries. Some DB's have functions that can convert to human-readable strings which make this less painful, but it's never going to be as simple as using integer id's.
As with all things, there are tradeoffs that must be considered before building the system.
Re:Moving Away from UUIDs
by sgtfrankieboy on Tuesday November 22, 2022 @10:45AM
(#33706977)
Which DB doesn't support UUID as a type so I can make sure to never use it?
Wait, did you store them as strings instead of as a native UUID type (or any sort of 128 bit integer type)?