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

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

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

69b93af68320a590f607c296e8edff73?s=128

Ken’ichiro Oyama

October 29, 2019
Tweet

Transcript

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

  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@TUBUFNFOUBMM 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. 5IBOLZPV ࠷৽ͷ࠾༻৘ใΛνΣοΫˠ !QC@SFDSVJU