The underground in ActiveRecord::ConnectionAdapters

沖縄Ruby会議02
http://ruby.okinawa/okrk02/

1. "DUJWF3FDPSE
   $POOFDUJPO"EBQUFST
   ͷԼͷੈ
   ք ླྀٿେֶ
   ޻ֶ෦߸ؗ 
   4BU ԭೄ3VCZձٞ 5IF
   VOEFSHSPVOE
   JO
   "3$POOFDUJPO"EBQUFST %JWF
   UP
   UIF
   SBJMTSBJMT
   SFQPTJUPSZ ג
   Ӭ࿨γεςϜϚωδϝϯτ
   ҏ౻
   ߒҰ
   !LPJD
4. ࠓ೔ͷ࿩
8. w %JWF
   UP
   SBJMTSBJMT
   SFQP
   w "3$POOFDUJPO"EBQUFST
   w 0SBDMF
   FOIBODFE
   BEBQUFS
   w 0SBDMF
   XJUI
   3BJMT
    "HFOEB ˞#BTFE
   PO
   3BJMT
   SD
9. Dive to rails/rails
16. AR::ConectionAdapters
17. w "3ͷϞσϧܦ༝Ͱͷݺͼग़͠ʹର͠ ͯɺ3%#.4͝ͱʹཧʹ͔ͳͬͨ42- Λ૊Έཱͯͯฦ͢໾ׂ
    w 3%#.4ͷ࢓༷Λલఏ͢Δɻྫ͑͹ 0SBDMFͩͱۭจࣈͱ/6--Λ۠ผ͠ ͳ͍ɺHἬ͸ࣝผࢠ͕จࣈҎԼ "3$POOFDUJPO"EBQUFST
18. SBJMTSBJMTͷςετͰ஌Δ3%#.4ͷ ࢓༷ʹΑΔৼΔ෣͍ͷҧ͍ DVSSFOU@BEBQUFS
19. rails/rails#29370
20. 
    WT
    OJM
21. Ξμϓλͷࢦఆͱ 3BJMTΛىಈ࣌ͷ ৼΔ෣͍ʹ͍ͭͯ
22. w ͝ଘ஌EBUBCBTFZNMʹࢦఆ͢Δ BEBQUFSͱ͸Կͳͷ͔͍·Ұ౓ $POOFDUJPO"EBQUFSͷબ୒ development: adapter: mysql2 development: adapter: postgresql development: adapter: sqlite3 development: adapter: oracle_enhanced
23. w EBUBCBTFZNMͰࢦఆͨ͠Ξμϓλ͕ SBJMT
    DSBJMT
    TͰཁٻ͞ΕΔἬͷྲྀΕ
    "33BJMUJFJOJUJBMJ[FS
    "3$POOFDUJPO)BOEMJOHFTUBCMJTI@DPOOFDUJ PO
    "3$POOFDUJPO"EBQUFST$POOFDUJPO4QFDJpD BUJPOTQFD FTUBCMJTI@DPOOFDUJPO
24. 
    "33BJMUJFJOJUJBMJ[FS IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSESBJMUJFSC-
25. 
    "3$POOFDUJPO)BOEMJOH
 FTUBCMJTI@DPOOFDUJPO IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@IBOEMJOHSC-
26. 
    "3$POOFDUJPO"EBQUFST
 $POOFDUJPO4QFDJpDBUJPOTQFD IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTDPOOFDUJPO@TQFDJpDBUJPOSC-
27. w EBUBCBTFZNM΁ͷࢦఆBEBQUFS ΛݩʹΞμϓλΛSFRVJSF͢Δ 
    "3$POOFDUJPO"EBQUFST
 $POOFDUJPO4QFDJpDBUJPOTQFD path_to_adapter = "active_record/connection_adapters/#{spec[:adapter]}_adapter" begin require path_to_adapter rescue LoadError => e (snip) end (snip) adapter_method = "#{spec[:adapter]}_connection" IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTDPOOFDUJPO@TQFDJpDBUJPOSC-- SFRVJSF
28. SFRVJSF͞ΕΔ$PSF
    BEBQUFST
29. w EBUBCBTFZNM΁ͷࢦఆBEBQUFS ΛݩʹίωΫγϣϯϝιου໊Λܾఆ 
    "3$POOFDUJPO"EBQUFST
 $POOFDUJPO4QFDJpDBUJPOTQFD path_to_adapter = "active_record/connection_adapters/#{spec[:adapter]}_adapter" begin require path_to_adapter rescue LoadError => e (snip) end (snip) adapter_method = "#{spec[:adapter]}_connection" IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTDPOOFDUJPO@TQFDJpDBUJPOSC-- @DPOOFDUJPO
30. IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTNZTRM@BEBQUFSSC- @DPOOFDUJPO
31. IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTNZTRM@BEBQUFSSC- @DPOOFDUJPO %#
    $MJFOU
32. w 3VCZΦϒδΣΫτܦ༝Ͱ.Z42-Λૢ࡞͢Δ ΫϥΠΞϯτͱͳΔυϥΠό
    (FN require "mysql2" client = Mysql2::Client.new( :host => "localhost", :username => "root" ) results = client.query( "SELECT * FROM users WHERE group=‘githubbers'" ) results.each do |row| puts row["id"] # row[“id”].is_a? Integer if row["dne"] # non-existant hash entry is nil puts row["dne"] end end .ZTRM
    HFN IUUQTHJUIVCDPNCSJBONBSJPNZTRMVTBHF
33. "3ϞσϧͱυϥΠόͷதؒ૚ $POOFDUJPO"EBQUFST
    "CTUSBDU"EBQUFS $POOFDUJPO
    "EBQUFST
    -BZFS "3
    .PEFM
    -BZFS %BUBCBTF
    $MJFOU
    -BZFS ˞ਤྫ͸.Z42-
    Ξμϓλ (FNpMFʹࢦఆ
    ͍ͯ͠Δͷ͸͜Ε $POOFDUJPO"EBQUFST
    "CTUSBDU.ZTRM"EBQUFS $POOFDUJPO"EBQUFST
    .ZTRM"EBQUFS HFN
    NZTRM .Z42- %BUBCBTF
    -BZFS "3
34. "3ϞσϧͱυϥΠόͷதؒ૚ $POOFDUJPO
    "EBQUFST
    -BZFS "3
    .PEFM
    -BZFS %BUBCBTF
    $MJFOU
    -BZFS ˞ਤྫ͸1PTUHSF42-Ξμϓλ (FNpMFʹࢦఆ
    ͍ͯ͠Δͷ͸͜Ε $POOFDUJPO"EBQUFST
    1PTUHSF42-"EBQUFS HFN
    QH 1PTUHSF42- %BUBCBTF
    -BZFS $POOFDUJPO"EBQUFST
    "CTUSBDU"EBQUFS "3
35. "3ϞσϧͱυϥΠόͷதؒ૚ $POOFDUJPO
    "EBQUFST
    -BZFS "3
    .PEFM
    -BZFS %BUBCBTF
    $MJFOU
    -BZFS ˞ਤྫ͸42-JUFΞμϓλ (FNpMFʹࢦఆ
    ͍ͯ͠Δͷ͸͜Ε $POOFDUJPO"EBQUFST
    42-JUF"EBQUFS HFN
    TRMJUF 42-JUF %BUBCBTF
    -BZFS $POOFDUJPO"EBQUFST
    "CTUSBDU"EBQUFS "3
36. w EBUBCBTFZNMʹج͍ͮͨ $POOFDUJPO"EBQUFSTΛ࢖͏
    w $POOFDUJPO"EBQUFSͷઌͷ઀ଓ ͸σʔλϕʔευϥΠόHFNͱͳΔ
    w NZTRM
    QH
    TRMJUFͳͲ "3ͷσʔλϕʔε઀ଓͷߏ଄
37. w SBJMTSBJMTϦϙδτϦͰϝϯςφ ϯε͞Ε͍ͯΔΞμϓλΛࢦ͢
    w ݱࡏ
    .Z42-
    NZTRM
    
    1PTUHSF42-
    
    42-JUF
    ͷͭ
    w 3BJMTͷ$*ϚτϦοΫεʹೖͬͯΔ $PSF
    BEBQUFST
38. w ֎෦(FNͱͯ͠ཁٻ͞ΕΔΞμϓλ
    w 0SBDMF
    w 42-
    4FSWFS
    w 'JSFCJSE
    w FUD
    FUD SE
    QBSUZ
    BEBQUFST
39. w 3BJMTຊମʹόϯυϧ͞Ε͍ͯΔίΞ ΞμϓλҎ֎΋͜͜ͰSFRVJSFͯ͠Δ 
    "3$POOFDUJPO"EBQUFST
 $POOFDUJPO4QFDJpDBUJPOTQFD path_to_adapter = "active_record/connection_adapters/#{spec[:adapter]}_adapter" begin require path_to_adapter rescue LoadError => e (snip) end (snip) adapter_method = "#{spec[:adapter]}_connection" IUUQTHJUIVCDPNSBJMTSBJMTCMPCWSDBDUJWFSFDPSEMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTDPOOFDUJPO@TQFDJpDBUJPOSC-- SFRVJSF ࠶ܝ
42. Oracle enhanced adapter
43. ೥Ҏ߱ͷ։ൃऀ
44. w SBJMTSBJMTʹଘࡏ͍ͯͨ͠ 0SBDMF"EBQUFSͷ֦ு(FN
    w &EHF
    3BJMTʹ௥ਵ͍ͯ͠Δ
    w +%#$Λ࢖ͬͨ઀ଓΛαϙʔτͯ͠Δ
    w ͭ·Γ+3VCZαϙʔτΛ͍ͯ͠Δ 0SBDMF
    FOIBODFE
    BEBQUFS
45. 0$*
    
    +%#$
46. w ੜ੒͢Δ$POOFDUJPOΛৼΓ෼͚͍ͯΔ 0SBDMF&OIBODFE$POOFDUJPO IUUQTHJUIVCDPNSTJNPSBDMFFOIBODFECMPCWSDMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTPSBDMF@FOIBODFEDPOOFDUJPOSC
47. w ৼΓ෼͚ͷλω͸36#:@&/(*/& 03"$-&@&/)"/$&%@$0//&$5*0/ IUUQTHJUIVCDPNSTJNPSBDMFFOIBODFECMPCWSDMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTPSBDMF@FOIBODFEDPOOFDUJPOSC
48. 0$*$POOFDUJPO
    .3* $POOFDUJPO
    "EBQUFST
    -BZFS "3
    .PEFM
    -BZFS %BUBCBTF
    $MJFOU
    -BZFS ˞ਤྫ͸0SBDMF
    FOIBODFE 0SBDMF&OIBODFE
    0$*$POOFDJUPO
    Ͱܨ͍͛ͯΔ $POOFDUJPO"EBQUFST
    0SBDMF&OIBODFE"EBQUFS 0SBDMF %BUBCBTF
    -BZFS (FNpMFʹࢦఆ
    ͍ͯ͠Δͷ͸͜Ε HFN
    SVCZPDJ $POOFDUJPO"EBQUFST
    "CTUSBDU"EBQUFS "3
49. +%#$$POOFDUJPO
    +3VCZ $POOFDUJPO
    "EBQUFST
    -BZFS "3
    .PEFM
    -BZFS %BUBCBTF
    $MJFOU
    -BZFS ˞ਤྫ͸0SBDMF
    FOIBODFE 0SBDMF&OIBODFE
    +%#$$POOFDJUPO
    Ͱܨ͍͛ͯΔ $POOFDUJPO"EBQUFST
    0SBDMF&OIBODFE"EBQUFS 0SBDMF %BUBCBTF
    -BZFS $-"441"5)ʹ +"3Λࢦఆ KBS
    PKECDKBS $POOFDUJPO"EBQUFST
    "CTUSBDU"EBQUFS "3
50. w KSVCZBDUJWFSFDPSEKECDBEBQUFS Ͱ؅ཧ͞Ε͍ͯΔ <ิ଍>0SBDMFҎ֎ͷ+%#$αϙʔτ
51. A development of Oracle enhanced adapter
52. w */%&9ʹؔ͢Δ5"#-&41"$&Λࢦఆ Ͱ͖ΔΑ͏ʹରԠͨ͠
    <>
    w SBJMT
    ECTDIFNBMPBEͷϚϧνΠϯ αʔτʹରԠͨ͠
    <>
    w 3VCZ0$*Λ3VCZ
    ͷ #JH%FDJNBMରԠ
    <SVCZPDJ> ࢥ͍ग़ͷύονબ
53. w */%&9ʹؔ͢Δ5"#-&41"$&Λࢦఆ Ͱ͖ΔΑ͏ʹରԠͨ͠
    <>
    w SBJMT
    ECTDIFNBMPBEͷϚϧνΠϯ αʔτʹରԠͨ͠
    <>
    w 3VCZ0$*Λ3VCZ
    ͷ #JH%FDJNBMରԠ
    <SVCZPDJ> ͸͡ΊͯͷΞμϓλύον
54. rsim/oracle-enhanced#1028
55. w 0SBDMFͰ͸5"#-&41"$&Ͱςʔϒϧ ΍ΠϯσοΫεͷอଘྖҬࢦఆ͕Ͱ͖Δ
    w 0SBDMF
    FOBIBODFE
    BEBQUFSͰ͸ EFGBVMU@UBCMFTQBDFTͰࢦఆՄೳ
    w QSJNBSZ
    LFZʹରͯ͠͏·͘ޮ͔ͳ ͔ͬͨͷͰ௚ͨ͠ 5"#-&41"$&ͷࢦఆ
56. w ౰࣌ࣗ৴͕ͳ͘
    *TTVF
    Ͱ͓࢕͍ खݩʹϞϯΩʔύον͸͋ͬͨ
57. w 54@*/%&9Ͱͳ͘54@%"5"ʹೖͬͯͨ ໰୊΁ͷमਖ਼ύον 0QFO
    B
    13
58. "3.JHSBUJPOͷDSBFUF@UBCMF΁ͷ SE
    QBSUZ
    Ξμϓλ࣮૷΁ͷมߋ தུ ௥Ճ IUUQTHJUIVCDPNSTJNPSBDMFFOIBODFECMPCWSDMJCBDUJWF@SFDPSEDPOOFDUJPO@BEBQUFSTPSBDMF@FOIBODFETDIFNB@TUBUFNFOUTSC-
59. w "-5&3
    */%&9
    
    3&#6*-%
    5"#-&41"$&Λ ࣮ߦ͢ΔϝιουΛఆ͍ٛͯ͠Δ ADSFBUF@UBCMFA͔ΒͷϑοΫ
60. w ϦϙδτϦΛԣஅͨ͠มߋ͕ඞཁͩͬͨ
    $*͕ͱ͓Βͳ͍
61. w 64&34Ͱͳ͘4:45&.ʹอଘ͞Εͯͨ
    w %&'"6-5
    5"#-&
    41"$&ͷมߋ
    w 0SBDMF޲͚ͷSBJMTEFWCPY΁ͷ13 ZBIPOEBSBJMTEFWCPY
62. w 3%#.4΁ͷΞμϓλ։ൃͳͷͰ 3%#.4ʹԠͨ͡։ൃ؀ڥΛ੔උ͢Δ ඞཁ͕͋Δ
    w ZBIPOEBSBJMTEFWCPY͕ 0SBDMF޲͚ͷ։ൃ؀ڥͱͳΔ
    w $*ͱ߹Θͤͯ͜ͷ؀ڥΛ࢖͏ͷ͕ྑ͍ ։ൃ؀ڥ΁ͷ஌ݟΛಘΔ
63. Oracle with Rails 6.0
64. w 3BJMT
    Ҏલ͸ϓϥΠϚϦΩʔ*%ͷ ࠾൪ʹ͍ͭͯ4&26&/$&Ͱ෷͍ग़͞ Ε͍ͯΔ
    w 3BJMT
    Ҏ߱͸0SBDMF
    Dͷ *EFOUJUZ
    $PMVNOΛ࢖͏ํ਑Ͱݕ౼
    w OFYUWBMͱ͍͏1P$ͷϦϒʔτ 1P$
    *EFOUJUZ
65. w 3BJMT
    
    ҎલͷσϑΥϧτ஋͸
    EFGBVMU@TFRVFODF@TUBSU@WBMVF
    
    
    w 3BJMT
    
    ҎޙͷσϑΥϧτ஋͸ EFGBVMU@TFRVFODF@TUBSU@WBMVF
    
    ʹͳΓଞͷΞμϓλͱಉ͡ڍಈʹ $IBOHF
    AEFGBVMU@TFRVFODF@TUBSU@WBMVFA
    GSPN
    
    UP
    
66. w SBJMT
    ECTUSVDUVSFEVNQͷࡍ ʹσϑΥϧτͰ7*&8͕μϯϓ͞Ε ΔΑ͏ʹͳΔ &YUSBDU
    WJFXT
    UP
    EC TUSVDUVSFTRM
    CZ
    EFGBVMU
67. w 0SBDMF͸%"5"#"4&
    -*/,ͱ͍͏ ଞͷ%#ͷσʔλΛҾ͘ػߏ͕͋Γ 3BJMT
    ܥ0SBDMFΞμϓλἬαϙʔτ
    w 3BJMT
    
    Ҏޙ͸3BJMTͷෳ਺%#ର Ԡʹ೚ͤΔ͜ͱʹͳΓػೳ࡟আ͢Δํ ਑
    SBJMTSBJMT΋ࢀর %SPQ
    EBUBCBTF
    MJOL
    TVQQPSU
68. %SPQ
    EBUBCBTF
    MJOL
    TVQQPSU
69. w "3#BTFDPOOFDUJPOUBCMFTͷ ໭Γ஋ʹؚΊͯΔϚςϏϡʔΛ֎͠ςʔ ϒϧͷΈฦ͢Α͏ʹ͢Δ͔Ͳ͏͔ʁ
    w 1PTUHSF42-Ξμϓλʹ͓͚Δಉϝ ιου͕ϚςϏϡʔΛฦ͔͢Ͳ͏͔ʹ ΑΔ
    (JU)VCίϝϯτௐ΂ &YDMVEF
    ANBUFSJBMJ[FE@WJFXTA
    GSPN
    AUBCMFTA
70. w 0SBDMF
    D
    3ҎԼͰ͸ΧϥϜ໊ͳ ͲࣝผࢠʹόΠτҎԼͷ੍ݶ͕͋Δ
    w SBJMTSBJMTͷ"3ͷҰ෦ͷςετ͕ 0SBDMFͰམͪΔ͍ͪཁҼͰ΋͋Δ
    w 0SBDMF
    D
    3Ҏ্͸όΠτ ·Ͱͷ֦ு͞ΕΔ͚ͲͲ͏͢Δʁ -POH
    JEFOUJpFST
    TVQQPSU
71. +3VCZ
    
    +%#$
    TVQQPSUT
    0SBDMF
    D
    PS
    IJHIFS
    1%#
    1MVHHBCMF
    EBUBCBTF
72. Oracle enhanced 6.0 may require Oracle 12c or higher
73. w ਓྨͰ΋ݟ͍ͯΔਓ͕ݶΒΕ͍ͯΔͱ͍͏ $POOFDUJPO"EBQUFSTͷ໾ׂͱߏ੒ͱ ϦϙδτϦͰͷ৔ॴʹ͍ͭͯ࿩͠·ͨ͠
    w "SFMपล͸೉͍͠ͷͰׂѪ͍ͯ͠·͕͢ɺ ͜ͷ͋ͨΓ৮ΕΔͱ͔ͳΓڧ͍ͱࢥ͍·͢
    w LBNJQP͞ΜͱZBIPOEB͞Μ͸͍͢͝ਓ ͓ΘΓʹ