tanukistack ライブコーディング / tanukistack live-coding

湘.なんか #2

## related

* https://github.com/mackee/template-tanukistack
* https://aquaproj.github.io/
* https://github.com/go-task/task
* https://github.com/mackee/tanukirpc
* https://github.com/mackee/go-sqlla

Transcript

1. tanukistack ϥΠϒίʔσΟϯά ভ.ͳΜ͔ #2 @macopy
2. ୭ʁ macopy GitHub: mackee X: mackee_w, mixi2: macopy ໘ന๏ਓΧϠοΫ άϧʔϓ৘ใ෦ όοΫΤϯυ, SRE, ΞʔΩςΫτ ୅ද࡞: sqlla(ORM), tanukirpc(WAF)
3. ࠓ೔΍Δ͜ͱ • ϥΠϒίʔσΟϯά • ओʹtanukistack(tanukirpc + sqlla)ʹ͍ͭͯ • ͦͷଞ࠷ۙ࢖͍ͬͯΔπʔϧ(aqua, go-task)ͳͲ΋ղઆ • Ͱ͖Ε͹pgvectorΛ࢖ͬͨϕΫτϧݕࡧ·Ͱ΍Γ͍ͨ • sqlla v2.99.0-rc1ͷ໨ۄػೳͳͷͰ
4. ͓୊: ϝϞாΞϓϦ • MarkdownͰॻ͚Δ • ग़དྷΔ͜ͱ • ৽ن࡞੒ • Ϧετදࣔ • ߋ৽ • ݕࡧ
5. ϨΪϡϨʔγϣϯ • ϑϩϯτΤϯυ͸ϞοΫσʔλͰಈ࡞͍ͯ͠Δঢ়ଶ • ·ͬ͞Β͔Βελʔτ • ͱݴ͍ͭͭɺgonewΛ࢖ͬͯtanukistackςϯϓϨʔτΛҾͬுͬͯ ͖·͢ • DB͸PostgreSQLͰ͢ • PgରԠ͸sqlla v2.99.0-rc1ͷ໨ۄػೳͳͷͰ(2ճ໨)
6. tanukistack • https://github.com/mackee/template-tanukistack • (ݱঢ়͸)ϓϩδΣΫτςϯϓϨʔτ • gonewͰҾͬு͖ͬͯ·͢
7. aqua • https://aquaproj.github.io/ • πʔϧͷόʔδϣϯϚωʔδϟʔ • ϏϧυࡁΈόΠφϦΛམͱ͖ͯͯ͠ల։͖ͯͯ͠$PATHʹೖΕΔ͜ ͱʹಛԽ͍ͯ͠Δ • ࠷ۙ͸Goͱ͔Bun΋͜ΕͰ؅ཧ͍ͯ͠·͢ • ࠓճ͸go-task΋؅ཧԼʹೖΕΔ
8. go-task/task • https://github.com/go-task/task • YAMLͰॻ͚ΔλεΫϥϯφʔ • Make fi leΑΓ໌ྎ(ݸਓͷҙݟͰ͢) • ࠓճ͸devαʔόʔ্ཱͪ͛ͱςετ࣮ߦʹར༻
9. go tool • Go1.24(2/11ϦϦʔε!!)Ͱ࢖͑ΔΑ͏ʹͳͬͨػೳ • ϥΠϒϥϦͰ͸ͳ͘ಠཱͨ͠ίϚϯυΛόʔδϣϯ؅ཧग़དྷΔΑ͏ʹ ͳΔ
10. tanukirpc • https://github.com/mackee/tanukirpc • ϧʔλʔ/WebΞϓϦέʔγϣϯϑϨʔϜϫʔΫ • Request/ResponseΛstructͰఆٛͯ͠ϋϯυϥʔͷҾ਺ʹ͓ͯ͘͠ ͱɺϑϨʔϜϫʔΫଆͰΤϯίʔυ/σίʔυΛ΍Δ • `validate`λάΛstruct fi eldʹॻ͘ͱόϦσʔγϣϯ΋ߦ͍·͢
12. tanukirpcͷTypeScriptΫϥΠΞϯτॻ͖ग़͠ • routerʹొ࿥͞Ε͍ͯΔΤϯυϙΠϯτͷRequest/ResponseΛܕఆ ٛʹ૊ΈࠐΜͩΫϥΠΞϯτΛੜ੒͢Δ
13. tanukiup • tanukirpcઐ༻ͷϗοτϦϩʔυ͘Μ • ໨ۄػೳͱͯ͠͸αʔόʔ࣮૷͞Ε͍ͯΔAPIύεҎ֎Λผͷαʔ όʔʹϦόʔεϓϩΩγ͢Δػೳ => ϗοτϦϩʔυ͕ޮ͘ UBOVLJSQD UBOVLJVQ WJUF
    EFW
    TFSWFS
    FUDʜ ϒϥ΢β API ͦͷଞ
14. sqlla • Go structͰఆٛͨ͠DBεΩʔϚ͔ΒΫΤϦϏϧμʔ΍ϚούʔͳͲ Λίʔυੜ੒͢ΔλΠϓͷORM • v2.99.0-rc1ͷ໨ۄػೳ • PostgreSQLରԠ pgvector΋ѻ͑ΔΑʂ • ϓϥάΠϯ
15. sqllaͷΫΤϦͷྫ
16. sqllaͷϓϥάΠϯػೳ • `//sqlla:plugin <plugin name> [plugin args…]` Ͱࢦఆ • sqlla͕༻͍Δ੩తղੳ+ίʔυੜ੒ػೳΛ࢖ͬͨςϯϓϨʔτʹΑΔίʔυੜ੒͕ಈ͘ • ૊ΈࠐΈpluginͷྫ • `table`: Data Access ObjectΛੜ੒ Insert/Bulk InsertΛߦ͏CreateϝιουͳͲ͕ੜ ͑Δ • `slice`: `type Articles []*Article` ͷΑ͏ͳܕΛఆٛ͠ɺ`IDS`ͷΑ͏ͳitem͔Βಛఆͷ ϑΟʔϧυͷΈΛऔΓग़ͨ͠ϝιου΋ੜ੒Ͱ͖Δ
17. ϥΠϒίʔσΟϯάத…
18. ·ͱΊ • tanukistackΛ࢖͏ͱαʔόʔଆϘΠϥʔϓϨʔτίʔυͷهड़Λ࠷খ ݶʹͯ͠ϩδοΫʹूதͯ͠ॻ͚ΔΑʂ • Έͳ͞Μ͍͔͕Ͱ͔ͨ͠ʁ • ײ૝ͳͲΛ͓଴͓ͪͯ͠Γ·͢