Prisma the ORM that node was waiting for

Transcript

1. Prisma the ORM that node was waiting for Luca Del Puppo
2. 1. What is it? 2. CLI 3. Data Modeling 4. Generation Agenda Prisma the ORM that node was waiting for 5. Client 6. Migration 7. Deploy 8. Conclusion
3. Who I am Luca Del Puppo 
 (aka Puppo)
 Full-Stack Developer in Flowing a Claranet Italian Company @puppo92
 https://www.linkedin.com/in/lucadelpuppo/
 luca@delpuppo.net
4. What is it? 1
5. Prisma is an open source next-generation ORM. (Node eco-system)
6. Prisma Client Auto-generated and type-safe query builder for Node.js & TypeScript
7. Prisma Migrate Migration system
8. Prisma Studio GUI to view and edit data in your database
9. Where it is positioned Productivity 0 10 Control 0 12 ORM Prisma SQL Query Build Plain SQL Min - Healty Constraint - Max
10. ➔ PostgreSQL ➔ MySQL ➔ SQLite ➔ Microsoft SQL Server ➔ MongoDB ➔ CockroachDB Providers
11. Prisma the ORM that node was waiting for
12. CLI 2
13. npm install prisma
14. Create project npx prisma init --datasource-provider PostgreSQL
15. generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL") } Prisma File
16. model Ingredient { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt pizzaIngredients PizzaIngredient[] @@map("INGREDIENTS") } export type Ingredient = { id: number name: string createdAt: Date updatedAt: Date } Generate Types & Client
17. ➔ Generate ➔ Apply ➔ Create Migrations
18. Data Modeling 3
19. ➔ One file (schema.prisma) ➔ Data sources ➔ Generators ➔ Data model definition ➔ Syntax - PSL (Prisma Schema Language) N.B. Multiple Files is not supported yet Schema
20. generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL") } Generator & DataSource
21. model Ingredient { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt pizzaIngredients PizzaIngredient[] @@map("INGREDIENTS") } First look to the model
22. model PizzaIngredient { ingredientId Int pizzaId Int pizza Pizza @relation( fi elds: [pizzaId], references: [id]) ingredient Ingredient @relation( fi elds: [ingredientId], references: [id]) @@id([pizzaId, ingredientId]) @@map("PIZZA_INGREDIENTS") } First look to the relations
23. Generation 4
24. Convert schema to ts types npx prisma generate Generation
25. ➔ Models ๏ Convert Models to Typescript Types ➔ Client ➔ Query Models (type safe) ๏ Constraint to build where clause ๏ Constraint to build select ๏ Constraint to build insert/update/delete with relation What does it generate?
26. Client 5
27. npm install @prisma/client N.B. auto install by the CLI after the first generation
28. const prisma = new PrismaClient(); await prisma.$connect(); const pizza = await prisma.pizza.findUnique({ where: { id: id, }, include: { pizzaIngredients: { include: { ingredient: true, }, }, }, }); How to use the client?
29. Crud SQL\Prisma Single Multiple Insert create createMany Update update updateMany Delete delete deleteMany Select findUnique/ findFirst findMany Insert/Update upsert -
30. ➔ Aggregate ➔ Count ➔ GroupBy Aggregation
31. One for each model
32. Migration 6
33. Migration Developer Prisma Schema Prisma CLI Database 1. update 2. prisma migrate dev 3. read schema 4. database schema 5. generate migration 6. update database
34. Introspection Developer Prisma Schema Prisma CLI Database 1. Change database schema (SQL) 2. prisma db pull 3. Reads database schema 4. Database schema 5. Updates
35. ➔ MongoDb is not supported (use `prisma db push`) ➔ Switch DB Provider is not supported Limitations
36. Prisma exposes us a command for seeding the db • It runs on • prisma migrate dev • prisma migrate reset • manually • It can be written in typescript, go, sql… • ‘--skip-seed’ allows skipping Seeding
37. Deploy 7
38. `npx prisma migrate deploy` Deploy N.B. Use a CI/CD flow for your deployment
39. Conclusion 8
40. • Newby • Don’t manage multiple provider concurrency • Splitting schema not implemented out-of-the-box (prisma-aurora) Cons
41. • Wonderful developer experience • Type safe queries • Migrations • Custom queries • Active Community • Awesome documentation • Core team active in Github and Slack Pros
42. It's Prisma Time Prisma the ORM that node was waiting for
43. Project Example Prisma the ORM that node was waiting for Prisma in the air
44. That’s all folks Luca Del Puppo
 
 @puppo92
 https://www.linkedin.com/in/lucadelpuppo/
 luca@delpuppo.net
45. Q&A Time