tanukistack ϥΠϒίʔσΟϯά ভ.ͳΜ͔ #2 @macopy 

୭ʁ macopy GitHub: mackee X: mackee_w, mixi2: macopy ໘ന๏ਓΧϠοΫ άϧʔϓ৘ใ෦ όοΫΤϯυ, SRE, ΞʔΩςΫτ ୅ද࡞: sqlla(ORM), tanukirpc(WAF) 

ࠓ೔΍Δ͜ͱ • ϥΠϒίʔσΟϯά • ओʹtanukistack(tanukirpc + sqlla)ʹ͍ͭͯ • ͦͷଞ࠷ۙ࢖͍ͬͯΔπʔϧ(aqua, go-task)ͳͲ΋ղઆ • Ͱ͖Ε͹pgvectorΛ࢖ͬͨϕΫτϧݕࡧ·Ͱ΍Γ͍ͨ • sqlla v2.99.0-rc1ͷ໨ۄػೳͳͷͰ 

͓୊: ϝϞாΞϓϦ • MarkdownͰॻ͚Δ • ग़དྷΔ͜ͱ • ৽ن࡞੒ • Ϧετදࣔ • ߋ৽ • ݕࡧ 

ϨΪϡϨʔγϣϯ • ϑϩϯτΤϯυ͸ϞοΫσʔλͰಈ࡞͍ͯ͠Δঢ়ଶ • ·ͬ͞Β͔Βελʔτ • ͱݴ͍ͭͭɺgonewΛ࢖ͬͯtanukistackςϯϓϨʔτΛҾͬுͬͯ ͖·͢ • DB͸PostgreSQLͰ͢ • PgରԠ͸sqlla v2.99.0-rc1ͷ໨ۄػೳͳͷͰ(2ճ໨) 

tanukistack • https://github.com/mackee/template-tanukistack • (ݱঢ়͸)ϓϩδΣΫτςϯϓϨʔτ • gonewͰҾͬு͖ͬͯ·͢ 

aqua • https://aquaproj.github.io/ • πʔϧͷόʔδϣϯϚωʔδϟʔ • ϏϧυࡁΈόΠφϦΛམͱ͖ͯͯ͠ల։͖ͯͯ͠$PATHʹೖΕΔ͜ ͱʹಛԽ͍ͯ͠Δ • ࠷ۙ͸Goͱ͔Bun΋͜ΕͰ؅ཧ͍ͯ͠·͢ • ࠓճ͸go-task΋؅ཧԼʹೖΕΔ 

go-task/task • https://github.com/go-task/task • YAMLͰॻ͚ΔλεΫϥϯφʔ • Make fi leΑΓ໌ྎ(ݸਓͷҙݟͰ͢) • ࠓճ͸devαʔόʔ্ཱͪ͛ͱςετ࣮ߦʹར༻ 

go tool • Go1.24(2/11ϦϦʔε!!)Ͱ࢖͑ΔΑ͏ʹͳͬͨػೳ • ϥΠϒϥϦͰ͸ͳ͘ಠཱͨ͠ίϚϯυΛόʔδϣϯ؅ཧग़དྷΔΑ͏ʹ ͳΔ 

tanukirpc • https://github.com/mackee/tanukirpc • ϧʔλʔ/WebΞϓϦέʔγϣϯϑϨʔϜϫʔΫ • Request/ResponseΛstructͰఆٛͯ͠ϋϯυϥʔͷҾ਺ʹ͓ͯ͘͠ ͱɺϑϨʔϜϫʔΫଆͰΤϯίʔυ/σίʔυΛ΍Δ • `validate`λάΛstruct fi eldʹॻ͘ͱόϦσʔγϣϯ΋ߦ͍·͢ 

No content

tanukirpcͷTypeScriptΫϥΠΞϯτॻ͖ग़͠ • routerʹొ࿥͞Ε͍ͯΔΤϯυϙΠϯτͷRequest/ResponseΛܕఆ ٛʹ૊ΈࠐΜͩΫϥΠΞϯτΛੜ੒͢Δ 

tanukiup • tanukirpcઐ༻ͷϗοτϦϩʔυ͘Μ • ໨ۄػೳͱͯ͠͸αʔόʔ࣮૷͞Ε͍ͯΔAPIύεҎ֎Λผͷαʔ όʔʹϦόʔεϓϩΩγ͢Δػೳ => ϗοτϦϩʔυ͕ޮ͘ UBOVLJSQD UBOVLJVQ WJUF
EFW
TFSWFS
FUDʜ ϒϥ΢β API ͦͷଞ 

sqlla • Go structͰఆٛͨ͠DBεΩʔϚ͔ΒΫΤϦϏϧμʔ΍ϚούʔͳͲ Λίʔυੜ੒͢ΔλΠϓͷORM • v2.99.0-rc1ͷ໨ۄػೳ • PostgreSQLରԠ pgvector΋ѻ͑ΔΑʂ • ϓϥάΠϯ 

sqllaͷΫΤϦͷྫ 

sqllaͷϓϥάΠϯػೳ • `//sqlla:plugin [plugin args…]` Ͱࢦఆ • sqlla͕༻͍Δ੩తղੳ+ίʔυੜ੒ػೳΛ࢖ͬͨςϯϓϨʔτʹΑΔίʔυੜ੒͕ಈ͘ • ૊ΈࠐΈpluginͷྫ • `table`: Data Access ObjectΛੜ੒ Insert/Bulk InsertΛߦ͏CreateϝιουͳͲ͕ੜ ͑Δ • `slice`: `type Articles []*Article` ͷΑ͏ͳܕΛఆٛ͠ɺ`IDS`ͷΑ͏ͳitem͔Βಛఆͷ ϑΟʔϧυͷΈΛऔΓग़ͨ͠ϝιου΋ੜ੒Ͱ͖Δ 

ϥΠϒίʔσΟϯάத… 

·ͱΊ • tanukistackΛ࢖͏ͱαʔόʔଆϘΠϥʔϓϨʔτίʔυͷهड़Λ࠷খ ݶʹͯ͠ϩδοΫʹूதͯ͠ॻ͚ΔΑʂ • Έͳ͞Μ͍͔͕Ͱ͔ͨ͠ʁ • ײ૝ͳͲΛ͓଴͓ͪͯ͠Γ·͢