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

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

Transcript

1. খࢁ݈Ұ࿠(.01FQBCP *OD
   'VLVPLBQIQ7PM
   ໌೔͔Β࢖͑Δ
   %BUBCBTFUPPMT
   

   View Slide

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

   View Slide

3. View Slide

4. View Slide

5. ຊൃදʹग़ͯ͘ΔίϚϯυ͸
   ͭͰ͢
   ͦΕ͚֮ͩ͑Ε͹໌೔͔Β࢖͑·͢
   ˞ίϚϯυ͸NBD04Λ૝ఆ͍ͯ͠·͕͢-JOVYͰ΋ՄೳͰ͢
   

   View Slide

6. %BUBCBTF&OWJSPONFOUT
   w%#@64&3ʜσʔλϕʔεϢʔβ
   w%#@1"44ʜσʔλϕʔεϢʔβͷύεϫʔυ
   w%#@)045ʜσʔλϕʔεαʔόͷϗετʢ઀ଓઌʣ
   w%#@1035ʜσʔλϕʔεαʔόͷ଴ͪड͚ϙʔτ
   w%#@/".&ʜσʔλϕʔε໊
   

   View Slide

7. 8FCΞϓϦέʔγϣϯ͔Β
   σʔλϕʔεʹൃߦ͞Ε͍ͯΔ
   ΫΤϦΛ֬ೝ͍ͨ͠
   

   View Slide

8. ൃߦ͞ΕΔΫΤϦΛ֬ೝ͢Δํ๏
   w -BSBWFMͩͱʜa%#FOBCMF2VFSZ-PH
   
   w $BLF1)1ͩͱʜa$BLFa%BUBTPVSDFa$POOFDUJPO.BOBHFSHFU EFGBVMU
   MPH2VFSJFT USVF
   
   w 1PTUHSF42-ͷϩάͩͬͨΒʜMPH@TUBUFNFOUBMM
   w .Z42-ͷϩάͩͬͨΒʜHFOFSBM@MPH
   w/PEFKTͷ5ZQF03.ͩͬͨΒʁ
   wΦϨΦϨϑϨʔϜϫʔΫͩͬͨΒʁ
   wૉͷ1)1ͩͬͨΒʁ
   

   View Slide

9. UDQEQ
   

   View Slide

10. Πϯετʔϧ
    $ brew install k1LoW/tap/tcpdp
    

    View Slide

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

    View Slide

12. View Slide

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

    View Slide

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

    View Slide

15. View Slide

16. Πϯετʔϧ
    $ brew install k1LoW/tap/tbls
    

    View Slide

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}
    

    View Slide

18. View Slide

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

    View Slide

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

    View Slide