News for hackers. Stuff that matters.
Re:Extracting timestamp and MAC address from UUIDs by geofft on Friday November 07, 2014 @08:15PM (#8575606)
There's a story that the creator of 1999's "Melissa" virus was found via a GUID in the Word document that included their MAC address.

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

Re:Extracting timestamp and MAC address from UUIDs by elmin on Friday November 07, 2014 @08:32PM (#8575663)
An alternative that was posted here a week or so ago: https://eager.io/blog/how-long-does-an-id-need-to-be/
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 X-Istence on Friday November 07, 2014 @11:42PM (#8576043)
Why not just use UUID 4:

http://en.wikipedia.org/wiki/Universally_unique_identifier#V...

This will have an better distribution for when they are used as keys as well.

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).
Re:Extracting timestamp and MAC address from UUIDs by X-Istence on Friday November 07, 2014 @11:40PM (#8576038)
I'm not seeing that same issue in Safari.