Upsert (this term is combined from two words: update and insert) is a database operation that updates a record it already exists in a table. Otherwise, insert a new row if that record doesn’t exist. This succinct, practical......
To reset your Docker Desktop, just follow a few easy steps below. Warning: All your local containers and images will be destroyed. All your settings, including your sign-in information, will be cleared. 1. Open your Docker Desktop......
Before installing Docker Desktop for Windows or macOS, just check the system requirements listed below to ensure your computer is competent to run it. Windows Minimum system requirements OS: Windows 10 64-bit: Home or Pro......
Overview If there are some pulled images that are no longer needed, then you can remove them from your system to free up your storage with the following command: docker image rm rm stands for remove. One important thing......
This article shows you how to determine the size of a Docker image that is hosted on Docker Hub or a Docker image that was pulled to your local system. Docker Hub’s Images Go to the page of the image you want to know the size,......
This concise article shows you how to check your Docker Desktop and Docker Engine versions (note that they are different numbers). Without any further ado (like talking about the history of the universe or why you should use Docker), let......
When communicating with databases through TypeORM, you can get raw SQL queries produced by query builders by using the getQuery() or getSql() methods (you can use them synchronously without the await keyword). Example: const......
This succinct tutorial shows you how to use column aliases to assign temporary names to columns when selecting data with TypeORM. The point here is the AS keyword. Let’s study a couple of examples for more clarity. User......
In real life, it’s possible that a column contains many duplicate values. However, there might be occasions when you only want to get different (unique) values. If you’ve worked with MySQL or PostgreSQL, you are very likely......
When communicating with the database through TypeORM, there will be many cases where you need to count records in a one-to-many relationship, such as: You want to list the users and the number of photos belonging to each person You......
In TypeORM, the Like operator (with the percent sign %) is used to search for a specified pattern in a column. This concise article walks you through 2 examples of selecting data with the Like operator in 2 different ways: Using the......
This short article walks you through 2 examples of selecting the latest record from a table using TypeORM. The first example uses the findOne() method, while the second one uses a query builder. Using the findOne() method This......