Tutorials matching "prisma"

32 articles found.

Logging with Prisma

Using a debugger with an application running locally on our machine is a great way to troubleshoot. Unfortunately, we can’t do that with a deployed app. To be…

7 min read

Introduction to Prisma with PostgreSQL

So far, in this series, we’ve been using TypeORM to manage our data and connect to our Postgres database. In this article, we look into Prisma, which is a…

7 min read

Filtering records with Prisma

Filtering records is one of the essential skills to have when working with SQL databases. In this article, we’ll implement various examples using NestJS and…

6 min read

Recursive relationships with Prisma and PostgreSQL

When we work with SQL databases, we usually create tables that relate to each other in some way. Managing those relationships is one of the most fundamental…

6 min read

Database migrations with Prisma

One of the characteristics of relational databases is a strict data structure. We need to specify the shape of every table with its fields, indexes, and…

7 min read

Writing transactions with Prisma

As web developers, one of our primary concerns is keeping the integrity of our data. Fortunately, SQL databases come equipped with tools that allow us to…

7 min read

Integration tests with Prisma

In the previous part of this series, we learned how to write unit tests in a NestJS project with Prisma. Unit tests help verify if individual components of our…

6 min read

Getting distinct records with Prisma and PostgreSQL

PostgreSQL allows us to filter a query’s results and ensure we don’t get duplicate rows. This can be helpful when your table has many rows where the data in…

6 min read

Raw SQL queries with Prisma and PostgreSQL range types

While Prisma gradually adds various features, PostgreSQL still has a lot of functionalities that Prisma does not support yet. One of them is range types. In…

7 min read

Serializing the response with Prisma

When fetching data from the database, we do not always want to present it to the user in the original form. When working with NestJS, the most popular way of…

5 min read

Constraints with PostgreSQL and Prisma

One of the most important aspects of working with a database is ensuring the stored information is correct. One of the fundamental ways of doing that is by…

7 min read

Arrays with PostgreSQL and Prisma

PostgreSQL stands out as a feature-reach solution among other relational databases. Most of the column types available in PostgreSQL allow storing a single…

6 min read

Date and time with Prisma and PostgreSQL

Storing date and time in our database might be tricky, but it is essential to get it right. In this article, we tackle this issue using PostgreSQL and Prisma.…

7 min read

Implementing soft deletes with Prisma and middleware

When developing our REST APIs, we often focus on implementing the four fundamental operations: creating, reading, updating, and deleting (CRUD). The most basic…

7 min read

Writing unit tests with Prisma

Covering our NestJS application with unit tests can help us create a reliable product. In this article, we introduce the idea behind unit tests and implement…

6 min read

Managing PostgreSQL relationships with Prisma

As applications grow, the number of different entities also increases. A crucial part of learning how to design a database is creating relationships between…

7 min read

Polymorphic associations with PostgreSQL and Prisma

Often, we might have a situation where a single entity, such as a comment, needs to be associated with more than one type of table. For example, the user might…

7 min read

Using multiple PostgreSQL schemas with Prisma

In PostgreSQL, schemas act as namespaces within the database and are containers for objects such as tables and indexes. In this article, we explain how they…

7 min read

Aggregating statistics with PostgreSQL and Prisma

We can learn much about how users use our app by looking at our database. With this information, we can improve the experience of the users of our application.…

6 min read

Offset and keyset pagination with Prisma

The bigger our database, the more we need to care about the performance. Returning too much data at once through our API might not be the best approach when it…

8 min read

Improving performance through indexes with Prisma

The bigger our database, the more we need to care about its performance. A common way of improving it is through indexes. Therefore, this article introduces…

6 min read

Node.js Digest #25: Anthropic and Bun, Prisma 7, TypeScript News, and Plenty on Security

Node.js Digest #25 by Oleksandr Zinevych

6 min read

Using UUID as primary keys with Prisma and PostgreSQL

Each record in our database should have a unique identifier. Typically, we use a numerical sequence to generate them. However, we can use an alternative…

7 min read

Introducing database normalization with PostgreSQL and Prisma

Database normalization is a common topic in database design discussions. However, it’s usually explained using complicated terms, making it hard to understand.…

6 min read

Managing JSON data with PostgreSQL and Prisma

Relational databases such as PostgreSQL are great for storing structured data. This approach has many advantages, but it can lack flexibility. On the other…

6 min read

Referential actions and foreign keys in PostgreSQL with Prisma

A foreign key is a column that connects two tables. A constraint keeps this connection in check, and PostgreSQL ensures the foreign keys point to the correct…

7 min read

Modifying data using PUT and PATCH methods with Prisma

Developing a REST API requires us to create endpoints using various HTTP methods such as GET, POST, and DELETE. People utilizing our API expect that making a…

7 min read

The data types to store money with PostgreSQL and Prisma

Managing money is a part of developing web applications that we can’t cut corners on. This article explores various data types built into PostgreSQL and Prisma…

7 min read

Node.js Digest #16: JavaScript vs Oracle, 10 Years of AWS Lambda, Ghost Engineers, Prisma 6

Node.js Digest #16 by Oleksandr Zinevych

9 min read

Type-safe SQL queries with Kysely and PostgreSQL

Object-Relational Mapping (ORM) libraries such as Prisma and TypeORM can help us produce code faster by avoiding writing SQL queries. They have a smaller…

6 min read

SQL transactions with Kysely

The integrity of our data should be one of the primary concerns of web developers. Thankfully, SQL databases equip us with tools that we can use to ensure the…

6 min read

Identity columns with the Drizzle ORM and PostgreSQL

Most of our SQL tables contain the ID column, which acts as a primary key and uniquely identifies each row. Historically, the most common way of defining them…

5 min read