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.
- Free database provisioning
- Pre defined model schema templates
- Run and test Prisma Queries on the data
- Collaboration between team members
- Data browsing capabilities
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 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.
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.
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.
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:
This ER Diagram is generated using:
The Prisma on cloud contains several functionalities such as
- Guide to Local Setup
- Data browser (Prisma Studio)
- Query Console
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.
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.
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.
The Query console supports code highlighting, auto complete, auto saves queries and also code linting features.
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.
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.
- 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]
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.
Check out my previous blog on Prisma MongoDB Connector here.