Category: SQL

JavaScript SQL

Range types in PostgreSQL and TypeORM

Sometimes when working with databases, we need to represent a range of values. For example, we might want to define a set of available numbers or a range of dates. One way to do that would be to create two columns that hold the bound values.

Above, we are using the timestamp with timezone […]

JavaScript Node.js SQL

Time intervals with PostgreSQL and TypeORM

In the previous article, we’ve looked into various ways to store the date and time with PostgreSQL and TypeORM. Postgres can also manage¬†intervals. With them, we can store a period of time. Ways to store and display intervals in PostgreSQL There are various ways we can input and view interval values. By default, PostgresSQL represents […]

JavaScript SQL TypeScript

Managing date and time with PostgreSQL and TypeORM

While dealing with data, we often have to handle the date and the time. When doing so, there are quite a few things to consider. In this article, we approach various issues both from the standpoint of PostgreSQL and TypeORM. Ways to store and display date and time in PostgreSQL By default, Postgres represents dates […]

JavaScript NestJS SQL TypeScript

API with NestJS #16. Using the array data type with PostgreSQL and TypeORM

This entry is part 16 of 37 in the API with NestJS

Storing arrays is not an obvious thing in the world of SQL databases. Solutions such as MySQL, MariaDB, or Microsoft SQL Server don’t have a straightforward column type for arrays. This article explores how the array data type works in PostgreSQL both through SQL queries and through TypeORM. By learning how to operate on arrays […]