Prisma

A collection of 10 posts

Photo by Charlotte Boyle / Unsplash

Apply database migrations to PlanetScale from GitHub Actions

This post shows how to build a CI/CD pipeline with GitHub Actions to deploy a database migration in a production database hosted on PlanetScale.

Photo by Uriel SC / Unsplash

Connect a Serverless API to MySQL using the PlanetScale HTTP API

This post shows how to connect a serverless API to a PlanetScale database using the PlanetScale database driver for JavaScript and perform SQL queries.

Photo by Pawel Czerwinski / Unsplash

Build the Docker image of a Node.js project using Prisma

This post will show you how to build the Docker image of a Node.js application that uses Prisma as the ORM to interact with your database. We will publish the image to the Docker Hub

Photo by Bram Bergers / Unsplash

Create a Node.js REST API using Prisma ORM and PlanetScale

This post shows you how to build a Node.js REST API using Prisma, an ORM allowing you to interact with a MySQL database managed by PlanetSCale

Photo by NEOM / Unsplash

Handle database transactions in Node.js with Prisma ORM

A database transaction is an execution of many operations (insert, update, or delete) as a single unit, taking the database from a consistent state to a consistent one. If one operation fails, all the previous operations are canceled. The properties of a transaction are Atomicity, Consistency, Isolation, and Durability (ACID)

Photo by NEOM / Unsplash

Handle Database data integrity with the Prisma ORM

In this post, we will see how to use Prisma ORM to handle database integrity for databases that don't support foreign keys constraints, such as MySQL Serverless database (PlanetScale) and MongoDB

Photo by Steve Johnson / Unsplash

Handle a Many-to-Many relationship with Prisma and Node.js

In this post, we will see how to create a many-to-many relationship with the Prisma schema and then, create, retrieve and delete data from the database.

Connect a Node.js application with MongoDB using Prisma

Connect a Node.js application with MongoDB using Prisma

In this post, we will see how to use Prisma to define the Schema of our Mongo database and then perform CRUD actions in a Node.js application with Typescript.

Photo by Neil Thomas / Unsplash

Understand the shadow database feature of Prisma ORM

When running a Prisma migration on a cloud-hosted database, you need a shadow database to see your migration succeed. In this post, we will see why it is required.

Photo by Tino Rischawy / Unsplash

Using Prisma ORM to build a Node.js application with MySQL

In this tutorial, we will see how to use Prisma with MySQL by defining our database structure, generating migrations, and performing CRUD operations.