NestJS

API with NestJS #173. Storing money with Drizzle ORM and PostgreSQL

This entry is part 173 of 173 in the API with NestJS

We can’t cut corners on certain aspects of web development, and storing monetary values is one of them. In this article, we explore various data types in PostgreSQL we could use and discuss which ones to avoid. The drawbacks of floating point numbers When thinking about money, we often have to deal with fractions – […]

NestJS

API with NestJS #172. Database normalization with Drizzle ORM and PostgreSQL

This entry is part 172 of 173 in the API with NestJS

Database normalization is a key part of database design, but it’s often explained in complicated terms. In this article, we’ll break down the normalization rules and provide down-to-earth examples using Drizzle ORM and PostgreSQL. Database normalization aims to avoid unnecessarily duplicating our data and make it easier to manage. It does that through specific rules […]

NestJS

API with NestJS #171. Recursive relationships with Drizzle ORM and PostgreSQL

This entry is part 171 of 173 in the API with NestJS

Managing relationships between the tables in our database is one of the fundamental aspects of using SQL. When a particular table points back to itself, it creates a recursive relationship. In this article, we learn what the recursive relationships are and how to work with them using the Drizzle ORM and PostgreSQL. We sometimes refer to […]

NestJS

API with NestJS #169. Unique IDs with UUIDs using Drizzle ORM and PostgreSQL

This entry is part 169 of 173 in the API with NestJS

All rows in our database need unique identifiers, typically a sequence of numbers. Alternatively, we can use Universally Unique Identifiers (UUID). In this article, we explore the pros and cons of UUIDs and show how to implement them in a project that uses NestJS, PostgreSQL, and the Drizzle ORM. Introducing UUIDs At this point, we’re […]

Uncategorized

API with NestJS #168. Integration tests with the Drizzle ORM

This entry is part 168 of 173 in the API with NestJS

Writing tests for our application helps ensure it works as intended and is reliable. So far, we have written unit tests for our NestJS application that uses the Drizzle ORM. Unit tests help us check if a particular class of a single function functions properly on its own. While unit tests are important, they are […]

NestJS

API with NestJS #167. Unit tests with the Drizzle ORM

This entry is part 167 of 173 in the API with NestJS

Unit tests play a significant role in ensuring the reliability of our NestJS application. In this article, we’ll explain the concept behind unit testing and learn how to apply it to a NestJS application with the Drizzle ORM. Introduction to unit tests Unit tests allow us to verify that individual parts of our codebase function […]

NestJS

API with NestJS #166. Logging with the Drizzle ORM

This entry is part 166 of 173 in the API with NestJS

Debugging is a great way to find issues when running an application locally. Unfortunately, we don’t have this option in a deployed application. Because of that, implementing logging functionality is necessary to track down and investigate any potential problems. In this article, we learn how to use the logger built into NestJS and integrate it […]