Series: API with NestJS


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

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


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

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


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

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