On 2014/04/22 20:06, Dominique Devienne wrote:
Regarding the uniqueness argument made by DRH, it's actually very hard to generate 2 random-based GUIDS, given that a 128-bit is a very very large number. It is said that 128-bit is large enough to store the estimated number of atoms in our galaxy.//
I'm all with you on the idea and you can find the paradox described on the net (it's an actual thing), but my quick interlude here is specific to the statement above about being able to store the estimated number of atoms in the Universe. I think you might be thinking of SHA 256, because that's closer to how many will be needed to accurately store it - current estimates are between 78 and 82 orders of magnitude (that's 1.0E+82) of atoms in the known universe in decimal, which would be around ~1.0 x 2^270 and obviously require around 270 bits to store. Of course Stars are manufacturing (and killing) atoms all the time, so an estimate will have to do!
in case anyone is interested in the actual math: https://www.wolframalpha.com/input/?i=10^82+%3D+2^x Or in the physics: http://www.universetoday.com/36302/atoms-in-the-universe/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users