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

トランザクションスクリプトは何がダメなのか?

80b7d87c10fcdb6a0cba4f8b69e933bc?s=47 polidog
June 15, 2022

 トランザクションスクリプトは何がダメなのか?

トランザクションスクリプトの何がダメなのか自分なりに考えてみた話をします。

80b7d87c10fcdb6a0cba4f8b69e933bc?s=128

polidog

June 15, 2022
Tweet

More Decks by polidog

Other Decks in Technology

Transcript

  1. !QPMJEPH τϥϯβΫγϣϯεΫϦϓτ͸Կ ͕μϝͳͷ͔ʁ 
 ઃܭφΠτ

  2. ࣗݾ঺հ w !QPMJEPH w ύʔςΟʔϋʔυגࣜձࣾ w 1)1FS 4ZNGPOZ  w

    ଉࢠ͸ࡀϲ݄ɺΊͬͪΌ͔Θ͍͍
  3. IUUQTUXJUUFSDPNQPMJEPHTUBUVT

  4. τϥϯβΫγϣϯεΫϦϓτͷԿ͕μϝͳ ͷ͔ࣗ෼ͳΓʹߟ͑ͯΈͨ࿩Λ͠·͢ɻ

  5. τϥϯβΫγϣϯεΫϦϓτʹ͍ͭͯ ߟ͑ΔΑ͏ʹͳ͖͔͚ͬͨͬ

  6. ͖͔͚ͬ w ύʔτφʔ͞Μ͔Βೲ඼͞Εͨίʔυ͕τϥϯβΫγϣϯεΫϦϓτͩͬͨ w ࢓༷ͷมߋ͕݁ߏ͚͋ͬͨͲɺͦΜͳʹਏ͘ͳ͔ͬͨ 
 ςετ͔ͬ͠Γॻ͔ΕͯΔ͔Βɺਏ͘ͳ͍͚͔ͩ΋͠Εͳ͍͕  w ͔͠΋ಡΈ΍͍͢ɺΘ͔Γ΍͍͢ɺਪ࿦͠΍͍͢ίʔυ

    w τϥϯβΫγϣϯεΫϦϓτͬͯԿ͕ͩΊͳΜ͚ͩͬʁͬͯߟ͑ΔΑ͏ʹͳͬ ͨ
  7. τϥϯβΫγϣϯεΫϦϓτͷ໰ ୊఺

  8. IUUQTIJHBZBTVPIBUFOBCMPHDPNFOUSZ

  9. IUUQTIJHBZBTVPIBUFOBCMPHDPNFOUSZ lτϥϯβΫγϣϯεΫϦϓτ೿͸ɺʮτϥϯβΫγϣϯεΫϦϓτͷํ͕ॻ͘ͷ͕ ؆୯ͩ͠ɺۀ຿ΞϓϦέʔγϣϯʹΦϒδΣΫτࢦ޲͸ɺ΄ͱΜͲඞཁͳ͍ʯͱ ͍͍·͢ɻ ͦΕʹର͠ɺυϝΠϯϞσϧ೿͸ɺʮυϝΠϯϞσϧ͸ΦϒδΣΫτࢦ޲Λੜ͔͢ ͜ͱ͕Ͱ͖ΔͷͰϝϯςφϯεੑ͕ྑ͍ʯͱओு͠·͢ɻz

  10. IUUQTIJHBZBTVPIBUFOBCMPHDPNFOUSZ zࣅͨΑ͏ͳৼΔ෣͍͕ෳ਺ͷαʔϏεʹ෼ࢄ͢Δةݥ͕͋ΔͨΊͰ͢ɻ ͜Ε͸ɺτϥϯβΫγϣϯεΫϦϓτͰϩδοΫ͕ॏෳ͠΍͘͢ͳΔͷͱಉ͡ཧͰ͢ɻ υϝΠϯΦϒδΣΫτ ΤϯςΟςΟ ʹର͢ΔαʔϏεʹׂΓ౰ͯΔͱ͍͏ϧʔϧ͕໌ ֬ͳΒɺطଘͷαʔϏε ΍ΤϯςΟςΟ Λௐ΂Δ͜ͱͰॏෳΛආ͚ΒΕΔ͔ΒͰ ͢ɻz

  11. None
  12. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1 lಛʹ஫ҙ͢΂͖͜ͱ͸ɺτϥϯβΫγϣϯؒͰͷॏෳͷ໰୊Ͱ͋ Δɻ ͭͷτϥϯβΫγϣϯΛॲཧ͢Δ͜ͱ͕ॏཁࣄ߲ͱͳΔͷͰɺ ڞ௨͢ΔͲͷίʔυ΋ॏෳ͠΍͍͢ঢ়گʹͳΔɻz

  13. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1 lΑΓෳࡶͳϏδωευϝΠϯͰ͸ɺυϝΠϯϞσϧͷߏங͕ඞཁ ʹͳΔɻυϝΠϯϞσϧͰ͸ɺ๛෋ͳΦϓγϣϯΛ࢖ͬͯίʔ υΛܗ੒Ͱ͖ΔͷͰɺಡΈ΍͕͢͞૿͢ͱಉ࣌ʹॏෳ΋ݮΒ͢ ࣄ͕Ͱ͖Δz

  14. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1 lυϝΠϯϞσϧ͕࣋ͭՁ஋͸ɺ͍ͬͨΜ׳Εͯ͠·͑͹ɺϩδοΫ͕ෳࡶʹͳͬͯ ΋े෼ʹମܥԽ͞Εͨํ๏ͰରॲͰ͖Δଟ͘ͷٕ๏͕͋Δ͜ͱͰ͋Δɻz lτϥϯβΫγϣϯεΫϦϓτͷ৔߹͸ɺεΫϦϓτͷ৚݅෼ذϩδοΫΛ௥Ճͯ͠ ΞϧΰϦζϜΛ௥Ճ͢Δ͜ͱʹͳΔɻz

  15. τϯϥϯβΫγϣϯεΫϦϓτ͕μϝͳཧ༝ w ίʔυͷॏෳͷ໰୊ w ಡΈ΍͢͞ͷ໰୊ w ֦ுੑͷ໰୊ w ෳࡶੑͷ໰୊

  16. υϝΠϯϞσϧͰղܾͰ͖Δͷ ͔ʁ

  17. υϝΠϯϞσϧͰղܾͰ͖Δͷ͔ʁ w ίʔυͷॏෳͷ໰୊αϒϧʔνϯԽ w ಡΈ΍͢͞ͷ໰୊υϝΠϯϞσϧͷֶशίετ͕ߴ͍ͷʹಡΈ΍͍͢ͱ͍ ͍͍ͬͯͷ͔ʁ w ֦ுੑͷ໰୊૝ఆ಺ͷ֦ு͔͠୲อͰ͖ͳ͍ͷͰ͸ʁ w ෳࡶੑͷ໰୊ෳࡶͳ΋ͷ͸ෳࡶɾίʔυͰղܾ͢Δ໰୊͡Όͳ͍

  18. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1 lෳࡶͰසൟʹมߋ͞ΕΔϏδωεϧʔϧΛ࢖͍ͬͯΔ৔߹ɺΦϒ δΣΫτϞσϧͰରॲ͢Δ͜ͱ͕͋Δɻ ҰํͰɺ؆୯ͳඇψϧνΣοΫͱ̎ͭͷ߹ܭΛܭࢉ͢Δ৔߹ɺτ ϥϯβΫγϣϯεΫϦϓτͷํ͕ద੾Ͱ͋Δz

  19. τϥϯβΫγϣϯεΫϦϓτΛ ࢖͏ͳͬͯ͜ͱͰ͸ͳ͍

  20. IUUQTUXJUUFSDPNTVHJNPUP@LFJTUBUVT

  21. IUUQTUXJUUFSDPNKJLPTUBUVT

  22. ςελϏϦςΟతͳࢦඪͰߟ͑ͨ ΄͏͕͍͍ͷͰ͸ʁ

  23. ·ͱΊ

  24. ·ͱΊ w τϥϯβΫγϣϯεΫϦϓτ͸μϝͰ͸ͳ͍ w ͦ΋ͦ΋τϥϯβΫγϣϯεΫϦϓτWTυϝΠϯϞσϧΈ͍ͨͳߏਤͰߟ͑ Δ΂͖Ͱ͸ͳ͍ w ৽͍͠ࢹ఺͕ඞཁͳͷͰ͸ʁ