Prisma vs Drizzle: Comparing the Top Type-Safe ORMs

Install Dependencies and Set Up Initial Files

Let's start out by installing all of the dependencies we'll need for working with both Prisma and Drizzle throughout the series. We'll also create a couple files where we'll do our querying work later.

Create the Prisma and Drizzle Databases

In this lesson, let's get two databases set up: one specifically for Prisma and the other for Drizzle. Having two separate databases will allow us to work independently on datasets that are well suited for both ORMs.

Seed the Prisma Database

In this lesson, let's add a script which will seed the Prisma database with some test data. We'll work with this data throughout the series.

Seed the Drizzle Database

We'll want to seed our Drizzle database with some test data, much like we did with our Prisma database. In this case, let's use a SQL script to add data in.

Run a Simple Find Query with Prisma

The best way to get a sense of how to use the Prisma Client is to run a simple query with it. In this lesson, let's see how to perform a findMany query to get some data back from our Prisma database.

Run a Simple Find Query with Drizzle

Drizzle offers two different ways to access data: through SQL-like operators and using the relational query API. Let's take a look at both options and how they work in this lesson.

Handling Relations with Prisma

Prisma offers an elegant syntax for defining relations using the Prisma Schema Language. Let's see how to use those defined relations when querying for data in this lesson.

Handling Relations with Drizzle

Using Drizzle, we can query for data related to a given table just by using one of the join operators if we're using its SQL-like syntax. We can also set up our Drizzle schema to have relations be explicitly defined so that we can bring related data together when using the relational query API. Let's take a look at the options in this lesson.

One to Many Relations with Drizzle

Drizzle has several operators to handle relations, including the 'one' and 'many' operators to establish one-to-one and one-to-many relations. Let's get a sense of how to use them in this lesson.

Many to Many Relations with Drizzle

If we want to use Drizzle's relational query API to do many-to-many relation queries, we need to have the proper set up in our schema file. In this lesson we'll see all of the pieces that are necessary for setting up our schema to be able to make queries using the 'with' operator in our findMany and findFirst calls.

All Prisma CRUD Operators

Prisma offers operators for creating, reading, updating, and deleting data all on the Prisma Client that we generate from our schema. Let's go over these operators and how to use them to see the full picture for how we'd handle CRUD operations in our apps.

All Drizzle CRUD Operators

When doing read queries with Drizzle, we have the option of using their SQL-like operators or using the relational query API. When it comes to creating, updating, and deleting data, the only option as of now is to use the SQL-like operators. Let's see how to do so in this lesson.

Using Prisma and Drizzle Studio

Both Prisma and Drizzle offer a product called Studio which is a modern table editor in the browser. Studio is useful for reading and editing data and can be used against our local databases or our remote deployments. Let's take a look at how to launch Studio with Prisma and Drizzle and how it operates in the browser.

Using Prisma and Drizzle Migrate

Migrations are a key concept and strategy for tracking how a database's changes over time. In this lesson, let's take a look at how to manage migrations with Prisma and Drizzle and why we would want to use migrations over the simpler db push command.