Skip to content

Instantly share code, notes, and snippets.

View PyYoshi's full-sized avatar
🌍
Working from The World

MISAWA Yoshihiro PyYoshi

🌍
Working from The World
62 followers · 13 following
View GitHub Profile
@PyYoshi
PyYoshi / test.sql
Last active August 16, 2023 04:19
MySQL JSON型のINDEX検証
View test.sql
CREATE TABLE `test_json_tbl` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`columns` json DEFAULT (_utf8mb4'[]'),
`name` text COLLATE utf8mb4_general_ci,
`selections` json DEFAULT (_utf8mb4'[]'),
PRIMARY KEY (`id`),
KEY `idx_columns1` ((cast(json_extract(`columns`,_utf8mb4'$[*].value') as char(512) array))),
KEY `idx_columns2` ((cast(json_extract(`columns`,_utf8mb4'$[*]._id') as char(64) array))),
KEY `idx_selections1` ((cast(json_extract(`selections`,_utf8mb4'$[*].value[*]') as char(512) array))),
KEY `idx_selections2` ((cast(json_extract(`selections`,_utf8mb4'$[*]._id') as char(64) array))),
@PyYoshi
PyYoshi / README.md
Last active November 26, 2020 09:29
WXR-2533DHP/WXR-2533DHP2用ファームウェアを展開するためのツール(ストリーミング処理を行っていないのでファイルサイズ分メモリを消費します)
View README.md 
$ go build -o firmware-extractor

$ ./firmware-extractor -h
Usage of firmware-extractor:
  -f string
        WXR-2533DHPのファームウェアファイルを指定してください

$ ./firmware-extractor -f ./wxr_2533dhp2_jp_146
Input:
@PyYoshi
PyYoshi / gist:d4b48a0b186bea7ee4ffd00e0933da7f
Created May 19, 2020 00:48
setup helm-kubeval for github actions
View gist:d4b48a0b186bea7ee4ffd00e0933da7f
- name: Setup helm-kubeval
env:
KUBEVAL_VERSION: 0.15.0
run: |
curl -L "https://github.com/instrumenta/kubeval/releases/download/$KUBEVAL_VERSION/kubeval-linux-amd64.tar.gz" -o /tmp/kubeval-linux-amd64.tar.gz
tar xvf /tmp/kubeval-linux-amd64.tar.gz -C /tmp
chmod +x /tmp/kubeval
mv /tmp/kubeval /usr/local/bin/
kubeval --version
helm plugin install https://github.com/instrumenta/helm-kubeval
@PyYoshi
PyYoshi / keybase.md
Last active November 7, 2018 01:29
View keybase.md

Keybase proof

I hereby claim:

  • I am PyYoshi on github.
  • I am pyyoshi (https://keybase.io/pyyoshi) on keybase.
  • I have a public key whose fingerprint is 8C8F 440B 3390 4D89 6E52 A114 146D 52F7 C000 C2F0

To claim this, I am signing this object:

@PyYoshi
PyYoshi / Dockerfile
Last active August 29, 2018 00:29
mozjpeg 3.3.1, vips 8.6.5
View Dockerfile
FROM debian:buster-slim
RUN apt update \
&& apt install -y \
autoconf \
wget \
nasm \
build-essential \
pkg-config \
libde265-0 \
@PyYoshi
PyYoshi / Ruby script to convert CSV to YAML
Last active July 11, 2018 01:06 — forked from potatosalad/Ruby script to convert CSV to YAML
View Ruby script to convert CSV to YAML
#!/usr/bin/env ruby
#
# Originally written by http://redartisan.com/tags/csv
# Added and minor changes by Gavin Laking
# Rewritten by Andrew Bennett for Ruby 1.9
#
# Usage: ruby csv_to_fixture.rb file.csv [--json]
#
# "id","name","mime_type","extensions","icon_url"
# "1","unknown","unknown/unknown","||","/images/icon/file_unknown.gif"
@PyYoshi
PyYoshi / command.sh
Created September 25, 2017 04:05 — forked from peterdemartini/command.sh
Exclude node_modules in timemachine
View command.sh
find `pwd` -type d -maxdepth 3 -name node_modules | xargs -n1 sudo tmutil addexclusion -p
@PyYoshi
PyYoshi / input.conf
Last active August 22, 2017 04:06
mpv config
View input.conf
# ~/.config/mpv/input.conf
MOUSE_BTN3 add volume 2
MOUSE_BTN4 add volume -2
AXIS_UP add volume 2
AXIS_DOWN add volume -2
UP add volume 2
DOWN add volume -2
@PyYoshi
PyYoshi / sha256sum.txt
Last active January 26, 2018 18:12
GPD Pocket--firmware of Windows OS（20170526）.rar
View sha256sum.txt
87a1f231fa93a45db5b3b8fd36780ff2cd5857de77bb4c0d580366e599b1a817 GPD Pocket--firmware of Windows OS（20170526）.rar
800635981f43f4efabf84e1988f4dbca89b2eda0400718647ef8904e595170b6 ./WINPE/BOOTEX.LOG
21bf8054adfe0614baba6f21a4bad0b7bfe71dbe9169d2422de42a79258beba0 ./WINPE/Boot/BCD
8358dd2d0dc148113181718daee0b916e6e37ea7d94afd06ee153086da1ce478 ./WINPE/Boot/Fonts/chs_boot.ttf
9be3453a0ccd14f3ae1fc766727909b22b51f561d9a5cd0338e8ad41b2be5737 ./WINPE/Boot/Fonts/cht_boot.ttf
89470defffa753a6d3fcff4db243ec211d9970ae67f1f840034fe9199020db1c ./WINPE/Boot/Fonts/jpn_boot.ttf
6a21388fc2c5fda2cd7d08ffa0ce01dc6c65e08fcb030a3d3aaa39c31b1c398a ./WINPE/Boot/Fonts/kor_boot.ttf
6846bcd60c75f991dc009f6c0dad10ce2016cb00acc9d208abd596fb2e6bd7d0 ./WINPE/Boot/Fonts/malgun_boot.ttf
458f90f9e99e25b8777b3e4ba872f822ee074668814d52d454f3597af2fc8680 ./WINPE/Boot/Fonts/malgunn_boot.ttf
ec653bdee02143ef49f28ef932bb31ab9c6d6a431c8d8f244ce44a7f7ad03e66 ./WINPE/Boot/Fonts/meiryo_boot.ttf
@PyYoshi
PyYoshi / _.md
Last active July 24, 2017 16:29
blid vs rez vs gift vs imaging vs resize vs bimg
View _.md

http://www-2.cs.cmu.edu/~chuck/lennapg/lena_std.tif

$ go test -bench "BenchmarkResize" -benchmem
BenchmarkResize_NfntResize_NearestNeighbor-4                	    1000	   1754846 ns/op	  845441 B/op	      24 allocs/op
BenchmarkResize_NfntResize_Bilinear-4                       	    1000	   1788142 ns/op	  847436 B/op	      24 allocs/op
BenchmarkResize_NfntResize_Bicubic-4                        	     500	   2474752 ns/op	  851532 B/op	      24 allocs/op
BenchmarkResize_NfntResize_MitchellNetravali-4              	     500	   2517930 ns/op	  851531 B/op	      24 allocs/op
BenchmarkResize_NfntResize_Lanczos2-4                       	     500	   2726255 ns/op	  851530 B/op	      24 allocs/op
BenchmarkResize_NfntResize_Lanczos3-4                       	     500	   3424438 ns/op	  855629 B/op	      24 allocs/op