Hacker News new | ask | show | jobs
by Alupis 1302 days ago
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.

1 comments

Which DB doesn't support UUID as a type so I can make sure to never use it?
More than you'd think... including the venerable MySQL.