Re:Auto increment is a terrible idea
by jasode on Thursday November 30, 2017 @03:06PM
(#15819018)
I didn't downvote your previous comment but I'm guessing it got downvotes because the blog post you're criticizing is about PostgreSQL not MySQL. PostgreSQL can store UUID in 16 bytes.
As a side comment about MySQL, there are various techniques to store UUID more compactly as 16 bytes inside of a "binary(16)" type like this:
As a side comment about MySQL, there are various techniques to store UUID more compactly as 16 bytes inside of a "binary(16)" type like this:
https://stackoverflow.com/a/28252188
... or similar technique shown at the bottom of the Percona blog:
https://www.percona.com/blog/2014/12/19/store-uuid-optimized...