明日から使えるDatabase tools / Fukuoka.php Vol.31 LT

https://github.com/k1LoW/tcpdp と https://github.com/k1LoW/tbls のカジュアルな使い方を紹介しました

Transcript

1. খࢁ݈Ұ࿠
   
   (.0
   1FQBCP
   *OD
   
   'VLVPLBQIQ
   7PM ໌೔͔Β࢖͑Δ
   %BUBCBTF
   UPPMT
2. ϓϦϯγύϧΤϯδχΞ খࢁ݈Ұ࿠
   
   !L-P8 ϗεςΟϯάࣄۀ෦ϗεςΟϯάάϧʔϓϚωʔδυΫϥ΢υνʔϜ IUUQTHJUIVCDPNL-P8 
5. ຊൃදʹग़ͯ͘ΔίϚϯυ͸
   ͭͰ͢
   ͦΕ͚֮ͩ͑Ε͹໌೔͔Β࢖͑·͢
   ˞ίϚϯυ͸NBD04Λ૝ఆ͍ͯ͠·͕͢-JOVYͰ΋ՄೳͰ͢
6. %BUBCBTF
   &OWJSPONFOUT w%#@64&3
   ʜ
   σʔλϕʔεϢʔβ
   w%#@1"44
   ʜ
   σʔλϕʔεϢʔβͷύεϫʔυ
   w%#@)045
   ʜ
   σʔλϕʔεαʔόͷϗετʢ઀ଓઌʣ
   w%#@1035
   ʜ
   σʔλϕʔεαʔόͷ଴ͪड͚ϙʔτ
   w%#@/".&
   ʜ
   σʔλϕʔε໊
7. 8FCΞϓϦέʔγϣϯ͔Β
   σʔλϕʔεʹൃߦ͞Ε͍ͯΔ
   ΫΤϦΛ֬ೝ͍ͨ͠
8. ൃߦ͞ΕΔΫΤϦΛ֬ೝ͢Δํ๏ w -BSBWFMͩͱ
   ʜ
   a%#FOBCMF2VFSZ-PH 
   w $BLF1)1ͩͱ
   ʜ
   a$BLFa%BUBTPVSDFa$POOFDUJPO.BOBHFSHFU EFGBVMU MPH2VFSJFT USVF 
   w 1PTUHSF42-ͷϩάͩͬͨΒ
   ʜ
   MPH@TUBUFNFOU
   
   BMM
   
   w .Z42-ͷϩάͩͬͨΒ
   ʜ
   HFOFSBM@MPH
   w/PEFKTͷ5ZQF03.ͩͬͨΒʁ
   wΦϨΦϨϑϨʔϜϫʔΫͩͬͨΒʁ
   wૉͷ1)1ͩͬͨΒʁ
9. UDQEQ
10. Πϯετʔϧ $ brew install k1LoW/tap/tcpdp
11. w 1PTUHSF42-ͷ৔߹
    w .Z42-ͷ৔߹ ࢖͍ํ $ sudo tcpdp probe -i any -t ${DB_PORT} -d pg —-stdout $ sudo tcpdp probe -i any -t ${DB_PORT} -d mysql —-stdout NBD04ͷ৔߹͸MP΍FOͳͲɺωοτϫʔΫΠϯλʔϑΣʔε໊Λࢦఆ
13. ͜Ε͚ͩʂ
    UDQEQ͕ͲΜͳπʔϧͳͷ͔ͱ͔ɺଞʹԿ͕Ͱ͖Δͷ͔ͱ͔
    ஌Γͨ͘ͳͬͨΒ
    IUUQTUXJUUFSDPNL-P8
    ʹฉ͔͘
    
    IUUQTHJUIVCDPNL-P8UDQEQ
    ΛΈ͍ͯͩ͘͞ʂ
14. σʔλϕʔεͷ
    υΩϡϝϯτΛੜ੒͍ͨ͠
16. Πϯετʔϧ $ brew install k1LoW/tap/tbls
17. w 1PTUHSF42-ͷ৔߹
    w .Z42-ͷ৔߹
    ࢖͍ํ $ tbls doc pg://${DB_USER}:${DB_PASS}@${DB_HOST}:${DB_PORT}/${DB_NAME} $ tbls doc my://${DB_USER}:${DB_PASS}@${DB_HOST}:${DB_PORT}/${DB_NAME}
19. ͜Ε͚ͩʂ
    UCMT͕ͲΜͳπʔϧͳͷ͔ͱ͔ɺαϙʔτ͍ͯ͠Δσʔλϕʔε͸ଞʹԿ͕͋Δͷ͔ͱ͔
    ஌Γͨ͘ͳͬͨΒ
    IUUQTUXJUUFSDPNL-P8
    ʹฉ͔͘
    IUUQTHJUIVCDPNL-P8UCMT
    ΛΈ͍ͯͩ͘͞ʂ
20. 5IBOL
    ZPV ࠷৽ͷ࠾༻৘ใΛνΣοΫˠ !QC@SFDSVJU