[B! zenn][prisma] stibbarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

stibbar id:stibbar

zennã¨prismaã«é–¢ã™ã‚‹stibbarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Cloudflare D1 ã§ ORM ã‚’ä½¿ã† (drizzle-orm)
tl;dr ç”Ÿç”£æ€§ã‚’ä¸Šã’ã‚‹ & SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’é˜²ããŸã‚ã« ORM ã‚’ä½¿ã†ã®ãŒã‚ˆã„ã¨ã•ã‚Œã¦ã„ã‚‹(è«¸èª¬ã‚ã‚Šã¾ã™) cloudflare workers + d1 ã¯ã‚¦ã‚§ãƒ–ã®ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³(è«¸èª¬ã‚ã‚Šã¾ã™) ãƒ¢ãƒ€ãƒ³ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã§å¤§åˆ‡ãªã®ã¯ TypeScript ã¨ã®è¦ªå’Œæ€§ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹(è«¸èª¬æ¸›ã£ã¦ããŸ) æœ¬å½“ã¯ç†æƒ³ã® ORM ã‚’è‡ªä½œã—ãŸã„ã®ã‘ã©ã€drizzle ãŒç¾çŠ¶ä¸€ç•ªè‡ªåˆ†ã®ã‚´ãƒ¼ãƒ«ã«è¿‘ã„ã®ã§ã€è©¦ã—ãŸã‚‰è‰¯ã•ãã†ã ã£ãŸ æ—¢å˜ã®å•é¡Œã¨ drizzle-orm ä»Šã¾ã§ã®ã‚ã‚‰ã™ã˜ ã¨ã„ã†ã‚ã‘ã§ d1 ã«å…¨æŒ¯ã‚Šã™ã‚‹ã®ãŒä»Šå¾Œã®ç”Ÿå˜æˆ¦ç•¥ã¨ã—ã¦æœ‰åŠ¹ã ã¨æ€ã£ã¦ã„ã‚‹ã‚“ã§ã™ãŒã€d1 client ã¯å°‚ç”¨ã®APIã‹ã‚‰ã‚¯ã‚¨ãƒªæ–‡å—åˆ—ã‚’é€ã‚Šè¾¼ã‚€å½¢å¼ãªã®ã§ã€native driver ã‚’ä½¿ã£ã¦ã‚‹ prisma ã‚„ typeorm ç‰ãŒä½¿ãˆã¾ã›ã‚“ã€‚ è‡ªåˆ†ãŒ Mongo db + ãŸã¾ã« Rails ActiveR
stibbar 2023/05/25
https://zenn.dev/chimame/articles/60e2824a42fec0

cloudflare

prisma

kysely

mizchi

zenn
ãƒªãƒ³ã‚¯
Prismaå¤§å¥½ãï¼
ãŠã¯ã‚ˆã†ã”ã–ã„ã¾ã™ï¼ã“ã‚“ã«ã¡ã¯ï¼ã“ã‚“ã°ã‚“ã¯ï¼ã¯ã˜ã‚ã¾ã—ã¦ï¼ ã‚¹ã‚¿ãƒ¼ãƒ•ã‚§ã‚¹ãƒ†ã‚£ãƒãƒ«ã® DPontaro ã§ã™ï¼ ã“ã®è¨˜äº‹ã¯ ã‚¹ã‚¿ãƒ¼ãƒ•ã‚§ã‚¹ãƒ†ã‚£ãƒãƒ« Advent Calendar 2022 ã®5æ—¥ç›®ã®è¨˜äº‹ã§ã™ï¼ï¼ï¼ï¼ï¼ æ˜¨æ—¥ã¯ã‚ã²ã‚‹ã•ã‚“ ã® terraform ã®ãŠè©±ã§ã—ãŸã€‚ ç§ã‚‚terraformã¯ã¾ã ã¾ã æ…£ã‚Œã¦ãŠã‚‰ãšã§ã€ã“ã†ã—ãŸå®Ÿä¾‹ã¯ã‚ã£ã¡ã‚ƒå‚è€ƒã«ãªã‚Šã¾ã™ãï¼ ã•ã¦ã•ã¦æœ¬æ—¥ã¯ã‚¤ãƒ³ãƒ•ãƒ©ã‹ã‚‰ã¯é›¢ã‚Œã¦Prismaã¨ã„ã†ORMã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ï¼ï¼ï¼ï¼ï¼ Prismaã¨ã¯ Node.jsã€TypeScriptç”¨ã®ORMã§ã™ã€‚ ä»²è‰¯ããªã‚‹ã¾ã§å¤šå°‘ã®è‹¦åŠ´ã¯ä¼´ã„ã¾ã™ãŒã€ãã‚Œã«è¦‹åˆã†ãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ï¼ migration ã¨ Prisma Client ã¾ãšã¯ Prisma schemaã‚’å®šç¾©ã—ã¾ã™ã€‚ ã“ã®schemaãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€DBãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã¨Prisma ClientãŒç”Ÿæˆã™ã‚‹modelã®å®šç¾©ã‚’
stibbar 2023/05/19
https://qiita.com/irohafox/items/2d484bbcbf9a023cb524

zenn

prisma
ãƒªãƒ³ã‚¯
ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ï½œPrismaãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«
stibbar 2023/05/19
zenn

prisma
ãƒªãƒ³ã‚¯
blitz-js ãŒã©ã†ã‚„ã£ã¦ã‚µãƒ¼ãƒãƒ¼ä¸Šã®é–¢æ•°ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã®å‘¼ã³å‡ºã—ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã®ã‹ã€èª¿æŸ»ã—ãŸ
bl itz-js prisma rails å€’ã—æ–¹ ã‚’æ›¸ã„ãŸæ™‚ã€ã“ã†ã„ã†ç–‘å•ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã® db ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã‚‚ã‚µãƒ¼ãƒãƒ¼ã§ã‚‚å‘¼ã¹ã‚‹ã‚ˆã†ã«ã¿ãˆã‚‹ã€‚ã“ã“ãŒ bl itz ã®ã‚ãƒ¢ã§ã€ã‚µãƒ¼ãƒãƒ¼ã§ã¯ãã®ã¾ã¾ prisma ã¨ã—ã¦å®Ÿè¡Œã•ã‚Œã‚‹ãŒã€å†…éƒ¨å®Ÿè£…ã‚’èªã‚“ã§ã„ãªã„ã®ã§æƒ³åƒã ãŒã€ ã“ã® db ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã¯åŒã˜ API ã® RPC ã«å¤‰æ›ã•ã‚Œã¦ã„ã‚‹ï¼Ÿ (ã“ã“ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã®ä¸å®‰ã¯ã‚ã‚‹ã€‚ã™ã¹ã¦ã‚’ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰å‘¼ã¹ã¦ã—ã¾ã†æã‚Œã¯ãªã„ã®ã‹ï¼Ÿ ã‚ã¨ã§ bl itz ã®ã‚³ãƒ¼ãƒ‰ã‚’å‘¼ã‚“ã§ã€ã©ã†ã‚„ã£ã¦å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ç¢ºèªã™ã‚‹) ã“ã®ä»¶ã«ã¤ã„ã¦ã®èª¿æŸ»ã‚’ã—ã¾ã—ãŸã€‚ Isomorphism: ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ»ã‚µãƒ¼ãƒãƒ¼åŒåž‹ bl itz ã§ã¯ã€æ¬¡ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã‚‚ã‚µãƒ¼ãƒãƒ¼ã§ã‚‚å‘¼ã¶ã“ã¨ãŒã§ãã¾ã™ã€‚ // app/auth/mutations/login.ts import { Ctx } from "bl
stibbar 2023/05/19
https://zenn.dev/mizchi/articles/cbe81299e145491676f8

zenn

mizchi

blitz

prisma
ãƒªãƒ³ã‚¯
Next.js ã‹ã‚‰ Prisma ORM ã‚’åˆ©ç”¨ã™ã‚‹
Next.js ã« Prisma ORM ã‚’å°Žå…¥ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ Next.js ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®é››å½¢ã‚’ä½œæˆ $ mkdir hello-next-app && cd hello-next-app $ npm init -y $ npm install next react react-dom --save $ npm install typescript @types/node @types/react --save-dev $ code src/index.tsx
stibbar 2023/05/16
zenn

mizchi

nextjs

prisma
ãƒªãƒ³ã‚¯
ã€æ–°æ©Ÿèƒ½ã€‘Vercel Postgres + Next.js + Prismaã§ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã£ã¦ã¿ãŸ
ã¯ã˜ã‚ã« GWã«å…¥ã‚Šã€5æ—¥é€£ç¶šã®Vercelã«ã‚ˆã‚‹æ–°æ©Ÿèƒ½ã®ç™ºè¡¨ãŒå§‹ã¾ã‚Šã¾ã—ãŸã€‚æ—©é€Ÿåˆæ—¥(2023 5/1)ã‹ã‚‰ã™ã•ã¾ã˜ã„æ©Ÿèƒ½ã®ç™ºè¡¨ãŒã‚ã‚Šã¾ã—ãŸã€‚ åˆæ—¥ã«ç™ºè¡¨ã•ã‚ŒãŸã®ã¯ã€ä»¥ä¸‹ã®ä¸‰ã¤ã®Storageã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ Vercel Postgres Vercel KV Vercel Blob ä»Šå›žã¯ã“ã®ä¸ã®Vercel Postgresã‚’å®Ÿéš›ã«ä½¿ã„ãªãŒã‚‰ã€Clientã‹ã‚‰Serverã¾ã§ç¶²ç¾…ã—ãŸã‚ã£ã¡ã‚ƒç°¡æ˜“çš„ãªãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã€å®Ÿç”¨æ€§ã®å´é¢ã‚‚åŠ å‘³ã—ã¦Prisma + Next.jsã§ä½œã£ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚
stibbar 2023/05/16
https://github.com/msy7822-ux/vercel-postgres-app

zenn

vercel

nextjs

prisma
ãƒªãƒ³ã‚¯
Vercel Postgres ã‚’ã•ãã£ã¨è©¦ã›ã‚‹ç’°å¢ƒã‚’ä½œã‚‹
ã¯ã˜ã‚ã« å…ˆæ—¥ã€3ã¤ã® Storage ã‚µãƒ¼ãƒ“ã‚¹ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸðŸŽ‰ Vercel KV Vercel Postgres Vercel Blob ãã®ä¸ã§ã‚‚å€‹äººçš„ã«æ°—ã«ãªã£ãŸ Vercel Postgres ã‚’è©¦ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ç’°å¢ƒæ§‹ç¯‰ Vercel Postgres ã‚’è©¦ã™ãŸã‚ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒã„ãã¤ã‹ç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆã‚ã‚ŠãŒãŸã„...ï¼‰ Vercel Postgres Next.js Starter Vercel Postgres + Kysely Next.js Starter Vercel Postgres + Prisma Next.js Starter ä¸Šè¨˜ã¯å…¨ã¦ Next.js ç”¨ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã§ã™ãŒã€ä»–ã«ã‚‚ Sveltekitã€Nuxt ç”¨ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚‚ç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ Prisma ã‚’ä½¿ã„ãŸã‹ã£ãŸã®ã§ã€ Vercel Postgres + Prisma
stibbar 2023/05/16
https://zenn.dev/chot/articles/8d991c79b739aa

zenn

vercel

prisma

nextjs
ãƒªãƒ³ã‚¯
1