Update by random value on random rows in MySQL
Posted: November 11, 2021tl;dr ref: https://stackoverflow.com/questions/11087059/mysql-how-do-i-update-50-of-the-rows-randomly-selected https://stackoverflow.com…
How to generate large sequential numbers list in shell
Posted: July 01, 2021tl;dr use command, if you can. https://www.gnu.org/software/bc/manual/html_mono/bc.html Motivation I’d like to calculate that how much size…
[memo] Sending email on aws cli via SES
Posted: May 18, 2021How to avoid '-> (known after apply)' on Terraform
Posted: April 12, 2021tl;dr Don’t use resources result value directly, but use variables. Example Problem Whenever I did or without any changes, some…
[memo] 新しいMacが届いた時の設定
Posted: February 01, 2021OS設定 一般 ダークモード サイドバーアイコンサイズ: Small スクロールバー表示: Always ブラウザ: Chrome Handoff設定: マシン次第 デスクトップ スクリーンセーバー: Flurry 開始時間: 5min…
Hire me; to recruiters
Posted: January 01, 2021Expected Employment Status Anything! Expected Working Place US Warmer areas are preferable… 🌞 Visa support needed Japan Expected Salary…
[memo] Clean files when 'git stash pop' has conflicted...
Posted: November 03, 2020tl;dr Before , I should do . Then all I have to do to fix stash confliction is, When I got CONFLICT error of git stashing… Imagine I got…
[memo] Enable Firebase Auth (Google Login) with Flutter Web App
Posted: September 01, 2020Use the right version https://github.com/flutter/flutter/issues/54538#issuecomment-616733091 Configure Auth setting Follow the instruction…
bobo | Slack bot kit for Golang
Posted: June 17, 2020is a modular Slack RTM bot kit for Golang. To customize your bot, just add your own commands or written by other developers. Link: https…
google-home-client-go | Google Home client for Golang
Posted: June 17, 2020You can have Google Home speak a text. Link: https://github.com/evalphobia/google-home-client-go Overview Google Home can play audio file…
git push origin HEAD
Posted: June 16, 2020You don’t have to type branch name when you push to origin like But just using is enough to push current branch, Every time I’ve typed the…
[memo] GCP Berglas command line
Posted: May 25, 2020Setup Create secrets View secrets Use Credential on Cloud Run I prefer use a berglas-only bucket and add view/read permissions to custom SA…
'gcloud' and 'gsutil' command memo
Posted: May 09, 2020and command memo; gcloud Accounts gsutil (for Cloud Storage) Firebase
How to set up `go mod tidy` on GitHub Actions
Posted: May 08, 2020When you develop with golang in a team, sometimes someone (it’s me!) forget to include , or forget to run . Then the diffs will be…
Creating a static site: large size file uploader by Firebase Hosting and Storage | Part.2
Posted: March 05, 2020This article is a sequel article from Creating a static site: large size file uploader by Firebase Hosting and Storage | Part.1…
Creating a static site: large size file uploader by Firebase Hosting and Storage | Part.1
Posted: March 04, 2020Background I need a file uploader for some people. I never met them and they also don’t know me. I just want to gather movie clips from them…
[Serverless] How to use Selenium + Headless Chrome on AWS Lambda Python3.6
Posted: September 27, 2018tl;dr use option. serverless-chrome(headless-chromium): v1.0.0-55 ChromeDriver: v2.42 Selenium for Python: v3.14.1 Error on AWS Lambda…
[Python] pip error of ssl certificate
Posted: September 25, 2018tl;dr use Errors of pip and upgrading Successed with and options So, my Dockerfile for serverless Python is below now
[Serverless] How to use Python3 lxml on AWS Lambda
Posted: March 21, 2018tl;dl Use custom docker image. Error on sls deploy When I used and through , I got error on (｡ŏ﹏ŏ) Solution Use custom docker image.…
SSH外伝
Posted: February 09, 2018[OSX macOS] Convert SVG to PNG in command line
Posted: January 14, 2018tl;dr Alias It’s useful to add it as alias command. Problems alpha channel(transparency) is not saved in the output png by So is used as a…
[Mac OSX Setup] n (nodejs): Permission denied
Posted: January 13, 2018tl;dr Ref: GitHub: Permission denied before running with sudo #416
Golang Error: invalid type for composite literal
Posted: January 10, 2018In my case, the underlying type is not . https://play.golang.org/p/cLSmvB4bZD2
How to check/confirm SSH secret key password | SSH用秘密鍵のパスワードを確かめる方法
Posted: August 08, 2017Answer is from: stackoverfrow | How do I verify/check/test/validate my SSH password? has many feature…
わたしの Elasticsearch query cheetsheet
Posted: August 04, 2017DML Search: 検索 /_search 全indexを対象に検索 /,,
Command to clean unused Docker container/images/volumes to get disk space | 不要なDockerコンテナ・イメージ・ボリュームを削除するコマンド
Posted: May 18, 2017Indirect expantion in shellscripit on Alpine - Bash以外での変数の間接展開
Posted: April 20, 2017tl;dr use
[memo] nginx config template
Posted: March 15, 2017copied from https://certsimple.com/blog/nginx-http2-load-balancing-config https://github.com/certsimple/nginx-http2-load-balancing-config
pandasメモ（axis, level）
Posted: February 14, 2017axis=0: 行を対象に処理を実行axis=1: 列を対象に処理を実行 level=[0,1,2]: や で使われるMultiIndexに対して、対象となるIndex（順番）の指定 df.stack // 列を行に旋回（ピボット）するdf.unstack…
[memo] Docker build and push to Docker Hub
Posted: October 19, 2016Install numpy and pandas on alpine:python3
Posted: October 17, 2016tl;dr Install build tool and create symbolic link for locale. happy python life 🙂 error messages Before install g++, I got error below, And…
Rメモ・仮説検定
Posted: October 07, 2016パラメトリック検定 データの分布に制限有り t検定(t.test) 分母が同じ場合にしか使えない 外れ値に弱い ノンパラメトリック検定 データの分布によらず使える仮説検定 カイ二乗検定(chisq.test) データが…
curlでレスポンス速度を計測する
Posted: October 06, 2016HTTPのレスポンス速度を計測するのに、普通にabとかgoのVegetaを使えばいいっちゃいいんですが、リアルタイムでソース修正して、手軽に改善結果が出たかどうかを見るのに、curl…
Elasticsearch 2.x で複数のドキュメントにUPDATE文のようなもの実行する
Posted: September 22, 2016公式ドキュメントのこれだった。 Update By Query API なんだけどうまくいかず、結局はクエリと設定の両方の問題でした。 設定 探した限りでは実行時の設定API…
Google Analytics Real Time Reporting APIの初め方
Posted: July 08, 2016申し込み 以下のフォームから申し込みをします。https://docs.google.com/forms/d/1qfRFysCikpgCMGqgF3yXdUyQW4xAlLyjKuOoOEFN2Uw/viewform…
NodeSchool International Dayにいってきた
Posted: May 25, 20155月23日に全世界でやっていたらしい http://nodeschool.io/international-day/ 日本では東京と大阪の2都市だったのかな？CAの大きな会場に結構人が集まってた（101人くらいとか言っていた気がする） 同日に隣の部屋でCA Tech Kids…
R Programming - Week1
Posted: April 15, 2015ずっとやらずに放置してきたR言語だったけど、ようやく先週からcourseraのR Programmingという授業を始めてみた。 コースのWeek1のメモ。 Rの型 基本の型 ベクトル値（≒ 同型の配列）: 実数（number） 末尾にLをつけると 整数（integer…
MongoDB Aggregation
Posted: October 09, 2013アグリゲーション・フレームワーク – Aggregation Framework 参考 Aggregation Introduction (MongoDB Manual) Aggregationとは Aggregationとは「集合」を意味する英単語です。MongoDB…
Move Windows8 image from VMWare Fusion to VirtualBox
Posted: June 05, 2013Background “Windows8 is very cheap!” and bought it. Buy VMWare Fusion and install it on Mac Mini. Install VMWare Fusion on MBA. ⇒ After…
How to install PIL on CentOS6.4 (64bit) + virtualenv
Posted: January 14, 2013When I upload image file on Mezzanine, I got error message like below Goddxxn! Install PIL The pill (*1) is expensive in Japan, but this PIL…
Linuxで文字化けしたメールを読む
Posted: January 06, 2012K社のアクセルメールのメールファイルを直接コンソールで読むときのコマンドメモ 今更ながらとらドラ！見終わった あみちゃんかわゆす
Use MySQL on Debian Squeeze
Posted: December 24, 2011