๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

๊ฐœ๋…์ •๋ฆฌ14

UUID(Universally Unique Identifier) : ๊ณ ์œ  ID ์ƒ์„ฑ ์˜์–ดํ•œ๊ตญ์–ด์ผ๋ณธ์–ด์ค‘๊ตญ์–ด (๊ฐ„์ฒด)์ค‘๊ตญ์–ด (๋ฒˆ์ฒด)๋ฒ ํŠธ๋‚จ์–ด์ธ๋„๋„ค์‹œ์•„์–ดํƒœ๊ตญ์–ด๋…์ผ์–ด๋Ÿฌ์‹œ์•„์–ด์ŠคํŽ˜์ธ์–ด์ดํƒˆ๋ฆฌ์•„์–ดํ”„๊ฐ•์Šค์–ด๋ณต์‚ฌํ•˜๊ธฐ ์ด ํ™•์žฅ์„ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค ๐Ÿ“š UUID(Universally Unique Identifier) : ๊ณ ์œ  ID ์ƒ์„ฑ ๊ธฐ๋Šฅ๊ณ ์œ  ๋ฌธ์ž์—ด ์‹๋ณ„์ž ์ƒ์„ฑ๊ธฐ(unique string ID generator) -- ๐Ÿ”Ž UUID, NanoID128-bit์˜ ๊ณ ์œ  ์‹๋ณ„์ž5๊ฐœ์˜ ๋ฒ„์ „์‚ฌ์šฉํ•˜๋Š” ์ด์œ ๊ณ ์œ ํ•œ ID / key๋ฅผ ๋ฐœ๊ธ‰ํ•ด์„œ ๋ณด์•ˆ์ ์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฅผ ๊ตฌ๋ถ„ ์ง“๋Š” ์šฉ์œผ๋กœ ์‚ฌ์šฉํ•œ๋‹ค.  [npm] UUID์‚ฌ์šฉ๋ฒ•uuid npm ํŒจํ‚ค์ง€ ์„ค์น˜ : https://www.npmjs.com/package/uuiduuid ๋ฅผ import ํ•˜์—ฌ์„œ ๋žœ๋คํ•˜๊ฒŒ ๊ณ ์œ ํ•œ ID ๋ฅผ ๊ฐ€์ง€๊ณ  ์˜ฌ ์ˆ˜ ์žˆ๋‹ค. ⇒ import { v1 } from "uuid".. 2025. 2. 26.
API ๋™์ž‘ ๋ฐฉ์‹ ๐Ÿš€ API (Application Programming Interface)์‚ฌ๋žŒ๋“ค์ด ๊ณตํ†ต์ ์œผ๋กœ ํ•„์š”๋กœ ํ•˜๋Š” ๊ธฐ๋Šฅ์„ ๊ตฌํ˜„ํ•ด ๋‘๊ณ , ์‚ฌ์šฉ์ž์˜ ์š”์ฒญ์— ์˜ํ•ด์„œ์‚ฌ์šฉ์ž๋Š” ๊ตฌํ˜„ํ•ด ๋‘” ๊ธฐ๋Šฅ์„ ์ œ๊ณต์ž๋กœ๋ถ€ํ„ฐ ์ œ๊ณต๋ฐ›์•„์„œ ์‚ฌ์šฉํ•˜๋Š” ์ผ๋ จ์˜ ๊ณผ์ • ๐Ÿ“ API ์šฐ๋ฆฌ๊ฐ€ ๋งŒ๋“ค์–ด๋‘” ๊ธฐ๋Šฅ์„ ๊ฐ€์ ธ๋‹ค ์“ฐ์„ธ์š” !โš™ API ๋™์ž‘ ๋ฐฉ์‹(1) ์›ํ•˜๋Š” API๋ฅผ ์ œ๊ณตํ•˜๋Š” ํšŒ์‚ฌ์—(2) API ๋ฌธ์„œ์— ์ž‘์„ฑ๋œ ์š”์ฒญ ๋ฐฉ์‹์— ๋งž๊ฒŒ ๋ฐ์ดํ„ฐ๋ฅผ ๋˜์ง€๋ฉด(Request)(3) API๋ฅผ ์ œ๊ณตํ•˜๋Š” ํšŒ์‚ฌ์—์„œ ํ•ด๋‹น ๋ฐ์ดํ„ฐ๋ฅผ ๊ธฐ๋ฐ˜์œผ๋กœ ์ž์‚ฌ API ์„œ๋ฒ„์— ์กด์žฌํ•˜๋Š” ์›ํ•˜๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ์‘๋‹ต(Response)ํ•˜์—ฌ ํด๋ผ์ด์–ธํŠธ์—๊ฒŒ ์ œ๊ณต์ด๋ฏธ์ง€ ์ถœ์ฒ˜ :https://www.geeksforgeeks.org/what-is-an-api/ What is an API (Application Progra.. 2025. 2. 11.
SQL ON UPDATE CASCADE : ์™ธ๋ž˜ํ‚ค ์—ฐ๊ฒฐ ์‹œ ๋™๊ธฐํ™” ๐Ÿ”Ž SQL DDL ๊ตฌ์„ฑํ•˜๋‹ค๊ฐ€ ref๋กœ ์—ฐ๊ฒฐ๋œ key์— ํ•ด๋‹น ์†์„ฑ ์˜๋ฌธ ON UPDATE CASCADEON UPDATE CASCADE๋Š” ์™ธ๋ž˜ ํ‚ค ์ œ์•ฝ ์กฐ๊ฑด(Foreign Key Constraint)์—์„œ ์‚ฌ์šฉ๋˜๋Š” ์˜ต์…˜์œผ๋กœ, ์ฐธ์กฐ๋˜๋Š” ๋ถ€๋ชจ ํ…Œ์ด๋ธ”์˜ ๊ธฐ๋ณธ ํ‚ค(Primary Key) ๊ฐ’์ด ๋ณ€๊ฒฝ๋  ๋•Œ ์ž๋™์œผ๋กœ ์ž์‹ ํ…Œ์ด๋ธ”์˜ ์™ธ๋ž˜ ํ‚ค(Foreign Key) ๊ฐ’๋„ ํ•จ๊ป˜ ์—…๋ฐ์ดํŠธ๋˜๋„๋ก ํ•˜๋Š” ์„ค์ •์ด๋‹ค. ์ด๋ฅผ ํ†ตํ•ด ์ฐธ์กฐ ๋ฌด๊ฒฐ์„ฑ(Referential Integrity)์„ ์œ ์ง€ํ•  ์ˆ˜ ์žˆ๋‹ค.๋‹ค์Œ์€ ์ด๋ฅผ ์„ค๋ช…ํ•˜๋Š” ์˜ˆ์‹œ์™€ ํ•จ๊ป˜ ๋ช‡ ๊ฐ€์ง€ ์ž์„ธํ•œ ๋‚ด์šฉ์„ ํฌํ•จํ•œ ์„ค๋ช…์ด๋‹ค:์˜ˆ์‹œ๋จผ์ €, ๋‘ ํ…Œ์ด๋ธ” MEMBER์™€ STORE๊ฐ€ ์žˆ๋‹ค๊ณ  ๊ฐ€์ •ํ•œ๋‹ค:CREATE TABLE MEMBER ( id INT PRIMARY KEY, name VARC.. 2024. 6. 20.
NEXT.js import NextApiRequest / NextRequest ์ฐจ์ด์  Q. import { NextApiRequest, NextApiResponse } from "next"import { NextRequest, NextResponse } from "next/server" import ์ฐจ์ด?  CAHT.Next.js์˜ app ๋””๋ ‰ํ† ๋ฆฌ์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ผ์šฐํŒ… ๋ฐฉ์‹๊ณผ pages ๋””๋ ‰ํ† ๋ฆฌ์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ผ์šฐํŒ… ๋ฐฉ์‹์€ ์•ฝ๊ฐ„ ๋‹ค๋ฅด๋‹ค. ๊ฐ ๋ผ์šฐํŒ… ๋ฐฉ์‹์—์„œ ์‚ฌ์šฉ๋˜๋Š” import ๋ฌธ๋„ ๋‹ค๋ฅด๋‹ค. ์ด ๋‘ ๊ฐœ์˜ import ์ฐจ์ด์— ๋Œ€ํ•ด ์„ค๋ช…ํ•˜๊ฒ ๋‹ค.1. NextApiRequest์™€ NextApiResponse (Pages ๋””๋ ‰ํ† ๋ฆฌ)NextApiRequest์™€ NextApiResponse๋Š” Next.js์˜ pages ๋””๋ ‰ํ† ๋ฆฌ์—์„œ API ๋ผ์šฐํŠธ๋ฅผ ์ •์˜ํ•  ๋•Œ ์‚ฌ์šฉ๋œ๋‹ค. ์ด ๋ฐฉ์‹์€ Next.js 12 ์ด์ „๋ถ€.. 2024. 6. 14.
728x90
๋ฐ˜์‘ํ˜•