TinyGoで使えるORM sqllaの 紹介とTinyGoで使えるようにするための工夫

Transcript

1. TinyGoͰ࢖͑ΔORM sqllaͷ ঺հͱTinyGoͰ࢖͑ΔΑ͏ʹ ͢ΔͨΊͷ޻෉ Asakusa.go #1 @mackee_w a.k.a

2. ୭ • @mackee_w at Twitter(formally X), @mackee at GitHub •

   ໘ന๏ਓΧϠοΫ (ຊ೔ח૔͔Βདྷ·ͨ͠ʂ) • ISUCON11༏উ • ISUCON12༧બ ग़୊(SQLiteͷ΍ͭͰ͢) • ීஈ͸PerlίϛϡχςΟͰ฻Β͍ͯ͠·͢ ͕࢓ࣄ͸΄ͱΜͲGoͰ͢ • YAPC::Hiroshima͍ͬͯ͏Ξπ͍Πϕϯτ͕དྷ೥݄̎ʹ͋ΔͷͰདྷͯ͘Εʂʂʂ

3. TinyGoΛझຯͷ૊ΈࠐΈϓϩάϥϛϯάͰ࢖ͬ ͍ͯ·͢

4. sqlla ͱ͍͏ORMΛ࡞͍ͬͯ·͢ • ΧϥϜʹରԠ͢Δϝ ιουΛੜ੒ͯ͠ SQLΛGoͷจ๏Ͱॻ ͚ΔΫΤϦϏϧμʔ • re fl

   ectΛ༻͍ͳ͍ ίʔυੜ੒ʹΑΔ structϚοϐϯά ࢓ࣄͰ୲౰͍ͯ͠ΔWebαʔϏεͰࠓ೔΋ݩؾʹಈ͍͍ͯ·͢

5. ࠷ۙ΍ͬͨτʔΫ https://speakerdeck.com/mackee/goxiang-keorm-sqllanoshao-jie-to-joinyaunionwohan- ndakuerinoxi-ifang

6. Cloud fl are D1

7. github.com/syumai/workersͰD1͕࢖͑Δʂ

8. Ͱ͖Ε͹TinyGoͰಈ͔͍ͨ͠ • Of fi cial Go : 6105.21 KiB /

   gzip: 1650.72 KiB • TinyGo: 2215.79 KiB / gzip: 769.47 KiB • Of fi cial Go Compiler൛ͩͱແྉ࿮Ͱ͸ΞοϓϩʔυͰ͖ͳ͍ • ※౰ํ՝͍ۚͯ͠·͢ɻ͓Ұਓ༷misskeyͷϑϩϯτʹஔ͍͍ͯΔ

9. ͱ͍͏͜ͱͰsqllaΛCloud fl are Workers + TinyGoͰಈ͔ͯ͠ΈΔ

10. DBεΩʔϚΛఆٛ

11. DBεΩʔϚΛఆٛ $ go generate ./

12. connectionΛ༻ҙ

13. Chatॻ͖ࠐΈΤϯυϙΠϯτΛ࣮૷

14. Chatॻ͖ࠐΈΤϯυϙΠϯτΛ࣮૷ ͍ͭ΋࢖͍ͬͯΔ github.com/julienschmidt/httprouter ͕࢖͑ͣ ࣗલͰศརwrapperΛ࣮૷͍ͯ͠·͢

15. Ұ୴Ϗϧυ…΋ग़དྷͣ

16. go-sql-driver/mysql΁ͷϥϯλΠϜͷґଘΛ֎͢ • sqlla͸ੜ੒༻ͷίʔυͱϥϯλΠϜͰ࢖͏ίʔυ͕Ұମʹͳ͍ͬͯΔ • ϥϯλΠϜίʔυͷҰ෦Ͱgo-sql-driver/mysqlΛimport͍ͯ͠Δ • mysql.NullTimeΛϚοϐϯά͢Δίʔυ(ޙํޓ׵ͷͨΊ࢒ͯ͋͠Δ) • D1Ͱ͸࢖Θͳ͍ͷͰɺͦ΋ͦ΋ϏϧυλάͰ֎͢ •

    ͦͷଞίʔυੜ੒Ͱ͔͠࢖Θͳ͍ίʔυ͸ϏϧυλάΛ͚ͭΔ

17. go-sql-driver/mysql΁ͷϥϯλΠϜͷґଘΛ֎͢

18. go-sql-driver/mysql΁ͷϥϯλΠϜͷґଘΛ֎͢ ϏϧυͰ͖ΔΑ͏ʹ ͳͬͨʂ

19. ΄ͳදࣔͰ͖Δ Α͏ʹ͠Α͔ʙ

20. ΄ͳදࣔͰ͖Δ Α͏ʹ͠Α͔ʙ !! දࣔ͞Εͳ͍ !!

21. html/templateͰม਺ճ͢ͱ͜ΖͰࢮΜͰ͍Δ • ͜Ε΋͔֬ʹre fl ect࢖͏ͳ͋ • TinyGo͸re fl ect΍socket࢖͏ܥَ͕໳ͳײ͡(ؒҧͬͯͨΒڭ͑ͯ͘ ͍ͩ͞)

    • encoding/json ͸࢖͑Δ

22. ͓ͱͳ͘͠ JSONͰฦ͢ ΤϯυϙΠ ϯτ࡞ͬͯ fetchͰऔΔ Α͏ʹͨ͠

23. ಈ͘Α͏ʹͳΓ·ͨ͠

24. ͦͷଞࠔͬͨ͜ͱ • time.TimeΛͦͷ··insert͠Α͏ͱ͢Δͱࢮ͵ • தͰre fl ect͕࢖ΘΕ͍ͯΔͨΊʁ `panic: ValueOf: invalid

    value` • int64ʹม׵͍ͯ͠Δ • ϩʔΧϧϞʔυͩͱ`time.Now`͕ΊͪΌͪ͘Όڰ͍ͬͯΔ • ʆ2077-07-23 14:29:52.008999936 +0900 UTC+9 m=+3394243792.008999937ʆ

25. ࣮͸ࠔ͍ͬͯΔ͜ͱ • Cloud fl are Workersʹdeploy͢ΔͱSELECT͕ࣦഊ͢Δ • `panic: syscall/js: Value.Call:

    property close is not a function, got unde fi ned` • ެࣜGoίϯύΠϥͰ΋ࣦഊ͢Δ • લ͸௨ͬͯͨΑ͏ͳ… • INSERT͸௨Δ • (syumai͞Μʹ૬ஊ͍ͨ͠…)

26. Θ͋ʂ͜Μͳͷ΋ग़ͨʂ

27. Ҏ্ʂ