Object–relational mapping and query builder battle 1: Intro to Prisma

Transcript

1. 0 Object‒relational mapping and query builder battle 1: Intro to Prisma 2024-06-21 第95回NearMe技術勉強会 Cyan
2. 1 What is ORM(Object‒relational mapping)? The way we want to interact with data The way data is stored in sql database
3. 2 Prisma Syntax https://www.prisma.io/docs/orm/ove rview/introduction/what-is-prisma
4. 3 Prisma Workflows 1. Schema Center 2. Database Center https://www.prisma.io/docs/orm/ove rview/introduction/what-is-prisma
5. 4 Prisma Architecture https://www.prisma.io/docs/orm/mor e/under-the-hood/engines
6. 5 Let’s see an example
7. 6 Prisma Schema # clone the repo git clone git@github.com:yukimotochern/nearme-study -session.git # install npm install
8. 7 Start Database and Migrate cd projects/orm-battle || exit // start database docker compose up -d // migrate schema npx nx migrate prisma // build server npx nx build prisma // run server npx nx serve prisma
9. 8 Prisma Queries `projects/orm0620/prisma/src/app/routes/root.ts`
10. 9 Prisma Queries (conti.)
11. 10 Prisma Pros and Cons - Pros - Totally Type Safe - Clear and concise database schema with great IDE support - Documentation is EXTRAORDINARY. - Database agnostic schema definition for basic usage - `Select` only required information => performance++ - No more `select * from` - Cons - Another Rust client that might have overhead - Additional client generating process - Hard to extend => prisma-zod generator was buggy when I used it.
12. 11 Thank you