Category: SQL

NestJS SQL

API with NestJS #140. Using multiple PostgreSQL schemas with Prisma

This entry is part 140 of 146 in the API with NestJS

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 work and what are their benefits. We also provide examples of how to use them with Prisma. The public schema PostgreSQL creates a schema called out of the […]

NestJS SQL

API with NestJS #139. Using UUID as primary keys with Prisma and PostgreSQL

This entry is part 139 of 146 in the API with NestJS

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 approach that includes Universally Unique Identifiers (UUID). In this article, we discuss their advantages and disadvantages and implement them in a project with NestJS, Prisma, and PostgreSQL. For the full […]

NestJS SQL

API with NestJS #133. Introducing database normalization with PostgreSQL and Prisma

This entry is part 133 of 146 in the API with NestJS

Database normalization is a common topic in database design discussions. However, it’s usually explained using complicated terms, making it hard to understand. In this article, we’ll explain what normalization means and give examples using Prisma and PostgreSQL. The goal of database normalization is to enhance the accuracy and minimize the duplication of our data. We […]