Auto increment is a terrible idea

Re:Auto increment is a terrible idea by daigoba66 on Thursday November 30, 2017 @08:32AM (#15815538)

Don’t store UUIDs as strings.

Use the native UUID data type, which only uses 16 bytes (UUIDs are basically just 128 bit integers). That is still double the size of a 64 bit integer, but the trade off is that it can be random and universally unique.

[ Parent | on HN ]

Re:Auto increment is a terrible idea by 33degrees on Thursday November 30, 2017 @10:03AM (#15816227)

... for databases that have a native UUID type. MySQL doesn't, and the choices are either store them as strings or store them as non readable bytes. Not the greatest options.

[ Parent | on HN ]

Re:Auto increment is a terrible idea by dragonwriter on Thursday November 30, 2017 @06:30PM (#15820631)

You can store them as bytes and use a function to convert them to/from a display format (which is what DBs with a built in UUID type do under the covers.)

[ Parent | on HN ]

Re:Auto increment is a terrible idea by 33degrees on Wednesday December 06, 2017 @03:42PM (#15864783)

Yes, and I've done that in the past; it's still somewhat laborious though.

[ Parent | on HN ]