Other techs How to write outer join more than 3 tables
How can we write outer join to merge multiple tables? Do you need subquery in the query? This article shows you the solution.
Other techs 
Tips How to backup photos automatically
This article shows how to automatically copy files that don't exist in the destination directory. I often copy files fro...
Other techs Establish SQL Server in Docker container
I tried to establish SQL Server in Docker because I wanted to learn SQL again. Create a Dockerfile and run It's possible...
Tips Difficulties of personal evaluation for programmer
I have an interview session twice a year for my personal evaluation. I have to set goals at start of the year and have t...
JavaScript/TypeScript How to implement Node-RED node in TypeScript
The official site describes how to implement our own node in JavaScript. However, I don't find a page for TypeScript. I'...
JavaScript/TypeScript Complete Class Guide in TypeScript
Class is one of keys to be familir with Object Oriented Programming (OOP). Multiple variables and functions are in the s...
JavaScript/TypeScript TypeScript Bracket notation causes index signature error
TypeScript shows an error when we access an object with brackets like obj to get the value. How can we safely resolve it...
JavaScript/TypeScript 8 ways to remove duplicates from Array in TypeScript
This page shows 8 ways to remove duplicates from an array. It also compares the performance to be useful to decide which one to use for your case. It also covers the case where the element is object.
JavaScript/TypeScript How to generate Number Range Array in TypeScript
This post shows how to implement range function. It supports not only integer type but also floating type as well as ascending and descending order. Even if you need too big/small numbers, it can handle them by log notation.
JavaScript/TypeScript String concat in JavaScript Performance Comparison
JavaScript offers several ways to concatenate strings. Let's learn how to concatenate strings and which one is the best ...