Skip to content

Instantly share code, notes, and snippets.

View matsuu's full-sized avatar
🖖
Salute

MATSUU Takuto matsuu

🖖
Salute
178 followers · 46 following
View GitHub Profile
@matsuu
matsuu / ddl.cypher
Created October 12, 2024 02:27
KuzuDB with yellow_tripdata
INSTALL httpfs;
LOAD EXTENSION httpfs;
CREATE NODE TABLE taxi_zone (
LocationID INT32,
Borough STRING,
Zone STRING,
service_zone STRING,
PRIMARY KEY (LocationID)
);
@matsuu
matsuu / yellow_tripdata-jupysql-duckdb.ipynb
Last active September 22, 2024 09:49
yellow_tripdata-jupysql-duckdb.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@matsuu
matsuu / mermaid-architecture.md
Created September 14, 2024 09:50
mermaid architecture diagram syntax

architecture

architecture-beta

    service internet(internet)[Internet]

    group cloud(cloud)[Cloud]

 service server(server)[Server] in cloud
@matsuu
matsuu / .gitignore
Last active November 25, 2024 05:36
ISUCON用.gitignore
/*
!/.gitignore
!/README.md
# etc配下は再起動のたびに変化するものとセキュリティ関連と関係がないものを除外
!/etc/
/etc/ModemManager/
/etc/NetworkManager/
/etc/PackageKit/
/etc/X11/
@matsuu
matsuu / keybase.md
Created August 28, 2023 23:03

Keybase proof

I hereby claim:

  • I am matsuu on github.
  • I am matsuu (https://keybase.io/matsuu) on keybase.
  • I have a public key ASCp9j9XZ7JCDk_co-nV9neHXnNx_7rH5X7MRmLAoW0d1go

To claim this, I am signing this object:

@matsuu
matsuu / isucon12q.vtt
Last active November 9, 2022 11:51
Whisper.cpp(largeモデル)を使ってISUCON12予選の動画( https://youtu.be/LtsyLbD64CU )の文字起こしをした結果
WEBVTT
00:00:00.000 --> 00:00:04.000
(タイトルを読む)
00:00:04.000 --> 00:00:12.000
サーバーデプロイ方法がわからない
00:00:12.000 --> 00:00:22.000
テンプレートのダウンロード これか
@matsuu
matsuu / config.yaml
Last active August 26, 2022 13:10
.config/zellij/config.yaml
simplified_ui: true
pane_frames: false
default_mode: locked
mouse_mode: false
#copy_command: "pbcopy"
theme: penumbra-light++
themes:
# https://github.com/nealmckee/penumbra
@matsuu
matsuu / main.rs
Created July 16, 2022 11:55
isucon11q-rust
use actix_web::{web, HttpResponse};
use chrono::DurationRound as _;
use chrono::Offset as _;
use chrono::TimeZone as _;
use chrono::{DateTime, NaiveDateTime};
use futures::StreamExt as _;
use futures::TryStreamExt as _;
use std::collections::HashMap;
use std::fs::File;
@matsuu
matsuu / sshrc
Created June 25, 2022 23:56
#!/usr/bin/env bash
function sshrc() {
local SSHHOME=${SSHHOME:=~}
if [ -f $SSHHOME/.sshrc ]; then
local files=.sshrc
if [ -d $SSHHOME/.sshrc.d ]; then
files="$files .sshrc.d"
fi
SIZE=$(tar cfz - -h -C $SSHHOME $files | wc -c)
@matsuu
matsuu / main.rs.diff
Created June 14, 2022 12:39
--- src/main.rs.orig 2022-06-14 21:26:10.771842719 +0900
+++ src/main.rs 2022-06-14 21:28:46.817699137 +0900
@@ -5,7 +5,12 @@
use chrono::{DateTime, NaiveDateTime};
use futures::StreamExt as _;
use futures::TryStreamExt as _;
-use std::collections::{HashMap, HashSet};
+use std::collections::HashMap;
+
+use std::fs::File;