Welcome to new things

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

computer technology

Sort Excel worksheets by name

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…

Thoughts on using both Selenium and Playwright

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…

GraphQL Usage Notes

The API I wanted to use was written in GraphQL. Since this was my first time using GraphQL, I thought I would make a brief note on how to use GraphQL from the client side. What is GraphQL? GraphQL is an API specification developed by Faceb…

Learning in theory and making it easy. memo on how to use Git

Git is difficult.... I thought I could do it by making a coping cheat sheet, but no luck.... Whenever there is a problem, we don't know what to do. There are multiple ways to write the same thing across commands, but this can be confusing …

Cookie Session Structure Memo

This is a personal note explaining how a website uses cookies and sessions to keep users connected to the site. These are rough conceptual notes, not exact specifications. Problems with HTTP communication HTTP communication is a one-time, …

Overcoming YAML Hatred

I was editing the Serverless Framework configuration YAML, looking at the following sample from the official site. When I finished editing and ran the file, it didn't work, and when I looked closely, I found that "arn: arn:xx" was actually…

How to open settings.json in VisualStudioCode

I thought I could no longer open settings.json after settings were made via GUI, but I was able to open it with the following. [File]-[Basic Settings]-[Settings] Click on the "{}" icon in the upper right tab I was looking for the "edit in …

How to fix Chrome printing wrong

I saw this because a family member told me that when he tried to print with Chrome, the text and layout were messed up and would not print properly. When I tried it, it was indeed strange. The layout is completely wrong and the text is som…

How to use Google Authentication instead of Basic Authentication just by setting up a web server

Basic authentication is an easy way to restrict access to a site. Basic authentication is convenient, but it is problematic because the browser does not remember the ID and password and you have to enter them each time, or anyone can acces…