DEV Community

Cover image for Prisma Data Platform - Prisma ORM on Cloud
Somsubhra Das
Somsubhra Das

Posted on

Prisma Data Platform - Prisma ORM on Cloud

Prisma Data Platform is a cloud based service which allows developers to try the Prisma ORM, run queries on cloud environment without the need to install Prisma Client locally on the developers' computer.

Features of Prisma Data Platform

  • Free database provisioning
  • Pre defined model schema templates
  • Run and test Prisma Queries on the data
  • Collaboration between team members
  • Data browsing capabilities

Getting Started

To get started, visit Prisma Data Platform, sign in with your GitHub Account and click on New Project. From here, we may choose to go in two different ways:

  • Create new project from scratch
  • Import existing project from GitHub

Creating Project

Creating a project is simple on Prisma Data Platform. Once you create the project on Prisma Data Platform it will simultaneously create a GitHub Project for it.

Project create

GitHub Project

Creating Database

Prisma Data Platform can automatically spin an app instance on heroku and create a PostgreSQL database instance as well. You may connect to an existing database as well.

Database Creation
PostgreSQL Heroku Add-on

Creating Schema

One of the great features of Prisma Data Platform is that it provides pre written schemas for our database. We can even customise the schema if we want. Also it loads sample data to our database so that we can try out our queries on those data.

Prisma cloud Schema

For this blog, I would be using the URL Shortener template.

Once the schema has been created, it pushes the schema.prisma file to the GitHub Repository and also adds a Readme.md file to the repo which contains all the instructions for setting up and running the project locally and also the Database ER diagram for ready reference like the one shown below:

ER Diagram

This ER Diagram is generated using:

Prisma on Cloud Functionalities

The Prisma on cloud contains several functionalities such as

  • Guide to Local Setup
  • Data browser (Prisma Studio)
  • Query Console

Local Setup

Prisma on Cloud gives a robust documentation to setup the same project on your local development environment with the option to setup local database or connect to a remote database.

Local Setup

Data Browser

Prisma on Cloud provides Prisma Studio out of the box for data browsing on cloud. It helps developers edit data in database tables without a local database client.

Prisma Studio

Query Console

The query console is the heart of Prisma Data Platform. It allows us to write and try out complex queries on the sample dataset. It can even serve as a scratch pad for your queries during the development phase of your application. It helps to instantly get output of a query without having to write APIs and console logs for the same.

Query Console

The Query console supports code highlighting, auto complete, auto saves queries and also code linting features.

Collaborate with users

Prisma on cloud also allows developers to collaborate with fellow developers, just by inviting a GitHub user to the Prisma Project. It also gives various types of permissions for collaborators such as Admin, Developer, Viewer etc which grants restricted access to the Prisma project.

Collaborate

Admins can even modify access of collaborators and can remove them from project if at some point they think it's necessary to do so.

What's next for Prisma Data Platform?

  • Support for other database dialects
  • Multiple environments support to facilitate and organise projects and initiate workflows between them
  • Insights such as query times, generated SQL Script about the Query ran in the Query console
  • Telemetry events integration from Prisma queries to 3rd party external services supporting Open Telemetry Framework
  • Insights about list of queries in the application

[Please note: All the above mentioned points are subject to change and are not guaranteed]

Contribute to Prisma

Prisma ORM is Open Source and available publicly on GitHub. If you want to contribute to the Prisma check out their GitHub Repository by clicking here.

Similar Articles:

Check out my previous blog on Prisma MongoDB Connector here.

Discussion (0)