NestJS SQL

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

This entry is part 125 of 126 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, […]

NestJS SQL

API with NestJS #124. Handling SQL constraints with Kysely

This entry is part 124 of 126 in the API with NestJS

When using SQL databases, we can set constraints to ensure our data remains accurate and reliable during insertions, updates, or deletions. In this article, we’ll explore different SQL constraints and demonstrate how to apply them using Kysely and NestJS to maintain data integrity. Check out this repository for the full code from this article. Not-null […]

NestJS SQL

API with NestJS #123. SQL transactions with Kysely

This entry is part 123 of 126 in the API with NestJS

The integrity of our data should be one of the primary concerns of web developers. Thankfully, SQL databases equip us with tools that we can use to ensure the consistency and accuracy of our data. You can see the complete code from this article in this repository. One of the critical situations to consider is […]

NestJS SQL

API with NestJS #122. Many-to-many relationships with Kysely and PostgreSQL

This entry is part 122 of 126 in the API with NestJS

Implementing relationships across tables is a crucial aspect of working with SQL databases. So far, this series covers using Kysely to design simple relationships such as one-to-one and many-to-one. This article looks into many-to-many, which is a slightly more advanced relationship. Check out this repository if you want to see the full code from this […]

SQL

API with NestJS #121. Many-to-one relationships with PostgreSQL and Kysely

This entry is part 121 of 126 in the API with NestJS

Designing relationships is one of the crucial aspects of working with SQL databases. In this article, we continue using Kysely with NestJS and implement many-to-one relationships. Check out this repository if you want to see the full code from this article. Introducing the many-to-one relationship When implementing the many-to-one relationship, a row from the first table […]

NestJS SQL

API with NestJS #119. Type-safe SQL queries with Kysely and PostgreSQL

This entry is part 119 of 126 in the API with NestJS

Object-Relational Mapping (ORM) libraries such as Prisma and TypeORM can help us produce code faster by avoiding writing SQL queries. They have a smaller learning curve because we don’t need to learn a new language and dive deep into understanding how the database works. Unfortunately, ORM libraries often generate SQL queries that are far from […]

NestJS

API with NestJS #118. Uploading and streaming videos

This entry is part 118 of 126 in the API with NestJS

Nowadays, video streaming is one of the main ways of consuming and sharing content. In this article, we explore the fundamental concepts of building a REST API for uploading videos to the server and streaming them using NestJS and Prisma. Check out this repository if you want to see the full code from this article. […]

JavaScript Node.js

Introduction to managing a private NPM registry with Verdaccio

An organization often develops more than one project. Since the projects are often part of a more extensive ecosystem, this could lead to duplicating some of the code. To deal with this problem, we can create JavaScript libraries that we can reuse across various projects. The most straightforward way of maintaining packages available in all […]