Prisma Js 추천 강좌

Database 란 무엇인지 설명하는 설명서

📖

데이터베이스에 대한 초기 설명이 더 필요한 경우, 아래 문서를 참조해주세요.

Intro, Data Modeling, Databases | Prisma's Data Guide

Learn the basics of what databases are, why they are so important for most software, and which types of databases are best for different use cases. Start from the fundamentals to give yourself a solid foundation. What are databases?

https://www.prisma.io/dataguide/

Prisma 란 무엇인지 설명하는 1분 영상

📖

Prisma 란 무엇인지 상세한 설명이 필요한 경우, 아래 문서를 참조해주세요.

What is Prisma? (Overview)

This page gives a high-level overview of what Prisma is and how it works. If you want to get started with a practical introduction and learn about the Prisma Client API, head over to the Quickstart . To learn more about the motivation for Prisma, check out the Why Prisma?

https://www.prisma.io/docs/concepts/overview/what-is-prisma

Prisma Js 추천 강의

📖

Prisma 개발사에서 제공하는 공식 강의 목록들중 추천하는 강의 목록 입니다. 브라우저 번역기를 통해서 내용을 읽어주시면 보다 수월하게 읽으실수 있습니다.

Create / Read / Update / Delete 방법

CRUD (Reference)

This page describes how to perform CRUD operations with your generated Prisma Client API. CRUD is an acronym that stands for: Refer to the Prisma Client API reference documentation for detailed explanations of each method.

https://www.prisma.io/docs/concepts/components/prisma-client/crud

필드 전체가 아닌 일부만 선택해서 가져오는 방법

Select fields (Concepts)

This page explains how to select only a subset of a model's fields and/or include relations ("eager loading") in a Prisma Client query.

https://www.prisma.io/docs/concepts/components/prisma-client/select-fields

관계를 통한 쿼리 방법 (leftJoin 과 유사)

Relation queries (Concepts)

A key feature of Prisma Client is the ability to query relations between two or more models. Relation queries include: Prisma Client also has a fluent API for traversing relations. Nested reads allow you to read related data from multiple tables in your database - such as a user and that user's posts.

https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries

필터링 및 정렬방법

Filtering and sorting (Concepts)

Prisma Client supports filtering and sorting with the where and orderBy query options respectively. Prisma Client allows you to filter records on any combination of model fields, including related models, and supports a variety of filter conditions.

https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting

Decimal, BigInt, Bytes 타입 입력 방법

Working with fields (Concepts)

How to read, write, and filter by complex fields.

https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields

Json 타입 입력 방법

Working with Json fields (Concepts)

How to read, write, and filter by Json fields.

https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields

Scalar 타입 (범위가 정해져있는 유형) 입력방법

Working with scalar lists/arrays (Concepts)

The following example demonstrates how to the value of a scalar list ( coinflips) when you create a model: This method is available on MongoDB only in versions 3.11.1 and later. The following example demonstrates how to the value of a scalar list ( coinflips): Unlike set: null, unset removes the list entirely.

https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-scalar-lists-arrays

쿼리 결과물이 많을때 페이지로 쪼개서 조금씩 짤라오는 방법

Pagination (Reference)

Prisma Client supports both offset pagination and cursor-based pagination. Offset pagination uses skip and take to skip a certain number of results and select a limited range. The following query skips the first 3 Post records and returns records 4 - 7: const results = await prisma . post .

https://www.prisma.io/docs/concepts/components/prisma-client/pagination

데이터 통계, 그룹핑 방법

Aggregation, grouping, and summarizing (Concepts)

Prisma Client allows you to count records, aggregate number fields, and select distinct field values. Prisma Client allows you to on the number fields (such as Int and Float) of a model. The following query returns the average age of all users: You can combine aggregation with filtering and ordering.

https://www.prisma.io/docs/concepts/components/prisma-client/aggregation-grouping-summarizing

로우 쿼리 전송 방법

Raw database access (Reference)

Prisma Client supports the option of sending raw queries to your database. You may wish to use raw queries if: you want to run a heavily optimized query you require a feature that Prisma Client does not yet support (please consider raising an issue) Raw queries are available for all relational databases Prisma supports.

https://www.prisma.io/docs/concepts/components/prisma-client/raw-database-access