Entries from 2022-01-01 to 1 year
I had the opportunity to work with Excel, which has hundreds of worksheets, and I tried to sort the worksheets by name because it was difficult to find the desired sheet. But Excel doesn't have the ability to sort worksheets by name. I end…
Generics has been included since version 1.18 of the Go language. To the extent that I use the Go language, I thought I would never use Generics because I don't write generic functions and the function descriptions are long. Useful feature…
I was using shell scripts and the scripts were getting long and hard to read, so I tried to summarize them with functions. However, the return values of shell script functions are different from those of functions in other programming lang…
When I started learning SQL, the window functions (analytic functions) were the most difficult to understand. Although you do not need to use the window function when using a database simply as a place to store and retrieve data, it is a v…
Normally, GCP operations can be done via command line tools or client libraries, so we never called the REST API directly. I'm trying out a service called GCP Batch right now, but it's still in preview stage and the command line tools and …
This is a memo on how to encode and decode URLs with shell scripts. You can find many ways to do this by searching. https://stackoverflow.com/questions/296536/how-to-urlencode-data-for-curl-command At first, we tried using nkf for both enc…
How to sort search results in Confluence Cloud by update order, title order, or any other criteria. Advanced Search When you click on the search window in the upper right corner of Confluence, you will see the "Advanced Search in Confluenc…
I have not used Redshift for the past few years, having migrated from AWS Redshift to Google BigQuery. However, Redshift Serverless, which is a pay-as-you-go Redshift, finally appeared and I started to get curious about it. Sure enough, I …
I learned from the following article that Promise in JavaScript is called synchronously. https://zenn.dev/yuhua_shi/articles/331569ef2fe886 I assumed that functions passed to Promise were asynchronous functions. Below is a summary of the P…
Since Google BigQuery is pay-as-you-go and relatively inexpensive, I had been using it without much concern about the fees. Big data analysis was a breakthrough in that matters that until now could only be guessed at could actually be expr…
I use Puppeteer for web crawling. I had hoped to someday put together a guide on how to use Puppeteer, but in the meantime, I have been hearing a lot about Playwright as a browser manipulation tool similar to Puppeteer. Then I started thin…