sqlcを利用してsqlに型付けを

Transcript

1. sqlcΛར༻ͯ͠sqlʹܕ෇͚Λ kansai.ts #8 2024.10.2 @kamiyam
2. ࣗݾ঺հ ͔Έ΍Μ (Twitter@kamiyam) ݩࣗಈं੔උ࢜ METEORWORKS Inc. Engineer ϑϩϯτʙ όοΫΤϯυNode.jsશൠ
3. What is sqlc?
4. IUUQTTRMDEFW
5. TRMD
   HFOFSBUF
   TRMDZNM
   Λར༻ͯ͠ίʔυΛੜ੒͢Δ IUUQTEPDTTRMDEFWFOMBUFTUIPXUPHFOFSBUFIUNM
6. sqlcࣗମ͸CLIπʔϧͱͯ͠ Πϯετʔϧ͢ΔܗͰར༻͢Δ͜ͱʹͳΔ (MacͳΒbrewͳͲ)
8. SQLϑΝΠϧΛಡΈऔͬͯɺgoίʔυΛੜ੒͢Δπʔϧ
9. Goݴޠ?
10. IUUQTHJUIVCDPNTRMDEFWTRMDHFOUZQFTDSJQU
12. plugin ͱͯ͠ TypeScript޲͚ SQLϑΝΠϧ͔Βܕ҆શͳίʔυΛੜ੒͢Δ
14. Supported engines and drivers - PostgreSQL via pg or postgres. - MySQL via mysql2. - SQLite via sqlite3.
15. ؀ڥʹsqlcΛΠϯετʔϧ͢ΔͷΛආ͚ DockerΛ͔Β࣮ߦ͢Δํ๏΋
17. How to use sqlc.
18. IUUQTHJUIVCDPNTRMDEFWTRMDHFOUZQFTDSJQUCMPC NBJOFYBNQMFTBVUIPSTNZTRMRVFSZTRM
19. IUUQTEPDTTRMDEFWFOTUBCMFSFGFSFODFRVFSZBOOPUBUJPOTIUNM
20. %&.0
21. Tips. PostgreSQL ͷํ͕खް͘αϙʔτͯͦ͠͏ MySQL Ͱ͸ insertޙͷid ͢Β… ϚΠάϨʔγϣϯʹ͸ରԠ͍ͯ͠ͳ͍ͷͰ ผͷϥΠϒϥϦΛ࢖͏ඞཁ͕͋Δ
22. Refs. Compile SQL to type-safe code; catch failures before they happen. https://sqlc.dev/ generate - Generating code https://docs.sqlc.dev/en/latest/howto/generate.html sqlc-gen-typescript https://github.com/sqlc-dev/sqlc-gen-typescript sqlc-gen-typescriptͰMySQLͰ΋insertޙͷID͕΄͍͠ https://qiita.com/Yuumillar/items/b1e3ec74eac725834735
23. sqlc-gen-typescript ͷ࠷৽ίʔυΛϏϧυͯ͠ v0.1.3Ͱ͸ར༻Ͱ͖ͳ͍ execlastid Λར༻͢Δ
25. ϩʔΧϧͷίϚϯυͰ͸͍͚Δ͕
    EPDLFSͰ͏·͍͔ͣ͘ʜ
26. Why use sqlc?
27. r
    LBNJZBN lͦΕͧΕͷ03Ϛούʔͷهड़Λ֮͑ΔͷͰ͋Ε͹ 42-Λॻ͍ͨํ͕͍͍ʢ͔΋͠Εͳ͍ʣz
28. ͳ͓sqlc(-gen-typescript)Λ࢖͓͏ͱࢥͬͯ ϓϩδΣΫτͷnextϒϥϯνʹೖΕͨཌ೔
30. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠
31. Refs. Announcing TypedSQL: Make your raw SQL queries type-safe with Prisma ORM https://www.prisma.io/blog/announcing-typedsql-make-your-raw-sql- queries-type-safe-with-prisma-orm