News for hackers. Stuff that matters.

A comment on Auto increment is a terrible idea. Parent comment

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 ]