Welcome to new things

[Technical] [Electronic work] [Gadget] [Game] memo writing

Entries from 2023-03-01 to 1 month

How to use Microsoft SQL Server with JavaScript

This is a memo on how to use Microsoft SQL Server (MSSQL) with JavaScript. The library is tedious, which is also recommended by Microsoft. tedios is a callback style library, but it is written in async, await, and TypeScript in a modern st…

How to use Go language (string, byte, rune)

You will always find string, byte, and rune in introductory Go language books. However, when you start to program, the frequent interconversions between each of them can be confusing. In such cases, we tend to somehow convert the type and …

How to use "relative date" and "date range" at the same time in Tableau

To the UI for specifying the display range of time series graphs The default is to show the most recent X days, and you can specify any date in the calendar when you need it." I often see things like this. But I can't do the equivalent wit…

Using Firestore as a lightweight database

I was working on a program related to GCP and wanted to store some data. It was a one-off piece of data that was not large enough to set up a database, nor was it likely to write a join query between the data. To begin with, setting up a d…

A note on a slightly more elaborate use of BigQuery (scheduled queries)

I usually use Google BigQuery only for simple aggregate SQL, but there are many other useful functions besides aggregate SQL. However, since I don't use it often and when I do try to use it, I start by looking for a manual, so I'm going to…