UUIDは衝突の夢を見るか

Transcript

1. 66*%͸
 িಥͷເΛݟΔ͔ 
   4LJMM
   8FEOFTEBZ
2. ͓·͑ͩΕ΍ w ͍ͩ͠
   w --ͱ͔Α͘ॻ͘Α
   w ࠷ۙ͸͍Μ;ΒΛ͔͍ͬͯ͡·͢
   w ͓ञΛ୔ࢁҿΊΔਓΛਅ݋ʹ୳͍ͯ͠·͢
3. 66*% w ϢχʔΫͳจࣈྻΛಘΔ࣌౳ྑ͘࢖͍ͬͯΔͱࢥ͍ ·͢
   ҎԼྫ 
 GEEDBCBEDE
   w ͲΜͳʹੜ੒ͯ͠΋িಥ͠ͳ͍ͱ͔ɻɻ
   w Ͱ΋ຊ౰ͳΜͰ͔͢Ͷ
4. ͦ΋ͦ΋66*%ͱ͸ w ෼ࢄγεςϜ্Ͱͱ౷཰ແ͠ʹ࡞੒Ͱ͖Δࣝผࢠͱ ͯ͠ઃܭ͞Εͨ
   w όʔδϣϯ͸େผͯͭ͠ଘࡏ
   w ࢓༷͸
   3'$
   
   ͱͯ͠ެ։͞Ε͍ͯΔ
 IUUQTUPPMTJFUGPSHQEGSGDQEG
5. w ࠷ॳͷ੺ࣈͷ෦෼͕όʔδϣϯΛද͍ͯ͠Δ
   w ࠷ޙͷ੺จࣈͷ෦෼͸όϦΞϯτͱݺ͹ΕΔ
 มछͷछྨΛද͍ͯ͠Δ
   w όʔδϣϯ͸/*$ͷ."$ΞυϨεΛ࢖༻ͨ͠Γ
   w όʔδϣϯ͸όʔδϣϯͷҰ෦Λ104*9ͷ6*%΍(*%Ͱஔ͖ ׵͑ͨ΋ͷ
   w όʔδϣϯͱ͸.%΍4)"Ͱੜ੒ͨ͠ϋογϡΛ༻͍ͯ ͍Δ΋ͷͱͳ͍ͬͯΔ GEEDBCBEDE
6. GEEDBCBEDE w զʑ͕ීஈ༻͍͍ͯΔ66*%͸όʔδϣϯ
   w ͦΕʹՃ͑ͯόϦΞϯτͱݺ͹ΕΔจࣈྻ͕ՃΘΔ
   " # ͷ͍ͣΕ͔ʹͳΔ
   w શͯཚ਺ʹΑΔੜ੒
7. GEEDBCBEDE w ্ه66*%͸ਐ਺Ͱܻ
   
   CJU ਐ਺
   w ͔͜͜Βόʔδϣϯ  ͱόϦΞϯτ  ΛҾ ͘ͱɺCJUͷࣗ༝౓͕͋Δ
   w ?
   
   
   º
   ?௨Γ
   
   ͘͢͝ଟ͍
8. ຊ౰ʹিಥ͠ͳ͍ͷʁ w ҙ֎ͱ਺ඦສͱ͔ग़ྗ͢ Δͱ͙͢িಥ͢ΔͷͰ͸ʁ w ͍͘Β
 EFWVSBOEPNͱ͔छʹ ࢖ͬͯͯ΋Ͷ͑ɻɻ
9. ·͋΍ͬͯΈͬ΃ w 66*%Λͻͨ͢Βੜ੒ͯ͠%#ʹ*/4&35
   w ͕࣌ؒڐ͢ݶΓͣͬͱ
10. require 'securerandom' require 'mysql2' client = Mysql2::Client.new(:host => 'localhost', :username => 'root', :password => 'password', :database => 'uuid' ) while true do begin uuid = SecureRandom.uuid client.query("insert into uuid.ruby (`uuid`) values ('#{uuid}')") puts uuid rescue => e p e end end
11. ॏෳνΣοΫ w ੜ੒͞Εͨ66*%શ݅Λ͖࣋ͬͯͯɺ
 ཁૉ਺Χ΢ϯτ
    w VOJRϝιουΛར༻ͯ͠ॏෳഉআ
 ཁૉ਺Χ΢ϯτ
    w ཁૉ਺ʹҧ͍͕͋Ε͹ॏෳ͍ͯ͠Δ͸ͣ ͘͢͝ಥ؏ͳॏෳνΣοΫ
12. ॏෳνΣοΫ ͘͢͝ಥ؏ͳॏෳνΣοΫ puts 'িಥͨ͠Ͱ' if data.count != data.uniq.count
13. ॏෳνΣοΫ ద౰ʹ#PUʹͭͿ΍͔ͤͯ֬ೝͱ͔ͯ͠·ͨ͠
14. ໰୊ൃੜ w ༻ҙ͍ͯͨ͠%#ͷ༰ྔΛ௒͑Δ
    w ૉ௚ʹσΟεΫ͕େ͖͍%#Λ࡞੒Ҡߦ
15. ໰୊ൃੜ w ԯ௒͑ͨ͋ͨΓ͔ΒॏෳνΣοΫͰ͖ͳ͘ͳΔ ͓͍ 
 1$ͷϝϞϦʹ৐Βͳ͍
    w ஞ࣍%#͔ΒಡΈऔͬͯಉҰͷ66*%͕͋Δ͔%#ʹ໰ ͍߹Θͤ͢Δํࣜʹมߋ
16. ໰୊ൃੜ w ,74ʹ͢Ε͹Α͔ͬͨײ
    w ฒྻॲཧग़དྷΔΑ͏ʹ͚ͨ͠ΕͲ΍͸Γ஗͍
 ༻ҙͨ͠%#αʔόʔ͕ශऑͩͬͨ
17. Ͱɺিಥͨ͠ͷʁ w ੜ੒ͨ͠66*%͸ԯສ
    w ԯϨίʔυௐ΂ͨײͩ͡ͱিಥ͠·ͤΜͰͨ͠
18. Ͱɺিಥͨ͠ͷʁ w ଟ෼͠ͳ͍ͱࢥ͏
    w 66*%ͩͱিಥ͠ͳ͍ͷ͔΋͚ͩΕͲɺ୯७ͳIFYͱ͔ ͸Ͳ͏ͳΜͩΖ͏
19. ͓͠·͍