Auto increment is a terrible idea

Re:Auto increment is a terrible idea by tkyjonathan on Thursday November 30, 2017 @01:42PM (#15818302)

on MySQL or any database that doesn't have it as a datatype, its 36 char on latin charset. If you leave everything as UTF-8, then its x3 that amount.

Try it for yourself.

[ Parent | on HN ]

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:

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...

[ Parent | on HN ]