Entries from 2019-02-01 to 1 month
At one time, it was popular to hack the Amazon Dash Button and modify it into an arbitrary IoT button, and while the detection of Amazon Dash Button button pushes can be done on a PC or RaspberryPi, this is a memo on how to do it on an ESP…
When aggregating data that jumps around by date, you may want a calendar table. You can create a calendar table in Google BigQuery with the following GENERATE_DATE_ARRAY()" creates a calendar array, and "UNNEST()" expands the array to rows…
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 …
Tableau not only displays graphs, but also provides cluster analysis capabilities. Python is free, and it is easy enough to perform cluster analysis with Python, but when trying to perform cluster analysis in Python, work such as standardi…
As I wrote in AWS CloudFormation Articles, AWS Lambda and API Gateway are managed in Serverless. Here is a poem about how we got there and a brief explanation of how to use Serverless. impetus What URL the Lambda is called with is configur…
About this Article This section describes how to configure the API Gateway authorizer to be able to CORS on the Serverless Framework. The details are transcribed below, with an outline added. https://serverless.com/blog/cors-api-gateway-su…
About this Article Describes a setting to allow the authorizer to be used by multiple Lambdas when deploying Lambdas using the Serverless Framework. procedure Include resultTtlInSeconds: 0 in all http events that use the authorizer, as in …
I usually use Tableau or PowerBI, but there are times when I don't want to use them, but want to quickly display a graph and check the data. I thought it might be useful to know about the Google Data Portal for such occasions, so I put tog…
I haven't touched React recently, but I read News that React Hooks has been officially released, so I read the official manual of React Hooks to see what it is all about. reactjs.org summary In React, there are two ways to create a compone…
Since the version of Ubuntu in WSL (Windows Subsystem for Linux) was getting old at 16, we installed a new Ubuntu with version 18. I also re-set up Python3 + Jupyter Notebook accordingly, but I ran into a few snags along the way, so here a…
We originally used AWS Redshift, but it was quite expensive, so we switched to Google BigQuery. After that, Redshift Spectrum came out, and I was wondering if it might be better than BigQuery, so I touched it and here are my impressions. A…
2019/05/22 Update The news is that the Windows 10 May 2019 Update (build 1903) has been released. I updated it right away, and it fixed the weird Emacs display in WSL! It was worth the wait. But maybe I should have waited a little longer..…
When I try to draw diagrams in PowerPoint, I have a hard time deciding on the layout, size, etc., and I have a tendency to not be able to draw quickly. I thought that it would be better to have a rigidly restricted system, so I considered …
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…
Array.reduce() in JavaScript is a bit quirky, and I had avoided it until now, but I put it together just to understand it. Array.reduce() is, in a nutshell, a function that collects the elements of an array and returns a single output. Fir…