Skip to content

Instantly share code, notes, and snippets.

View matsubo's full-sized avatar

Yuki Matsukura matsubo

57 followers · 53 following
View GitHub Profile
@matsubo
matsubo / sado-2024.tsx
Created October 17, 2024 02:40
https://b_qo7mpenczye.v0.build/
"use client"
import { useState, useEffect } from "react"
import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from "@/components/ui/table"
import { Input } from "@/components/ui/input"
import { Button } from "@/components/ui/button"
import { Select, SelectContent, SelectItem, SelectTrigger, SelectValue } from "@/components/ui/select"
import { ArrowUpDown } from "lucide-react"
// 選手データの型定義
@matsubo
matsubo / ironman-nice-result-2024.csv
Last active September 24, 2024 00:59
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 41 columns, instead of 1 in line 3.
time,point,label,placeChange,place,pid,bib,bib_display,tag,name,timeOfDay,epochTime,milePace,milePaceAvg,mph,kmPace,kmPaceAvg,kmh,startTime,sex,profile_pic,profile_color,_ver,alias,pace,paceAvg,legTime,splitTime,netTime,waveTime,isFinish,course,country,country_iso,city,team,division,timestamp,i,u,leaderDiff
09:54:06.779,FINISH,Finish,0,1,R76ME5PW,686,686,GC09820,Lea Riccoboni,5:31:09 pm,1727019068.611,07:53,07:19,7.61,04:54,04:33,12.25,7:37:02 am,F,/user/UMBSF2JR/img?v=14,14,14,FINISH.ARCH,04:54 min/km,04:33 min/km,03:11:26.87,00:06:20.57,09:54:06.779,09:54:06.779,1,ironman,FRA,fr,Santiago de Chile,MULTISPORTCOACH,F30-34,1727026268.611,1727019070_000092,1727019070_000275,
09:56:32.185,FINISH,Finish,0,2,R52JTACF,252,252,CX82516,Joanna Soltysiak-Vrebac,5:21:33 pm,1727018492.82,07:09,07:20,8.41,04:27,04:33,13.53,7:25:01 am,F,,11,55,FINISH.ARCH,04:27 min/km,04:33 min/km,03:11:57.363,00:05:44.653,09:56:32.185,09:56:32.185,1,ironman,POL,pl,Kolo,,F35-39,1727025692.82,1727018494_000125,1727019070_000273,+02:25.41
09:
@matsubo
matsubo / atoto x10 gen2.md
Last active September 20, 2024 08:22

概要

「ATOTO X10G211E Androidカーナビ」を使ってみて所管をまとめておく

https://amzn.to/3zdUp3Z

不具合

  • スタートアップアプリを登録しているにも関わらず、ラジオがバックグラウンドで起動される。
@matsubo
matsubo / sado_1.csv
Last active September 10, 2024 06:22
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 25 columns, instead of 17 in line 5.
#,No,名前,性別,年齢区分,START,スイムL,スイムF,バイクS,住吉,ランS（本部）,ラン4km,ラン9km,ラン10km,ラン14km,ラン19km,ラン20km,ラン24km,ラン29km,ラン30km,ラン34km,ラン39km,FINISH,総合記録,備考
1,1001,星　大樹,男,35-39男子,6:00:00,6:31:18,7:03:33,7:06:20,9:53:42,12:12:07,12:30:40,12:56:21,13:00:29,13:20:43,13:47:58,13:52:08,14:12:58,14:40:36,14:45:03,15:05:47,15:33:06,15:37:11,9:37:11,
2,1112,渡邉　優介,男,35-39男子,6:00:00,6:34:07,7:09:35,7:12:46,10:12:48,12:42:46,12:59:57,13:23:18,13:26:57,13:44:34,14:09:38,14:13:44,14:32:44,14:58:32,15:02:52,15:23:11,15:50:35,15:54:38,9:54:38,
3,1118,丸尾　公貞,男,35-39男子,6:00:00,6:30:12,7:02:03,7:05:44,10:05:19,12:36:19,12:58:01,13:24:01,13:27:50,13:48:16,14:14:44,14:18:58,14:39:52,15:07:30,15:11:38,15:32:25,16:01:30,16:05:52,10:05:52,
4,1098,浜田　裕介,男,35-39男子,6:00:00,6:33:37,7:08:25,7:12:47,10:11:46,12:47:35,13:08:12,13:33:46,13:37:48,13:57:25,14:23:16,14:27:20,14:47:12,15:15:31,15:19:41,15:40:20,16:06:23,16:10:34,10:10:34,
5,1004,堀江　克如,男,40-44男子,6:00:00,6:32:54,7:06:35,7:10:08,10:09:35,12:38:32,12:58:45,13:25:22,13:29:32,13:50:21,14:17:19,14:21:3
@matsubo
matsubo / main.js
Created August 14, 2024 02:27
Tried to crawl https://openai.com/news/ but blocked with 403 error.
// For more information, see https://crawlee.dev/
import { PlaywrightCrawler } from 'crawlee';
const userAgent = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36';
// PlaywrightCrawler crawls the web using a headless
// browser controlled by the Playwright library.
const crawler = new PlaywrightCrawler({
// Use the requestHandler to process each of the crawled pages.
@matsubo
matsubo / robots.txt
Created August 2, 2024 07:23
User-agent: GPTBot
Disallow: /
User-agent: ChatGPT-User
Disallow: /
User-agent: Google-Extended
Disallow: /
User-agent: CCBot
@matsubo
matsubo / README.md
Last active June 30, 2024 16:25

APC upsd mackerel plugin

Screenshot

image

Setup

@matsubo
matsubo / gist:cb875c98b3fd740abb24dd9f8f33d8a0
Created May 19, 2024 03:13
mysql 8.4に対応するためにパスワードのプラグインを変更する方法
# dockerコンテナの場合は手動で立ち上げて、そのコンテナにexecで入ってローカルに接続して変更する
ALTER USER 'root'@'localhost' IDENTIFIED with caching_sha2_password BY 'xxxxxxxxx'
ALTER USER 'root'@'%' IDENTIFIED with caching_sha2_password BY 'xxxxxxxxx'
@matsubo
matsubo / gist:dadcfc7554bc62855352b899bf5a7348
Created May 15, 2024 21:55
Delete all article using wp-cli.
$ wp post list| awk '{print $1} '| xargs -n 1 -I XXX wp post delete XXX --force
@matsubo
matsubo / gist:ac31be9578834db85e034ac54c0b433f
Created January 21, 2024 15:05
install nodejs oneliner on Ubuntu or Debian
RUN curl -fsSL https://deb.nodesource.com/setup_18.x | bash - && apt-get install -y nodejs