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

Transcript

1. খࢁ݈Ұ࿠
   
   (.0
   1FQBCP
   *OD
   
   'VLVPLBQIQ
   7PM ໌೔͔Β࢖͑Δ
   %BUBCBTF
   UPPMT

2. ϓϦϯγύϧΤϯδχΞ খࢁ݈Ұ࿠
   
   !L-P8 ϗεςΟϯάࣄۀ෦ϗεςΟϯάάϧʔϓϚωʔδυΫϥ΢υνʔϜ IUUQTHJUIVCDPNL-P8 

3. None
4. None

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ͳͲɺωοτϫʔΫΠϯλʔϑΣʔε໊Λࢦఆ
12. None

13. ͜Ε͚ͩʂ
    UDQEQ͕ͲΜͳπʔϧͳͷ͔ͱ͔ɺଞʹԿ͕Ͱ͖Δͷ͔ͱ͔
    ஌Γͨ͘ͳͬͨΒ
    IUUQTUXJUUFSDPNL-P8
    ʹฉ͔͘
    
    IUUQTHJUIVCDPNL-P8UDQEQ
    ΛΈ͍ͯͩ͘͞ʂ

14. σʔλϕʔεͷ
    υΩϡϝϯτΛੜ੒͍ͨ͠

15. None

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}
18. None

19. ͜Ε͚ͩʂ
    UCMT͕ͲΜͳπʔϧͳͷ͔ͱ͔ɺαϙʔτ͍ͯ͠Δσʔλϕʔε͸ଞʹԿ͕͋Δͷ͔ͱ͔
    ஌Γͨ͘ͳͬͨΒ
    IUUQTUXJUUFSDPNL-P8
    ʹฉ͔͘
    IUUQTHJUIVCDPNL-P8UCMT
    ΛΈ͍ͯͩ͘͞ʂ

20. 5IBOL
    ZPV ࠷৽ͷ࠾༻৘ใΛνΣοΫˠ !QC@SFDSVJU