Welcome to new things

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

Entries from 2023-02-01 to 1 month

Notes on a slightly more elaborate use of BigQuery (programming)

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'll put tog…

Memo for slightly elaborate usage of BigQuery (table creation and data update)

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'll put tog…

Memo on how to use BigQuery in a slightly more elaborate way (views, materialized views, table functions)

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'll put tog…

Memo on how to use the Markdown parser remark

I have read Markdown, edited it in various ways as I wanted, and wanted to output it to Markdown again. I used a JavaScript Markdown parser called remark. However, it is difficult to understand how to use it, and I am sure I will forget ho…

File drop with Selenium, puppeteer, and Playwright

For some time now, we have been putting together a list of how to use Selenium, puppeteer, and Playwright. Since the summary is getting long, I will put the operations that require some explanation and procedures in a separate article. Her…

Infinite scrolling with Selenium, puppeteer and Playwright

For a while now, I have been putting together a list of how to use Selenium, puppeteer, and Playwright. Since the summary is getting long, I will put the operations that require some explanation and procedures in a separate article. Here i…

Notes on how to use puppeteer

I had previously tested both Selenium and Playwright for comparison. Now that I've learned how to use them, I've compiled a brief summary of how to use them in the following article so that I can quickly recall them when I need to use them…

I want to handle JavaScript arrays in SQL.

I usually use SQL, but when I am working with array data in JavaScript, I sometimes wish I could write queries in SQL for JavaScript arrays. On the other hand, C# has a language called LINQ that can process arrays with SQL-like queries. Th…

Notes on how to use Playwright

Since I have been experimenting with Playwright recently, I thought I would make a note of how to use Playwright so that I can remember how to use it again if I forget how to use it. install npm install --save playwright When Playwright is…

Selenium Usage Notes

Since I have been experimenting with Selenium recently, I thought I would make a note of how to use Selenium so that if I forget how to use it, I can remember again. install Selenium pip install selenium The browser and the WebDriver that …