Setting up Prisma with Rocetta

Rocetta: Setting up databases with Prisma

Deploying a database with Rocetta

1. Go to the Database page of the console.

2. Click Deploy new database

3. Choose your desired database parameters: select the provider of your choice: AWS or GCP. Then select the database type: MySQL or PostgreSQL. Modify the database size and region if you want.
1. Please note there are slight differences in using Prisma between Postgres and MySQL. Learn more here. We suggest using Postgres.
2. Size is always upgradable, so start with small or extra small if you are starting out.
3. You cannot change the region. Choose a region near your customers.

4. Click deploy!

5. Once the database is running, you can get the database URL by clicking on the three dots on the right side of the database card. Choose Copy Database URL on the menu that appears. Click the black Copy button, then close.

Setting up and Connecting Prisma

1. Run the following set of scripts. This creates a new directory for your project, initializes a typescript project, and adds the Prisma CLI as a dependency. Finally, the last command creates a new Prisma schema file.

$ mkdir my-prisma-project
$ cd my-prisma-project
$ npm init -y
$ npm install prisma typescript ts-node @types/node --save-dev
$ npx tsc --init
$ npx prisma init

1. Connect your database by pasting your database URL (see “Deploying a database with Rocetta”) as an environment variable within your .env file. We will also have to make some modifications, listed below:
1. Rocetta generates a database URL with format: <type>://<user>:<password>@<endpoint>:<port>/<name>.

DATABASE_URL="YOUR_DB_URL_HERE"

b. In the schema/schema.prisma file, you will have to modify the datasource db variable to contain the provider of your choice: “postgressql” or “mysql”

generator client {
  provider = "prisma-client-js"
}

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