Prisma

November 1, 2024 | seedling, permanent

tags :

Summary ORM #

URL Add Prisma ORM to your application in a few minutes to start modeling your data, run schema migrations and query your Database.

Prisma makes working with databases easy

Github #

prisma repos, github Next-generation ORM for NodeJS & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQlite, MongoDB and CockroachDB github very popular

Supported Database #

PostgreSQL #

MySQL #

mssql #

MongoDB #

Migrations #

ref

schema.prisma

model Post
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  title     String   @db.VarChar(255)
  content   String?
  published Boolean  @default(false)
  author    User     @relation(fields: [authorId], references: [id])
  authorId  Int


model Profile
  id     Int     @id @default(autoincrement())
  bio    String?
  user   User    @relation(fields: [userId], references: [id])
  userId Int     @unique


model User
  id      Int      @id @default(autoincrement())
  email   String   @unique
  name    String?
  posts   Post[]
  profile Profile?

To map your data model to the database schema, you need to use the prisma migrate CLI commands:

npx prisma migrate dev --name init

This command does two things:

It creates a new SQL migration file for this migration
It runs the SQL migration file against the database

OCR of Images #

2024-05-30_16-22-00_screenshot.png #

prisma Public Watch 237 - Fork 1.5k Star 37.7k 8 main P 205 Branches 187 Tags Q Go to file L Add file <> Code About Next-generation ORM for Node.js & renovate(bot] chore(deps): update dependency @microsort/api-extra.. X 941e422 4 hours ago 10,772 Commits TypeScript I PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB 1 devcontainer ci: pin pnpm to 8.15.5 (#23691) last month and CockroachDB .github chore(deps): update rhysd/actionlint docker tag to v1.7.1... yesterday C www.prisma.io .husky chore(deps): update dependency husky to v9 #22805) 4 months ago nodejs javascript mysql postgres mongo typescript sql-server orm database mongodb sqlite vscode ci: Check for prettier formatting on GH Actions (#21188) 8 months ago docker chore(deps): update Vilesstesserver.mysgbo docker... yesterday postgresql mariadb query-builder mssql sqlserver mongodb-orm cockroachdb prisma prisma-client eslint-local-rules chore(deps): update typescript-eslint monorepo to v6 (-.. 7 months ago examples chore: remove examples, link to docs (#9657) 3 years ago Readme

2024-05-30_16-15-20_screenshot.png #

Set up Prisma ORM from scratch with your favorite database and learn basic workflows like data modeling, querying, and migrations. à MySQL. *