Re:Extracting timestamp and MAC address from UUIDs
by klodolph on Friday November 07, 2014 @11:51PM
(#8576065)
Or you could just use type 4 UUIDs. We know 64 bits is likely too small, and 128 bits is likely enough. Why bother saving a few bits here and there, if you already have a working solution?
Re:Extracting timestamp and MAC address from UUIDs
by girvo on Saturday November 08, 2014 @01:46AM
(#8576243)
For unique IDs in databases, you want them to have common prefixes such that they are kept in rough time order in the database's backend, otherwise your indexes can end up huge and degrade performance (especially in MySQL, that's where we got bitten by it). That's where Type 1s are great, but of course this article shows a major downside.
Re:Extracting timestamp and MAC address from UUIDs
by zackbloom on Saturday November 08, 2014 @01:06AM
(#8576192)
The example in the post is because full UUIDs are uncomfortably long for URLs, and have more entropy than is necessary for the application in question.
Re:Extracting timestamp and MAC address from UUIDs
by pbbakkum on Friday November 07, 2014 @08:01PM
(#8575574)
We encountered some of these same issues and wrote this library to mitigate them: https://github.com/groupon/locality-uuid.java. I think UUIDs make good unique ids overall, particularly in distributed environments where id generation can't be coordinated, but should be used carefully, as the article notes.
Re:Extracting timestamp and MAC address from UUIDs
by e12e on Saturday November 08, 2014 @12:46AM
(#8576151)
As far as I can tell, neither MySQL, nor MariaDB has a function for generating type 4 UUIDs. It's of course possible to generate the UUIDs on the client side, but then it's not really an alternative to auto-incrementing surrogate keys.
Re:Extracting timestamp and MAC address from UUIDs
by _lce0 on Friday November 07, 2014 @11:12PM
(#8575974)
Why tapping on any text will navigate to another page? I've seen the same before, on blogs using the same theme. Is that to increase hits? It's really annoying for the reader experience!
Re:Extracting timestamp and MAC address from UUIDs
by pmontra on Saturday November 08, 2014 @03:50AM
(#8576381)
That theme has a slide-to-next/prev-post feature. Tapping shouldn't activate it but maybe it's buggy with some browsers. Opera Android doesn't (same engine of Chrome).
(I'm having trouble confirming the veracity of this, since the web is full of citogenesis that links to http://www.zdnet.com/news/tracking-melissas-alter-egos/10197... which isn't super clear, but it's a good story nonetheless.)
http://en.wikipedia.org/wiki/Universally_unique_identifier#V...
This will have an better distribution for when they are used as keys as well.