prisma Archives

Prisma

Build an SQL Query from Variables with a Prisma Raw Query (prisma.$queryRaw)

Using prisma.$queryRaw, I was able to write a basic query that returned the data I needed. However, I also needed the query to filter and order the data.

Exploratory Testing

Crafting the Perfect Bug Report – Make Your Issues Count

Here's what I've learned about creating an actionable bug report and why this skill is so vital in a development career.

Development Practices

Achieve Cleaner Test Setup with the Blueprint Pattern

The Blueprint pattern abstracts the creation of data models into reusable, type-safe helpers, reducing boilerplate and improving readability.

Prisma

Build Test Data Factories with Prisma

Why bother with data factories when you can just add whatever data you want in your tests? Creating data on the spot has a few drawbacks.

Prisma

Prisma vs. TypeORM – Which is Right For You?

In my current project, we use two popular ORMs, TypeORM and Prisma. Each one has advantages and disadvantages. But which is right for you?

Prisma

2 Quick and Easy Ways to Set the Environment Database in Prisma

Here are two quick and easy ways to set the environment database in Prisma, methods that don't require writing scripts for dotenv.

Prisma

How and When to Use Multiple Prisma Schemas

We need two schemas generating two separate clients that we can use from our project code. The secret sauce is to create two Prisma schemas.

Prisma

A Simple Rest API Part 3: Documentation with Swagger UI

Use swaggerUI with an OpenAPI specification to automate your API documentation. It allows users to easily interact and consume your API resources.

Prisma

A Simple REST API with Prisma, Part 2: The Server

This series covers building a simple REST API using the Prisma ORM and Postgresql. Here, I'll explain how to use this Prisma client in our express server.

Prisma

A Simple REST API with Prisma, Part 1: The Setup

Let's create a simple REST API with Prisma. Part one of this two-part series will cover how to get a Prisma schema from your Postgresql database.

Platforms & Languages

Prisma Migration on Heroku and NodeJS

Prisma migrations are simple for local development, but what about staging and production on Heroku? Here are three ways to run Prisma migrations on Heroku.

Developer Tools

How to Fix a Prisma Library Load Problem with Cypress on macOS

Here's how to fix the "Unable to Load Node-API Library" error that can come up when trying to use Prisma in Cypress tasks on macOS.