Database Overview

By default, Blitz uses Prisma 2 which is a strongly typed database client.

Prisma 2 is not required for Blitz. You can use anything you want, such as Mongo, TypeORM, etc.

Read the Prisma documentation here

Add a Database Table

1. Open db/schema.prisma and add your model(s) like as follows:

model Project {
  id        Int      @default(autoincrement()) @id
  name      String
  tasks     Task[]
}

model Task {
  id          Int      @default(autoincrement()) @id
  name        String
  project     Project  @relation(fields: [projectId], references: [id])
  projectId   Int
}

If you need, reference the Prisma Schema documentation

2. Then run blitz prisma migrate dev in your terminal to apply the changes
3. Now you can import db from db/index.ts and create a model like this:
   • db.project.create({data: {name: 'Hello'}})

Switch to PostgreSQL

By default, a Blitz app is created with a local SQLite database. If you want to use PostgreSQL instead, you need to perform the following steps:

1. Install and run Postgres locally.
2. Open db/schema.prisma and change the db provider value from "sqlite" to "postgres" as follows:

datasource db {
  provider = "postgres"
  url      = env("DATABASE_URL")
}

2. In .env.local, change DATABASE_URL. For convenience, there is a commented-out PostgreSQL DATABASE_URL there already. Depending on your setup, you may need to modify the URL.
3. Update .env.test.local as well to use PostgreSQL in your test runs.
4. Delete the db/migrations folder
5. Run blitz prisma migrate dev. This command will create the database (if it does not already exist) and tables based on your schema.