Upgrade to Pro — share decks privately, control downloads, hide ads and more …

わかる!StripeSigma

 わかる!StripeSigma

今世紀最高のStripe専用SQLクエリIDEであるStripe Sigmaのご紹介です。

Hiroki Akiyama

August 06, 2018
Tweet

More Decks by Hiroki Akiyama

Other Decks in Business

Transcript

  1. Θ͔Δʂ
    Ξπ͍ʂ4USJQF4JHNB
    /PUB *OD
    71PG&OHJOFFSJOH
    ळࢁതل

    View Slide

  2. ΞδΣϯμ
    w ࢲͱ4USJQF4JHNBʢࣗݾ঺հͱಋೖܦҢʣ
    w 4USJQF4JHNBͱ͸ʁ
    w ϝϦοτͱ஫ҙࣄ߲
    w ͓͢͢Ίͷ࢖͍ํ
    w ͓౔࢈

    View Slide

  3. ࢲͱ4USJQF4JHNB

    View Slide

  4. ࣗݾ঺հ
    w ळࢁതل
    w ɹ!BLJSPPN
    w ӊؙࠓग़઒ʹ͋Δ/PUB *ODͱ͍͏ձࣾͰ

    71PG&OHJOFFSJOHΛ͍ͯ͠·͢
    w ։ൃνʔϜΛϚωδϝϯτ͠ͳ͕Β

    ίʔυॻ͍ͯ·͢

    View Slide

  5. /PUB *OD
    w ӊؙࠓग़઒ͷΦϑΟεͷ༷ࢠ
    w ࣗ༝౓͕ߴ͍ձࣾɺՈͰ࡞ۀ͢Δਓ͕ଟ͍
    w

    View Slide

  6. /PUB *OD
    w ,#4ژ౎,ZP#J[9ͷऔࡐΛड͚ͨ࣌ͷ༷ࢠ
    w ϑϧϦϞʔτ0,ͷձࣾͳͷͰଞϝϯόʔଟ਺

    View Slide

  7. (ZB[P
    w εΫϦʔϯγϣοτڞ༗αʔϏε
    w ࠷େͷϥΠόϧ͸1SJOU4DSFFOΩʔ
    w ແྉͰར༻Մೳɾֹ݄՝ۚΞϦ
    ສ."6
    ݄ؒ ສ6QMPBE
    ւ֎Ϣʔβʔׂ

    View Slide

  8. (ZB[Pͷܾࡁ
    w 4USJQFͱ1BZQBMΛซ༻
    w ͭͷܾࡁϓϥοτϑΥʔϜͷϥούʔͱͳΔ

    ಺෦αʔϏε&TDBSHPU

    View Slide

  9. (ZB[Pͷ։ൃ
    w ϑϧλΠϜͷΤϯδχΞ͕ਓ
    w ΞϧόΠτˍۀ຿ҕୗͷਓ͕ਓ
    w ਓख͕଍Γͳ͍ʂ

    View Slide

  10. ਓख͕଍Γͳ͍‛
    w ػೳ։ൃɾόάमਖ਼ͰΧπΧπ
    w ूܭج൫ͷ੔උ·Ͱख͕ճΒͳ͍
    w ͕ɺࣄۀղ૾౓͸্͍͛ͨ
    w „
    w ೰Ή

    View Slide

  11. ೰ΜͰ͍Δ࣌ʹݟ͚ͭͨ8FCϖʔδ͕ʜ

    View Slide

  12. View Slide

  13. Ҏ্͕4USJQF4JHNBͱͷग़ձ͍Ͱ͢

    View Slide

  14. 4USJQF4JHNBͷ঺հ

    View Slide

  15. 4USJQF4JHNBͱ͸ʁ
    w ͍͖ͳΓ
    w 8FC্ͷ*%&Ͱ
    w 42-Λ࢖ͬͯ
    w 4USJQFͷσʔλΛूܭͰ͖Δ

    View Slide

  16. 4USJQF4JHNBͱ͸ʁ
    w ͍͖ͳΓ
    w 8FC্ͷ*%&Ͱ
    w 42-Λ࢖ͬͯ
    w 4USJQFͷσʔλΛूܭͰ͖Δ

    View Slide

  17. ͍͖ͳΓ4USJQF4JHNB
    w ɹɹɹɹɹɹɹΫϦοΫͰແྉτϥΠΞϧ։࢝
    w ϚΠάϨʔγϣϯ͸ෆཁ
    w લ݄ͷܾࡁճ਺Ͱྉ͕ܾۚ·Δ

    View Slide

  18. 4USJQF4JHNBͱ͸ʁ
    w ͍͖ͳΓ
    w 8FC্ͷ*%&Ͱ
    w 42-Λ࢖ͬͯ
    w 4USJQFͷσʔλΛूܭͰ͖Δ

    View Slide

  19. 8FC্ͷ*%&
    w ϒϥ΢βͰར༻Մೳ
    w ׬੒౓͕ΊͪΌͪ͘Όߴ͍
    w σϞ͠·͢

    View Slide

  20. σϞ͠·͢

    View Slide

  21. View Slide

  22. ಈը

    View Slide

  23. View Slide

  24. View Slide

  25. 4USJQF4JHNBͱ͸ʁ
    w ͍͖ͳΓ
    w 8FC্ͷ*%&Ͱ
    w 42-Λ࢖ͬͯ
    w 4USJQFͷσʔλΛूܭͰ͖Δ

    View Slide

  26. 42-
    w ͓ͦΒ͘1SFTUP͕࢖ΘΕ͍ͯΔ
    w 4USJQFެࣜυΩϡϝϯτʹ͸1SFTUPͱ͸ॻ͔Ε
    ͍ͯͳ͍
    w 4USJQF4JHNBVTFTTUBOEBSE"/4*42-
    BOEBCSPBESBOHFPGSFQPSUJOHGVODUJPOT

    View Slide

  27. View Slide

  28. View Slide

  29. 1SFTUPͱ͸
    w 'BDFCPPL͕ެ։͍ͯ͠Δ044
    w ෼ࢄ42-ΫΤϦΤϯδϯ
    w จ๏͸ඪ४తͳ42-
    w 4USJQF͕ཪଆΛશ෦΍ͬͯ͘ΕΔͷͰɺ

    զʑΤϯυϢʔβʔ͸

    1SFTUPͷ͜ͱ͸๨ΕͯΑ͍

    View Slide

  30. 8IBU`T4USJQF4JHNB
    w ͍͖ͳΓ
    w 8FC্ͷ*%&Ͱ
    w 42-Λ࢖ͬͯ
    w 4USJQFͷσʔλΛूܭͰ͖Δ

    View Slide

  31. ϝϦοτˍ஫ҙࣄ߲

    View Slide

  32. ϝϦοτ
    w ԿճϦΫΤετൃߦͯ͠΋ಉҰྉۚͳͷͰؾܰʹ
    ࢖͑Δ
    w ࣮ߦ݁ՌΛͦͷ৔Ͱ֬ೝͰ͖Δʢ$47΋Մʣ
    w 3FBEݖݶͷΈͳͷͰɺ։ൃνʔϜҎ֎ͷਓʹ

    ݖݶΛ౉ͤΔʢ%#յΕͳ͍ʣ
    w ఆظ࣮ߦͷ݁ՌΛ8FC)PPLʹ౤͛ΒΕΔ

    %BJMZ 8FFLMZ .POUIMZ

    View Slide

  33. ஫ҙࣄ߲
    w 4USJQF4JHNBEPFTOPUJNNFEJBUFMZSFqFDUZPVS
    BDDPVOU`TNPTUSFDFOUUSBOTBDUJPOTBTBEEJUJPOBM
    QSPDFTTJOHUJNFŠVQUPUISFFEBZTŠJT
    SFRVJSFEUPNBLFUIJTEBUBBWBJMBCMFUPRVFSZ5IF
    JOUFSGBDFJOUIF%BTICPBSEEJTQMBZTUIFEBUFBOEUJNF
    UIBUEBUBXBTMBTUVQEBUFEʢ%BUBGSFTIOFTTΑΓʣ
    w લॲཧʹ೔͔͔ؒΔ
    w ϚϯεϦʔϨϙʔτ͸ຖ݄ ೔͋ͨΓʹ࣮ߦ͢ΔΑ͏ઃఆ

    View Slide

  34. ͓͢͢Ίͷ࢖͍ํ

    View Slide

  35. ͓͢͢Ίͷ࢖͍ํ
    w ूܭ༻ͷ42-ΫΤϦ͕ॻ͚ͨΒɹɹɹϘλϯͰ

    ఆظ࣮ߦΛઃఆ
    w 8FC)PPLઌʹ(PPHMF4QSFBETIFFUΛࢦఆ
    w 4USJQF4JHNBͰେ·͔ͳूܭΛ͠ɺ

    (PPHMF4QSFBETIFFUͰࡉ͔͍ूܭΛ͢Δ
    4USJQF
    4JHNB
    (PPHMF
    4QSFBETIFFU
    4DIFEVMFE
    8FCIPPL

    View Slide

  36. ஫ɿද͍ࣔͯ͠Δ਺ࣈ͸શͯཚ਺Ͱ͢

    View Slide

  37. /PUB *OD
    71PG&OHJOFFSJOH
    ळࢁതل
    !BLJSPPN

    View Slide