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

StoredFunctionのすゝめ

Avatar for T. MOTOOKA T. MOTOOKA
February 16, 2025

 StoredFunctionのすゝめ

めぐろLT #24 「データベース」
https://meguro-lt.connpass.com/event/343511/

6ページ目のサンプルコード → https://gist.github.com/motooka/4af3345c21025a5a958142ccee84ab04

Avatar for T. MOTOOKA

T. MOTOOKA

February 16, 2025
Tweet

More Decks by T. MOTOOKA

Other Decks in Technology

Transcript

  1. 4UPSFE'VODUJPO࢖͍Ͳ͜Ζ w %#্ͷσʔλʹབྷΉʢPS42-ΫΤϦͷதʣͷɺ ෳࡶͳॲཧ͕Կ౓΋͋Δͱ͖ w ʢࠓͰ͸ϨΞ͚ͩͲʣ8JOEPX'VODUJPO͕࢖͑ͳ͍؀ڥͰɺ "IBTNBOZ#Ͱʮ࠷৽ͷ#ʯΛऔΔɺΈ͍ͨͳॲཧ ˠʮ/ ໰୊ʯͷҰ෦ɻʮ"ͷJEΛ༩͑ͨΒ࠷৽ͷ#ͷJEΛฦ͢ʯؔ਺Λ࡞Δ w

    ॲཧܥʹΑͬͯࠩҟ͕ग़ͦ͏ͳܭࢉΛશͯ%#ʹͤͯ҆͞ఆԽΛ໨ࢦ͢ ˠුಈখ਺఺਺ͳͲ w $)&$,੍໿Λ؆୯ʹॻ͘ ˞.Z42-͸ແཧ ˞1PTUHSF42-Ͱ͸*..65"#-&͚ͩʹ͠Α͏ɻ45"#-&ؔ਺͸ϦετΞ࣌ʹࢮ͵😇
  2. 4UPSFE'VODUJPO࢖༻ྫ w EBUFΛ༩͑ͯɺͦͷ݄ͷ݄຤೔Λฦ͢ ೿ੜɿͦͷ݄ͷ೔ɺલ݄຤೔ɺͳͲͳͲ w ֹ݄՝ۚͷ೔ׂΓܭࢉ ର৅೥݄ɺܖ໿೔ɺղ໿೔ OVMMBCMF ɺຬֹΛ༩͑ͯɺֹۚΛฦ͢ w

    EBUFΛ༩͑ͯɺফඅ੫཰Λฦ͢ʢUBCMFͰ࣋ͭΑΓ࢖͍қ͍ʂʣ ˞ܰݮ੫཰ͷΑ͏ͳG LJOHͳ࢓༷มߋʹ͸஫ҙ⚠ w ΧλΧφˠ൒֯Ŝūม׵