66*%͸
 িಥͷເΛݟΔ͔ 
4LJMM
8FEOFTEBZ 

͓·͑ͩΕ΍ w ͍ͩ͠
w --ͱ͔Α͘ॻ͘Α
w ࠷ۙ͸͍Μ;ΒΛ͔͍ͬͯ͡·͢
w ͓ञΛ୔ࢁҿΊΔਓΛਅ݋ʹ୳͍ͯ͠·͢ 

66*% w ϢχʔΫͳจࣈྻΛಘΔ࣌౳ྑ͘࢖͍ͬͯΔͱࢥ͍ ·͢
ҎԼྫ 
 GEEDBCBEDE
w ͲΜͳʹੜ੒ͯ͠΋িಥ͠ͳ͍ͱ͔ɻɻ
w Ͱ΋ຊ౰ͳΜͰ͔͢Ͷ 

ͦ΋ͦ΋66*%ͱ͸ w ෼ࢄγεςϜ্Ͱͱ౷཰ແ͠ʹ࡞੒Ͱ͖Δࣝผࢠͱ ͯ͠ઃܭ͞Εͨ
w όʔδϣϯ͸େผͯͭ͠ଘࡏ
w ࢓༷͸
3'$

ͱͯ͠ެ։͞Ε͍ͯΔ
 IUUQTUPPMTJFUGPSHQEGSGDQEG 

w ࠷ॳͷ੺ࣈͷ෦෼͕όʔδϣϯΛද͍ͯ͠Δ
w ࠷ޙͷ੺จࣈͷ෦෼͸όϦΞϯτͱݺ͹ΕΔ
 มछͷछྨΛද͍ͯ͠Δ
w όʔδϣϯ͸/*$ͷ."$ΞυϨεΛ࢖༻ͨ͠Γ
w όʔδϣϯ͸όʔδϣϯͷҰ෦Λ104*9ͷ6*%΍(*%Ͱஔ͖ ׵͑ͨ΋ͷ
w όʔδϣϯͱ͸.%΍4)"Ͱੜ੒ͨ͠ϋογϡΛ༻͍ͯ ͍Δ΋ͷͱͳ͍ͬͯΔ GEEDBCBEDE 

GEEDBCBEDE w զʑ͕ීஈ༻͍͍ͯΔ66*%͸όʔδϣϯ
w ͦΕʹՃ͑ͯόϦΞϯτͱݺ͹ΕΔจࣈྻ͕ՃΘΔ
   " # ͷ͍ͣΕ͔ʹͳΔ
w શͯཚ਺ʹΑΔੜ੒ 

GEEDBCBEDE w ্ه66*%͸ਐ਺Ͱܻ

CJU ਐ਺
w ͔͜͜Βόʔδϣϯ  ͱόϦΞϯτ  ΛҾ ͘ͱɺCJUͷࣗ༝౓͕͋Δ
w ?


º
?௨Γ

͘͢͝ଟ͍ 

ຊ౰ʹিಥ͠ͳ͍ͷʁ w ҙ֎ͱ਺ඦສͱ͔ग़ྗ͢ Δͱ͙͢িಥ͢ΔͷͰ͸ʁ w ͍͘Β
 EFWVSBOEPNͱ͔छʹ ࢖ͬͯͯ΋Ͷ͑ɻɻ 

·͋΍ͬͯΈͬ΃ w 66*%Λͻͨ͢Βੜ੒ͯ͠%#ʹ*/4&35
w ͕࣌ؒڐ͢ݶΓͣͬͱ 

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 

ॏෳνΣοΫ w ੜ੒͞Εͨ66*%શ݅Λ͖࣋ͬͯͯɺ
 ཁૉ਺Χ΢ϯτ
w VOJRϝιουΛར༻ͯ͠ॏෳഉআ
 ཁૉ਺Χ΢ϯτ
w ཁૉ਺ʹҧ͍͕͋Ε͹ॏෳ͍ͯ͠Δ͸ͣ ͘͢͝ಥ؏ͳॏෳνΣοΫ 

ॏෳνΣοΫ ͘͢͝ಥ؏ͳॏෳνΣοΫ puts 'িಥͨ͠Ͱ' if data.count != data.uniq.count 

ॏෳνΣοΫ ద౰ʹ#PUʹͭͿ΍͔ͤͯ֬ೝͱ͔ͯ͠·ͨ͠ 

໰୊ൃੜ w ༻ҙ͍ͯͨ͠%#ͷ༰ྔΛ௒͑Δ
w ૉ௚ʹσΟεΫ͕େ͖͍%#Λ࡞੒Ҡߦ 

໰୊ൃੜ w ԯ௒͑ͨ͋ͨΓ͔ΒॏෳνΣοΫͰ͖ͳ͘ͳΔ ͓͍ 
 1$ͷϝϞϦʹ৐Βͳ͍
w ஞ࣍%#͔ΒಡΈऔͬͯಉҰͷ66*%͕͋Δ͔%#ʹ໰ ͍߹Θͤ͢Δํࣜʹมߋ 

໰୊ൃੜ w ,74ʹ͢Ε͹Α͔ͬͨײ
w ฒྻॲཧग़དྷΔΑ͏ʹ͚ͨ͠ΕͲ΍͸Γ஗͍
 ༻ҙͨ͠%#αʔόʔ͕ශऑͩͬͨ 

Ͱɺিಥͨ͠ͷʁ w ੜ੒ͨ͠66*%͸ԯສ
w ԯϨίʔυௐ΂ͨײͩ͡ͱিಥ͠·ͤΜͰͨ͠ 

Ͱɺিಥͨ͠ͷʁ w ଟ෼͠ͳ͍ͱࢥ͏
w 66*%ͩͱিಥ͠ͳ͍ͷ͔΋͚ͩΕͲɺ୯७ͳIFYͱ͔ ͸Ͳ͏ͳΜͩΖ͏ 

͓͠·͍