{"id":2743,"date":"2026-10-25T12:07:58","date_gmt":"2026-10-25T12:07:58","guid":{"rendered":"https:\/\/wayhope.kro.kr\/?p=2743"},"modified":"2026-10-25T12:08:02","modified_gmt":"2026-10-25T12:08:02","slug":"prisma-orm-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b0%9c%eb%b0%9c%ea%b3%bc-%ec%84%b1%eb%8a%a5-%ec%b5%9c%ec%a0%81%ed%99%94-node-js","status":"publish","type":"post","link":"https:\/\/wayhope.kro.kr\/?p=2743","title":{"rendered":"Prisma ORM, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ubc1c\uacfc \uc131\ub2a5 \ucd5c\uc801\ud654 #Node.js"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Prisma\ub780?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\ub294 Node.js\uc640 TypeScript \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud3b8\ub9ac\ud558\uac8c \ub2e4\ub8f0 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\ub294 ORM(Object-Relational Mapping) \ub3c4\uad6c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORM\uc740 \uac1d\uccb4\uc9c0\ud5a5 \ud504\ub85c\uadf8\ub798\ubc0d\uc758 \uac1d\uccb4\uc640 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uc744 \uc5f0\uacb0\ud558\ub294 \uae30\uc220\uc774\ub2e4. \uac1c\ubc1c\uc790\uac00 SQL\uc744 \uc9c1\uc811 \uc791\uc131\ud558\ub294 \ub300\uc2e0 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc758 \uac1d\uccb4\uc640 \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0 \uc0dd\uc131\ud558\uac70\ub098 \uc218\uc815\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\ub294 \uc2a4\ud0a4\ub9c8\ub97c \uae30\ubc18\uc73c\ub85c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uc815\uc758\ud558\uace0, \uc774\ub97c \ubc14\ud0d5\uc73c\ub85c \ud0c0\uc785\uc774 \uc9c0\uc815\ub41c Prisma Client\ub97c \uc0dd\uc131\ud55c\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \ucf54\ub4dc\ub97c \uc77c\uad00\uc131 \uc788\uac8c \uc791\uc131\ud558\uace0 \ucef4\ud30c\uc77c \ub2e8\uacc4\uc5d0\uc11c \uc5ec\ub7ec \uc885\ub958\uc758 \ud0c0\uc785 \uc624\ub958\ub97c \ubc1c\uacac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub300\uccb4\ud558\ub294 \uae30\uc220\uc774 \uc544\ub2c8\ub2e4. \uc2e4\uc81c \ub370\uc774\ud130 \uc800\uc7a5\uacfc \ucffc\ub9ac \uc2e4\ud589\uc740 MySQL, PostgreSQL \ub4f1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub2f4\ub2f9\ud558\uba70, Prisma\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc774\uc758 \ub370\uc774\ud130 \uc811\uadfc \uacc4\uce35\uc744 \uc81c\uacf5\ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prisma\uc758 \uc8fc\uc694 \uad6c\uc131 \uc694\uc18c<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Prisma Schema<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma Schema\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub378\uacfc \uc5f0\uacb0 \uc815\ubcf4\ub97c \uc815\uc758\ud558\ub294 \ud30c\uc77c\uc774\ub2e4. \ub370\uc774\ud130 \ubaa8\ub378, \ud544\ub4dc \ud0c0\uc785, \uad00\uacc4, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \ubc29\uc2dd \ub4f1\uc744 \uc120\uc5b8\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784 \ud50c\ub7ab\ud3fc\uc758 \uc0ac\uc6a9\uc790 \ubaa8\ub378\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>model User {\n  id        Int      @id @default(autoincrement())\n  email     String   @unique\n  nickname  String\n  createdAt DateTime @default(now())\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubaa8\ub378\uc740 \uc0ac\uc6a9\uc790 \uc2dd\ubcc4\uc790, \uc774\uba54\uc77c, \ub2c9\ub124\uc784, \uc0dd\uc131 \uc2dc\uac01\uc744 \uc815\uc758\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>@id<\/code>\ub294 \uae30\ubcf8 \ud0a4\ub97c \uc9c0\uc815\ud558\uace0, <code>@unique<\/code>\ub294 \uc774\uba54\uc77c\uc758 \uc911\ubcf5\uc744 \ubc29\uc9c0\ud55c\ub2e4. <code>@default<\/code>\ub294 \uae30\ubcf8\uac12\uc744 \uc124\uc815\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2a4\ud0a4\ub9c8\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uba85\uc2dc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uba74 \ub370\uc774\ud130 \uad6c\uc870\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ucf54\ub4dc \uc0ac\uc774\uc758 \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc27d\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prisma Client<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma Client\ub294 \uc2a4\ud0a4\ub9c8\ub97c \uae30\ubc18\uc73c\ub85c \uc0dd\uc131\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \ub77c\uc774\ube0c\ub7ec\ub9ac\ub2e4. \ubaa8\ub378\ubcc4 \uc870\ud68c, \uc0dd\uc131, \uc218\uc815, \uc0ad\uc81c API\ub97c \uc81c\uacf5\ud558\uba70, TypeScript \ud658\uacbd\uc5d0\uc11c\ub294 \uc785\ub825\uac12\uacfc \ubc18\ud658\uac12\uc5d0 \ub300\ud55c \ud0c0\uc785 \uc815\ubcf4\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790 \uc870\ud68c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc791\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>const user = await prisma.user.findUnique({\n  where: {\n    id: userId\n  }\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\uc744 \uc9c1\uc811 \uc791\uc131\ud558\uc9c0 \uc54a\uace0\ub3c4 \uc0ac\uc6a9\uc790 \uc2dd\ubcc4\uc790\ub97c \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma Client\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c \ud544\uc694\ud55c SQL\uc744 \uc0dd\uc131\ud558\uace0 \uc2e4\ud589\ud55c \ub4a4, \uc870\ud68c \uacb0\uacfc\ub97c JavaScript \uac1d\uccb4 \ud615\ud0dc\ub85c \ubc18\ud658\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prisma Migrate<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma Migrate\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\uc758 \ubcc0\uacbd \uc774\ub825\uc744 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud30c\uc77c\ub85c \uad00\ub9ac\ud558\ub294 \ub3c4\uad6c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac1c\ubc1c \uacfc\uc815\uc5d0\uc11c \ud14c\uc774\ube14\uc774\ub098 \ud544\ub4dc\uac00 \ubcc0\uacbd\ub418\uba74 \ubcc0\uacbd \ub0b4\uc6a9\uc744 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc73c\ub85c \uc0dd\uc131\ud558\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>npx prisma migrate dev --name add_user_profile<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uba85\ub839\uc740 \uac1c\ubc1c \ud658\uacbd\uc5d0\uc11c \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc0dd\uc131\ud558\uace0 \uc801\uc6a9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uac80\ud1a0\ub41c \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc801\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>npx prisma migrate deploy<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870 \ubcc0\uacbd\uc744 \ucf54\ub4dc \ubcc0\uacbd\uacfc \ud568\uaed8 \ubc84\uc804 \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4. \ub2e4\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcc0\uacbd\uc774 \uae30\uc874 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ud638\ud658\ub418\ub294\uc9c0, \ub300\uaddc\ubaa8 \ud14c\uc774\ube14 \ubcc0\uacbd\uc774 \uc7a0\uae08\uc774\ub098 \uc9c0\uc5f0\uc744 \uc720\ubc1c\ud558\ub294\uc9c0\ub294 \ubcc4\ub3c4\ub85c \uac80\ud1a0\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">CRUD\uc640 Prisma Client<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">CRUD\ub294 \ub370\uc774\ud130\uc758 \uc0dd\uc131(Create), \uc870\ud68c(Read), \uc218\uc815(Update), \uc0ad\uc81c(Delete)\ub97c \uc758\ubbf8\ud55c\ub2e4. \ub300\ubd80\ubd84\uc758 \ubc31\uc5d4\ub4dc \uc11c\ube44\uc2a4\ub294 \uc774 \uc791\uc5c5\uc744 \uc911\uc2ec\uc73c\ub85c \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uc0dd\uc131<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>const user = await prisma.user.create({\n  data: {\n    email: \"player@example.com\",\n    nickname: \"Player\"\n  }\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790\ub97c \uc0dd\uc131\ud55c\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc81c\uc57d \uc870\uac74\uc744 \uc704\ubc18\ud558\uba74 \uc791\uc5c5\uc774 \uc2e4\ud328\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc911\ubcf5 \uc774\uba54\uc77c\uc774\ub098 \uc798\ubabb\ub41c \uc785\ub825\uc744 \uc801\uc808\ud788 \ucc98\ub9ac\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uc870\ud68c<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>const user = await prisma.user.findUnique({\n  where: {\n    email: \"player@example.com\"\n  }\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uace0\uc720\ud55c \uc774\uba54\uc77c\uc744 \uae30\uc900\uc73c\ub85c \uc0ac\uc6a9\uc790\ub97c \uc870\ud68c\ud55c\ub2e4. \ud574\ub2f9 \ub370\uc774\ud130\uac00 \uc5c6\uc73c\uba74 \uacb0\uacfc\ub294 <code>null<\/code>\uc77c \uc218 \uc788\uc73c\ubbc0\ub85c \ud6c4\uc18d \ucf54\ub4dc\uc5d0\uc11c \uc774\ub97c \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uc218\uc815<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>const user = await prisma.user.update({\n  where: {\n    id: userId\n  },\n  data: {\n    nickname: \"NewNickname\"\n  }\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\uc815 \uc0ac\uc6a9\uc790\uc758 \ub2c9\ub124\uc784\uc744 \ubcc0\uacbd\ud55c\ub2e4. <code>update<\/code>\ub294 \uc870\uac74\uc5d0 \ub9de\ub294 \ub808\ucf54\ub4dc\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uc0ad\uc81c<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>await prisma.user.delete({\n  where: {\n    id: userId\n  }\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790 \ub808\ucf54\ub4dc\ub97c \uc0ad\uc81c\ud55c\ub2e4. \uc2e4\uc81c \uc11c\ube44\uc2a4\uc5d0\uc11c\ub294 \uc5f0\uad00 \ub370\uc774\ud130, \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74, \uc18c\ud504\ud2b8 \uc0ad\uc81c \uc815\ucc45 \ub4f1\uc744 \ud568\uaed8 \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ucc98\ub7fc Prisma\ub294 \ub370\uc774\ud130 \uc811\uadfc \ub85c\uc9c1\uc744 \uc77c\uad00\ub41c \ud615\ud0dc\ub85c \uc791\uc131\ud558\ub3c4\ub85d \uc9c0\uc6d0\ud55c\ub2e4. \uadf8\ub7ec\ub098 \uc778\uc99d\uacfc \uad8c\ud55c \uac80\uc99d, \uc785\ub825\uac12 \uac80\uc99d, \ube44\uc988\ub2c8\uc2a4 \uaddc\uce59\uc740 \uac1c\ubc1c\uc790\uac00 \ubcc4\ub3c4\ub85c \uad6c\ud604\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uad00\uacc4\ud615 \ub370\uc774\ud130 \ubaa8\ub378\uacfc \ud2b8\ub79c\uc7ad\uc158<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc81c \uc11c\ube44\uc2a4\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790, \uc778\ubca4\ud1a0\ub9ac, \uacbd\uae30 \uacb0\uacfc, \ud3ec\uc778\ud2b8 \ub0b4\uc5ed\ucc98\ub7fc \uc11c\ub85c \uc5f0\uacb0\ub41c \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\ub294 \ubaa8\ub378 \uac04 \uad00\uacc4\ub97c \uc815\uc758\ud558\uace0 \uad00\ub828 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud55c\ub2e4. \ub610\ud55c \ud2b8\ub79c\uc7ad\uc158\uc744 \uc0ac\uc6a9\ud574 \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \ud558\ub098\uc758 \ub17c\ub9ac\uc801 \uc791\uc5c5\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uacbd\uae30 \ubcf4\uc0c1\uc73c\ub85c \uc0ac\uc6a9\uc790\uc758 \ud3ec\uc778\ud2b8\ub97c \uc99d\uac00\uc2dc\ud0a4\uace0 \uc815\uc0b0 \ub0b4\uc5ed\uc744 \uc800\uc7a5\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>await prisma.$transaction(async (tx) =&gt; {\n  await tx.user.update({\n    where: {\n      id: userId\n    },\n    data: {\n      points: {\n        increment: rewardPoints\n      }\n    }\n  });\n\n  await tx.rewardHistory.create({\n    data: {\n      userId,\n      points: rewardPoints\n    }\n  });\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158 \ub0b4\ubd80\uc758 \uc791\uc5c5\uc774 \uc2e4\ud328\ud558\uba74 \ud574\ub2f9 \ud2b8\ub79c\uc7ad\uc158\uc758 \ubcc0\uacbd \uc0ac\ud56d\uc740 \ub864\ubc31\ub41c\ub2e4. \uc774\ub97c \ud1b5\ud574 \ud3ec\uc778\ud2b8\ub294 \uc99d\uac00\ud588\uc9c0\ub9cc \uc815\uc0b0 \ub0b4\uc5ed\uc740 \uc800\uc7a5\ub418\uc9c0 \uc54a\ub294 \uc2dd\uc758 \ubd88\uc77c\uce58\ub97c \ubc29\uc9c0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8, \uc774 \uc608\uc81c\ub9cc\uc73c\ub85c \ubaa8\ub4e0 \uc815\uc0b0 \ubb38\uc81c\uac00 \ud574\uacb0\ub418\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \uc911\ubcf5 \uc694\uccad\uc5d0 \uc758\ud55c \ubcf4\uc0c1 \uc911\ubcf5 \uc9c0\uae09, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7ac\uc2dc\ub3c4 \uc815\ucc45, \uba71\ub4f1\uc131 \ud0a4 \ub4f1\uc740 \ubcc4\ub3c4\ub85c \uc124\uacc4\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prisma\uc758 \uc7a5\uc810<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\ud0c0\uc785 \uc548\uc815\uc131<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma Client\ub294 \uc2a4\ud0a4\ub9c8\ub97c \uae30\ubc18\uc73c\ub85c \ud0c0\uc785 \uc815\ubcf4\ub97c \uc0dd\uc131\ud55c\ub2e4. \ub530\ub77c\uc11c \uc798\ubabb\ub41c \ud544\ub4dc\uba85\uc774\ub098 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\ub294 \uc785\ub825\uac12\uc744 \uac1c\ubc1c \uacfc\uc815\uc5d0\uc11c \ubc1c\uacac\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 TypeScript\ub97c \uc0ac\uc6a9\ud558\ub294 \ub300\uaddc\ubaa8 \ubc31\uc5d4\ub4dc \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c\ub294 \ub370\uc774\ud130 \ubaa8\ub378\uacfc \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ucf54\ub4dc\uc758 \ubd88\uc77c\uce58\ub97c \uc904\uc774\ub294 \ub370 \uc720\uc6a9\ud558\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uac1c\ubc1c \uc0dd\uc0b0\uc131<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ubc18\uc801\uc778 CRUD \uc791\uc5c5\uc5d0\uc11c \ubc18\ubcf5\uc801\uc778 SQL \uc791\uc131\uacfc \uacb0\uacfc \ub9e4\ud551 \ucf54\ub4dc\ub97c \uc904\uc77c \uc218 \uc788\ub2e4. \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uc911\uc2ec\uc73c\ub85c \ucf54\ub4dc\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc5b4 \uac1c\ubc1c \uc18d\ub3c4\uc640 \uc720\uc9c0\ubcf4\uc218\uc131\uc744 \ub192\uc774\uae30 \uc27d\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc2a4\ud0a4\ub9c8\uc640 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uad00\ub9ac<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \ubaa8\ub378\uacfc \ubcc0\uacbd \uc774\ub825\uc744 \ucf54\ub4dc\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4. \uac1c\ubc1c \ud658\uacbd\uacfc \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub97c \uc77c\uad00\ub418\uac8c \uc720\uc9c0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub41c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uc811\uadfc \ucf54\ub4dc\uc758 \uc77c\uad00\uc131<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud300\uc5d0\uc11c \uacf5\ud1b5\uc801\uc778 \ub370\uc774\ud130 \uc811\uadfc \ud328\ud134\uc744 \uc0ac\uc6a9\ud558\uae30 \uc27d\ub2e4. \uc870\ud68c \uc870\uac74, \ub370\uc774\ud130 \ubcc0\uacbd, \uad00\uacc4 \ucc98\ub9ac \ub4f1\uc744 \uc77c\uad00\ub41c API \ud615\ud0dc\ub85c \uc791\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prisma\uc758 \uc131\ub2a5\uacfc \ud55c\uacc4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\ub294 \ud3b8\ub9ac\ud55c \ucd94\uc0c1\ud654 \uacc4\uce35\uc744 \uc81c\uacf5\ud558\uc9c0\ub9cc, \ubaa8\ub4e0 \uc0c1\ud669\uc5d0\uc11c \uc9c1\uc811 SQL\uc744 \uc791\uc131\ud558\ub294 \ubc29\uc2dd\ubcf4\ub2e4 \ube60\ub978 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc131\ub2a5\uc744 \ud3c9\uac00\ud560 \ub54c\ub294 ORM \uc790\uccb4\uc758 \ucc98\ub9ac \ube44\uc6a9\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac\uc758 \uc2e4\ud589 \ube44\uc6a9\uc744 \uad6c\ubd84\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ORM \uacc4\uce35\uc758 \uc624\ubc84\ud5e4\ub4dc<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\ub294 \uc694\uccad\uc744 \ucc98\ub9ac\ud558\ub294 \uacfc\uc815\uc5d0\uc11c \ucffc\ub9ac \uad6c\uc131, \uacb0\uacfc \ubcc0\ud658 \ub4f1\uc758 \uc791\uc5c5\uc744 \uc218\ud589\ud55c\ub2e4. \ub530\ub77c\uc11c \ub9e4\uc6b0 \ub2e8\uc21c\ud55c \ucffc\ub9ac\ub97c \ub300\ub7c9\uc73c\ub85c \uc2e4\ud589\ud558\uac70\ub098 \uc9c0\uc5f0 \uc2dc\uac04\uc774 \uadf9\ub3c4\ub85c \uc911\uc694\ud55c \uc0c1\ud669\uc5d0\uc11c\ub294 \uc9c1\uc811 SQL\uc744 \uc2e4\ud589\ud558\ub294 \ubc29\uc2dd\ubcf4\ub2e4 \ucd94\uac00 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uc2e4\uc81c \ucc28\uc774\ub294 \ucffc\ub9ac \uc720\ud615, \ub370\uc774\ud130 \ud06c\uae30, \uc5f0\uacb0 \ud480 \uc124\uc815, Prisma \ubc84\uc804\uacfc \uc0ac\uc6a9 \ubc29\uc2dd\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c4\ub2e4. ORM\uc744 \uc0ac\uc6a9\ud55c\ub2e4\ub294 \uc774\uc720\ub9cc\uc73c\ub85c \uc131\ub2a5\uc774 \ud06c\uac8c \ub5a8\uc5b4\uc9c4\ub2e4\uace0 \ub2e8\uc815\ud560 \uc218\ub294 \uc5c6\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ORM\uc744 \uc0ac\uc6a9\ud574\ub3c4 \ube44\ud6a8\uc728\uc801\uc778 SQL\uc774 \uc2e4\ud589\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc778 \ubb38\uc81c\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud544\uc694\ud55c \uac83\ubcf4\ub2e4 \ub9ce\uc740 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294 \uacbd\uc6b0<\/li>\n\n\n\n<li>\uc801\uc808\ud55c \uc778\ub371\uc2a4\uac00 \uc5c6\ub294 \uacbd\uc6b0<\/li>\n\n\n\n<li>N+1 \ucffc\ub9ac \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0<\/li>\n\n\n\n<li>\ubcf5\uc7a1\ud55c \uad00\uacc4 \uc870\ud68c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubd80\ud558\uac00 \uc99d\uac00\ud558\ub294 \uacbd\uc6b0<\/li>\n\n\n\n<li>\ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \ubcc0\ud658\uacfc \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ucc98\ub9ac\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7ec\ud55c \ubb38\uc81c\ub294 ORM\uc744 \ub2e4\ub978 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c \uad50\uccb4\ud558\ub294 \uac83\ub9cc\uc73c\ub85c \ud574\uacb0\ub418\uc9c0 \uc54a\uc744 \uc218 \uc788\ub2e4. \uc2e4\uc81c SQL\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2e4\ud589 \uacc4\ud68d\uc744 \ubd84\uc11d\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubcf5\uc7a1\ud55c \uc9d1\uacc4\uc640 \ub300\ub7c9 \ucc98\ub9ac<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcf5\uc7a1\ud55c \ud1b5\uacc4 \ucffc\ub9ac, \ub300\uaddc\ubaa8 \uc9d1\uacc4, \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158, \ub300\ub7c9 \uc0bd\uc785 \uc791\uc5c5\uc5d0\uc11c\ub294 \uc9c1\uc811 \uc791\uc131\ud55c SQL\uc774 \ub354 \uc801\ud569\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\uc5d0\uc11c\ub3c4 Raw Query\ub97c \uc0ac\uc6a9\ud574 SQL\uc744 \uc9c1\uc811 \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4. \ub530\ub77c\uc11c ORM \uc804\uccb4\ub97c \uc81c\uac70\ud558\uae30\ubcf4\ub2e4 \uc77c\ubc18\uc801\uc778 CRUD\ub294 Prisma\ub85c \ucc98\ub9ac\ud558\uace0, \uc131\ub2a5\uc774\ub098 \ud45c\ud604\ub825 \uce21\uba74\uc5d0\uc11c \ud544\uc694\ud55c \ucffc\ub9ac\ub9cc SQL\ub85c \uc791\uc131\ud558\ub294 \ud63c\ud569 \ubc29\uc2dd\ub3c4 \uace0\ub824\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Raw Query\ub97c \uc0ac\uc6a9\ud560 \ub54c\ub294 \ub9e4\uac1c\ubcc0\uc218 \ubc14\uc778\ub529\uc744 \ud65c\uc6a9\ud574 SQL \uc778\uc81d\uc158\uc744 \ubc29\uc9c0\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prisma\uc640 \uc9c1\uc811 SQL \ube44\uad50<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\uc640 \uc9c1\uc811 SQL\uc740 \uc11c\ub85c \ub300\uccb4 \uad00\uacc4\ub77c\uae30\ubcf4\ub2e4 \uc11c\ub85c \ub2e4\ub978 \ucd94\uc0c1\ud654 \uc218\uc900\uc758 \ub370\uc774\ud130 \uc811\uadfc \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\ube44\uad50 \ud56d\ubaa9<\/th><th>Prisma<\/th><th>\uc9c1\uc811 SQL<\/th><\/tr><tr><td>\uac1c\ubc1c \uc0dd\uc0b0\uc131<\/td><td>\uc77c\ubc18\uc801\uc778 CRUD \uc791\uc131\uc774 \ud3b8\ub9ac\ud568<\/td><td>\ucffc\ub9ac\uc640 \uacb0\uacfc \ucc98\ub9ac\ub97c \uc9c1\uc811 \uad00\ub9ac<\/td><\/tr><tr><td>\ud0c0\uc785 \uc548\uc815\uc131<\/td><td>\uc0dd\uc131\ub41c \ud0c0\uc785\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\uc74c<\/td><td>\ubcc4\ub3c4 \ud0c0\uc785 \uc815\uc758\uc640 \uac80\uc99d\uc774 \ud544\uc694\ud560 \uc218 \uc788\uc74c<\/td><\/tr><tr><td>\ucffc\ub9ac \uc81c\uc5b4<\/td><td>ORM API\uc640 Raw Query\ub97c \ud1b5\ud574 \uc81c\uc5b4<\/td><td>SQL\uc744 \uc138\ubc00\ud558\uac8c \uc9c1\uc811 \uc81c\uc5b4<\/td><\/tr><tr><td>\uc131\ub2a5<\/td><td>\ucd94\uc0c1\ud654 \uacc4\uce35\uc758 \ucd94\uac00 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc74c<\/td><td>\uc624\ubc84\ud5e4\ub4dc\ub97c \uc904\uc77c \uc5ec\uc9c0\uac00 \uc788\uc74c<\/td><\/tr><tr><td>\uc720\uc9c0\ubcf4\uc218<\/td><td>\ubaa8\ub378 \uc911\uc2ec\uc73c\ub85c \uad00\ub9ac\ud558\uae30 \ud3b8\ub9ac\ud568<\/td><td>SQL\uacfc \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ucf54\ub4dc \uad00\ub9ac\uac00 \uc911\uc694\ud568<\/td><\/tr><tr><td>\ubcf5\uc7a1\ud55c \uc9d1\uacc4<\/td><td>\uc0c1\ud669\uc5d0 \ub530\ub77c Raw Query\uac00 \ud544\uc694\ud568<\/td><td>\ubcf5\uc7a1\ud55c \ucffc\ub9ac\ub97c \uc9c1\uc811 \ud45c\ud604\ud558\uae30 \uc88b\uc74c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc9c1\uc811 SQL\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uace0 \ud56d\uc0c1 \ube60\ub978 \uac83\ub3c4 \uc544\ub2c8\ub2e4. \ube44\ud6a8\uc728\uc801\uc778 SQL\uc740 ORM \uc5c6\uc774 \uc791\uc131\ud574\ub3c4 \ub290\ub9ac\ub2e4. \uacb0\uad6d \uc911\uc694\ud55c \uac83\uc740 \uc2e4\uc81c \ucffc\ub9ac\uc758 \ud488\uc9c8\uacfc \uc2e4\ud589 \uacc4\ud68d\uc774\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prisma\uc640 \ub2e4\ub978 \ub370\uc774\ud130 \uc811\uadfc \ub3c4\uad6c<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Node.js \ud658\uacbd\uc5d0\uc11c\ub294 Prisma \uc678\uc5d0\ub3c4 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc811\uadfc \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Drizzle ORM<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Drizzle ORM\uc740 SQL\uacfc \uac00\uae4c\uc6b4 \ubc29\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac\ub97c \uc791\uc131\ud558\ub824\ub294 \uac1c\ubc1c\uc790\uc5d0\uac8c \uc801\ud569\ud558\ub2e4. \ud0c0\uc785 \uc548\uc815\uc131\uc744 \uc81c\uacf5\ud558\uba74\uc11c\ub3c4 \ucffc\ub9ac\uc758 \uad6c\uc870\ub97c \ube44\uad50\uc801 \uba85\uc2dc\uc801\uc73c\ub85c \ud45c\ud604\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Knex.js<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Knex.js\ub294 SQL \ucffc\ub9ac \ube4c\ub354\ub2e4. ORM\ucc98\ub7fc \ubaa8\ub378 \uc911\uc2ec\uc758 \ucd94\uc0c1\ud654\ub97c \uc81c\uacf5\ud558\uae30\ubcf4\ub2e4\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \ucf54\ub4dc\ub85c SQL \ucffc\ub9ac\ub97c \uad6c\uc131\ud558\ub294 \ub370 \ucd08\uc810\uc744 \ub9de\ucd98\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">mysql2\uc640 pg<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">mysql2\uc640 pg\ub294 \uac01\uac01 MySQL \uacc4\uc5f4\uacfc PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \ub4dc\ub77c\uc774\ubc84\ub2e4. SQL\uc744 \uc9c1\uc811 \uc791\uc131\ud558\uace0 \ub370\uc774\ud130 \uc811\uadfc \uacc4\uce35\uc744 \uc138\ubc00\ud558\uac8c \uc81c\uc5b4\ud558\ub824\ub294 \uacbd\uc6b0 \uc801\ud569\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ub3c4\uad6c\ub4e4\uc740 \ucd94\uc0c1\ud654 \uc218\uc900\uacfc \uc81c\uacf5 \uae30\ub2a5\uc774 \ub2e4\ub974\ubbc0\ub85c \ub2e8\uc21c\ud55c \uc131\ub2a5 \uc21c\uc704\ub85c \ube44\uad50\ud558\uae30\ubcf4\ub2e4 \ud504\ub85c\uc81d\ud2b8\uc758 \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub9de\ucdb0 \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c Prisma \ud65c\uc6a9\ud558\uae30<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc2dc\uac04 \uba40\ud2f0\ud50c\ub808\uc774 \uac8c\uc784 \ud50c\ub7ab\ud3fc\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4. \ub370\uc774\ud130\uc758 \uc218\uba85, \uc77c\uad00\uc131 \uc694\uad6c\uc0ac\ud56d, \uc811\uadfc \ube48\ub3c4, \uc9c0\uc5f0 \uc2dc\uac04 \ubaa9\ud45c\uc5d0 \ub530\ub77c \ub370\uc774\ud130 \uc811\uadfc \ubc29\uc2dd\uc744 \uad6c\ubd84\ud558\ub294 \uac83\uc774 \uc911\uc694\ud558\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prisma\uac00 \uc801\ud569\ud55c \uc601\uc5ed<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud68c\uc6d0 \uac00\uc785\uacfc \uacc4\uc815 \uad00\ub9ac<\/li>\n\n\n\n<li>\uc0ac\uc6a9\uc790 \ud504\ub85c\ud544 \uc870\ud68c \ubc0f \uc218\uc815<\/li>\n\n\n\n<li>\uac8c\uc784 \uae30\ub85d\uacfc \uc804\uc801 \uc800\uc7a5<\/li>\n\n\n\n<li>\uc6b4\uc601 \ub3c4\uad6c\uc758 \ub370\uc774\ud130 \uad00\ub9ac<\/li>\n\n\n\n<li>\uc77c\ubc18\uc801\uc778 \ubcf4\uc0c1 \ub0b4\uc5ed \ubc0f \uac70\ub798 \uae30\ub85d<\/li>\n\n\n\n<li>\uad00\uacc4\ud615 \ub370\uc774\ud130\uc758 CRUD \uc791\uc5c5<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7ec\ud55c \uc601\uc5ed\uc5d0\uc11c\ub294 \uac1c\ubc1c \uc0dd\uc0b0\uc131\uacfc \ub370\uc774\ud130 \ubaa8\ub378 \uad00\ub9ac\uc758 \uc774\uc810\uc774 \ud06c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc9c1\uc811 SQL\uc744 \uace0\ub824\ud560 \uc601\uc5ed<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ubcf5\uc7a1\ud55c \ub7ad\ud0b9 \ubc0f \ud1b5\uacc4 \uc9d1\uacc4<\/li>\n\n\n\n<li>\ub300\ub7c9 \ub370\uc774\ud130 \uc870\ud68c\uc640 \ucc98\ub9ac<\/li>\n\n\n\n<li>\uc131\ub2a5 \ubcd1\ubaa9\uc774 \ud655\uc778\ub41c \ud575\uc2ec \ucffc\ub9ac<\/li>\n\n\n\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ub2a5\uc744 \uc138\ubc00\ud558\uac8c \ud65c\uc6a9\ud574\uc57c \ud558\ub294 \uc791\uc5c5<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\uc758 Raw Query\ub97c \uc774\uc6a9\ud558\uba74 \uae30\uc874 \ub370\uc774\ud130 \uc811\uadfc \uad6c\uc870\ub97c \uc720\uc9c0\ud558\uba74\uc11c \ud2b9\uc815 \ucffc\ub9ac\ub9cc \uc9c1\uc811 SQL\ub85c \uc791\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Redis\uc640 \uba54\ubaa8\ub9ac \uae30\ubc18 \ucc98\ub9ac\uac00 \uc801\ud569\ud55c \uc601\uc5ed<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc628\ub77c\uc778 \uc0c1\ud0dc\uc640 \uc138\uc158 \uad00\ub9ac<\/li>\n\n\n\n<li>\ub9e4\uce6d \ub300\uae30\uc5f4<\/li>\n\n\n\n<li>\uc784\uc2dc \uac8c\uc784 \uc0c1\ud0dc<\/li>\n\n\n\n<li>\ube48\ubc88\ud558\uac8c \ubcc0\uacbd\ub418\ub294 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130<\/li>\n\n\n\n<li>\uc9e7\uc740 \ub9cc\ub8cc \uc2dc\uac04\uc744 \uac16\ub294 \uce90\uc2dc \ub370\uc774\ud130<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7ec\ud55c \ub370\uc774\ud130\ub294 \uc811\uadfc \ube48\ub3c4\uc640 \uc9c0\uc5f0 \uc2dc\uac04 \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub530\ub77c Redis\ub098 \uba54\ubaa8\ub9ac \uae30\ubc18 \uad6c\uc870\ub97c \uace0\ub824\ud560 \uc218 \uc788\ub2e4. \ub2e4\ub9cc \ub370\uc774\ud130 \uc190\uc2e4 \ud5c8\uc6a9 \ubc94\uc704\uc640 \ubcf5\uad6c \uc815\ucc45\uc5d0 \ub530\ub77c \uc601\uc18d\ud654 \uc804\ub7b5\ub3c4 \ud568\uaed8 \uc124\uacc4\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc2dc\uac04 \uc804\ud22c \uc0c1\ud0dc\ub97c \ub9e4 \ud504\ub808\uc784\ub9c8\ub2e4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ud558\ub294 \uad6c\uc870\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc801\ud569\ud558\uc9c0 \uc54a\ub2e4. \uc2e4\uc2dc\uac04 \uc0c1\ud0dc\ub294 \uba54\ubaa8\ub9ac\uc5d0\uc11c \ucc98\ub9ac\ud558\uace0, \ud544\uc694\ud55c \uc2dc\uc810\uc5d0 \uacb0\uacfc\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uae30\ub85d\ud558\ub294 \uad6c\uc870\uac00 \ub354 \ud569\ub9ac\uc801\uc774\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prisma \uc131\ub2a5 \ucd5c\uc801\ud654 \uc804\ub7b5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Prisma\uc758 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub824\uba74 ORM\uc744 \uc81c\uac70\ud558\uae30 \uc804\uc5d0 \uc2e4\uc81c \ubcd1\ubaa9\uc744 \uce21\uc815\ud558\uace0 \ubd84\uc11d\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc \uc870\ud68c\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><code>select<\/code>\ub97c \uc0ac\uc6a9\ud558\uba74 \ud544\uc694\ud55c \ud544\ub4dc\ub9cc \uc870\ud68c\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>const user = await prisma.user.findUnique({\n  where: {\n    id: userId\n  },\n  select: {\n    id: true,\n    nickname: true\n  }\n});<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ubd88\ud544\uc694\ud55c \ud544\ub4dc \uc870\ud68c\uc640 \ub370\uc774\ud130 \uc804\uc1a1\uc744 \uc904\uc774\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ucc98\ub9ac \ubd80\ub2f4\uc744 \ub0ae\ucd9c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc778\ub371\uc2a4\uc640 \uc2e4\ud589 \uacc4\ud68d \ud655\uc778\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc870\ud68c \uc870\uac74\uc5d0 \ub9de\ub294 \uc778\ub371\uc2a4\ub97c \uc124\uacc4\ud558\uace0 \uc2e4\uc81c \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud574\uc57c \ud55c\ub2e4. Prisma API\ub97c \ucd5c\uc801\ud654\ud558\ub354\ub77c\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ube44\ud6a8\uc728\uc801\uc778 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc120\ud0dd\ud558\uba74 \uc131\ub2a5 \uac1c\uc120\uc5d0\ub294 \ud55c\uacc4\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">N+1 \ucffc\ub9ac \ubc29\uc9c0\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc18\ubcf5\ubb38 \uc548\uc5d0\uc11c \uac1c\ubcc4 \uc870\ud68c\ub97c \uc218\ud589\ud558\uba74 \ub370\uc774\ud130 \uac74\uc218\uc5d0 \ube44\ub840\ud574 \ucffc\ub9ac \uc218\uac00 \uc99d\uac00\ud560 \uc218 \uc788\ub2e4. \ud544\uc694\ud55c \uad00\uacc4\ub97c \uc801\uc808\ud558\uac8c \uc870\ud68c\ud558\uac70\ub098 <code>in<\/code> \uc870\uac74\uc744 \uc0ac\uc6a9\ud55c \uc77c\uad04 \uc870\ud68c \ub4f1\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc218\ub97c \uc904\uc77c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc5f0\uacb0 \ud480\uacfc \ub3d9\uc2dc\uc131 \uad00\ub9ac\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc740 \ubb34\uc81c\ud55c\uc73c\ub85c \ub298\ub9b4 \uc218 \uc5c6\ub2e4. \uc5f0\uacb0 \ud480\uc758 \ud06c\uae30\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc778\uc2a4\ud134\uc2a4 \uc218\ub97c \ud568\uaed8 \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \uc5ec\ub7ec \uc11c\ubc84 \uc778\uc2a4\ud134\uc2a4\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\ub294 \ud658\uacbd\uc5d0\uc11c\ub294 \uc804\uccb4 \uc5f0\uacb0 \uc218\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ucc98\ub9ac \ud55c\uacc4\ub97c \ucd08\uacfc\ud558\uc9c0 \uc54a\ub3c4\ub85d \uad00\ub9ac\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc131\ub2a5 \uc9c0\ud45c \uce21\uc815\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ucffc\ub9ac \uc2e4\ud589 \uc2dc\uac04\ub9cc \uce21\uc815\ud574\uc11c\ub294 \ucda9\ubd84\ud558\uc9c0 \uc54a\ub2e4. \ub2e4\uc74c \uc9c0\ud45c\ub97c \ud568\uaed8 \ud655\uc778\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc694\uccad\uc758 p95 \ubc0f p99 \uc751\ub2f5 \uc2dc\uac04<\/li>\n\n\n\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \uc2e4\ud589 \uc2dc\uac04<\/li>\n\n\n\n<li>\ucd08\ub2f9 \ucc98\ub9ac \uc694\uccad \uc218<\/li>\n\n\n\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc0ac\uc6a9\ub7c9<\/li>\n\n\n\n<li>CPU\uc640 \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9<\/li>\n\n\n\n<li>\ucffc\ub9ac \uc218\uc640 \uc624\ub958\uc728<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub3d9\uc77c\ud55c \ub370\uc774\ud130\uc640 \ub3d9\uc77c\ud55c \ucffc\ub9ac \uc870\uac74\uc73c\ub85c Prisma\uc640 \uc9c1\uc811 SQL\uc744 \ube44\uad50\ud574\uc57c \uc758\ubbf8 \uc788\ub294 \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Prisma\ub780? Prisma\ub294 Node.js\uc640 TypeScript \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud3b8\ub9ac\ud558\uac8c \ub2e4\ub8f0 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\ub294 ORM(Object-Relational Mapping) \ub3c4\uad6c\ub2e4. ORM\uc740 \uac1d\uccb4\uc9c0\ud5a5 \ud504\ub85c\uadf8\ub798\ubc0d\uc758 \uac1d\uccb4\uc640 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uc744 \uc5f0\uacb0\ud558\ub294 \uae30\uc220\uc774\ub2e4. \uac1c\ubc1c\uc790\uac00 SQL\uc744 \uc9c1\uc811 \uc791\uc131\ud558\ub294 \ub300\uc2e0 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc758 \uac1d\uccb4\uc640 \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0 \uc0dd\uc131\ud558\uac70\ub098 \uc218\uc815\ud560 \uc218 \uc788\ub2e4. Prisma\ub294 \uc2a4\ud0a4\ub9c8\ub97c \uae30\ubc18\uc73c\ub85c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uc815\uc758\ud558\uace0, \uc774\ub97c \ubc14\ud0d5\uc73c\ub85c \ud0c0\uc785\uc774 \uc9c0\uc815\ub41c Prisma Client\ub97c \uc0dd\uc131\ud55c\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2743","post","type-post","status-publish","format-standard","hentry","category-dev-logs"],"_links":{"self":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2743"}],"version-history":[{"count":2,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2743\/revisions"}],"predecessor-version":[{"id":2745,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2743\/revisions\/2745"}],"wp:attachment":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}