Series: API with NestJS

NestJS

API with NestJS #131. Unit tests with PostgreSQL and Kysely

This entry is part 131 of 186 in the API with NestJS

Creating tests is essential when trying to build a robust and dependable application. In this article, we clarify the concept of unit tests and demonstrate how to write them for our application that interacts with PostgreSQL and uses the Kysely library. Explaining unit tests A unit test ensures that a specific part of our code […]

NestJS SQL

API with NestJS #132. Handling date and time in PostgreSQL with Kysely

This entry is part 132 of 186 in the API with NestJS

Saving date and time in our database can be tricky, but it’s crucial to do it correctly. In this article, we address this problem using PostgreSQL and Kysely. We also explore time zones and how to handle them when designing our database. Dates in PostgreSQL We can determine how our database handles dates by examining […]

NestJS SQL

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

This entry is part 133 of 186 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 […]

NestJS

API with NestJS #138. Filtering records with Prisma

This entry is part 138 of 186 in the API with NestJS

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 Prisma to show how to filter the data in different cases. Thanks to that, we will learn how to find precisely the data we need quickly and easily. Implementing a […]

NestJS SQL

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

This entry is part 139 of 186 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 #140. Using multiple PostgreSQL schemas with Prisma

This entry is part 140 of 186 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 […]