Category: SQL

NestJS SQL

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 […]

NestJS SQL

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 […]

NestJS SQL

API with NestJS #129. Implementing soft deletes with SQL and Kysely

This entry is part 129 of 136 in the API with NestJS

When working on our REST APIs, we usually focus on implementing the four fundamental operations: creating, reading, updating, and deleting (CRUD). Deleting entities is a common feature in many web applications. The simplest way to do it is by permanently deleting rows from the database. In this article, we use Kysely to explore the idea […]

NestJS SQL

API with NestJS #128. Managing JSON data with PostgreSQL and Kysely

This entry is part 128 of 136 in the API with NestJS

PostgreSQL is great for structured data and is known for its reliability in maintaining data organization and consistency. On the other hand, MongoDB stores data in flexible JSON-like documents, making it ideal for data with varying attributes and evolving requirements. Using SQL has a lot of advantages over MongoDB, but we might need some flexibility […]

NestJS SQL

API with NestJS #127. Arrays with PostgreSQL and Kysely

This entry is part 127 of 136 in the API with NestJS

PostgreSQL outshines various other SQL databases with its feature set. Unlike most SQL databases, PostgreSQL offers extensive support for array columns. Using them, we can store collections of values within a single column without creating separate tables. In this article, we explore the capabilities of arrays in PostgreSQL and implement examples using Kysely. Creating the […]

NestJS SQL

API with NestJS #125. Offset and keyset pagination with Kysely

This entry is part 125 of 136 in the API with NestJS

So far, when working with Kysely, we fetched all rows from our tables. However, this might not be the best solution when it comes to performance. A common approach is to query the data in parts and present the users with separate pages or infinite scrolling. We implement pagination in this article with NestJS, PostgreSQL, […]