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?
Prisma 란 무엇인지 설명하는 1분 영상
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?
Prisma Js 추천 강의
Create / Read / Update / Delete 방법
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.
필드 전체가 아닌 일부만 선택해서 가져오는 방법
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.
관계를 통한 쿼리 방법 (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.
필터링 및 정렬방법
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.
Decimal, BigInt, Bytes 타입 입력 방법
Json 타입 입력 방법
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.
쿼리 결과물이 많을때 페이지로 쪼개서 조금씩 짤라오는 방법
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 .
데이터 통계, 그룹핑 방법
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.
로우 쿼리 전송 방법
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.