Hacker News new | ask | show | jobs
by Kamq 1306 days ago
> Takes a lot of space

Wait, did you store them as strings instead of as a native UUID type (or any sort of 128 bit integer type)?
1 comments
Alupis 1306 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.

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