kuniiskywalker

Raspberry Pi 4 Model BにmirakurunをインストールしてVNCで視聴

前提

• Raspberry Pi 4 Model B
• PLEX PX-Q1UD
• B-CAS Card
• B-CAS CARD Reader
• micro SD
• Geekworm Raspberry Pi（冷却用アーマーケース）

kuniiskywalker

environment

os: windows 10
gpu: NVIDIA GeForce GTX 1060 6GB

cuda setup

cuda toolkit

kuniiskywalker

(() => {

  const normalize = (month, report) => {
    return Object.keys(report).map(key => {

      const restHour = report[key]["worktime"] && Number(report[key]["worktime"].split(':')[0]) >= 7 ? 1: 0
      const endHour = report[key]["worktime"]? ('00' + (Number(report[key]["worktime"].split(':')[0]) + 10 + restHour)).slice(-2) : "00";
      const endMinute = report[key]["worktime"]? ('00' + (Number(report[key]["worktime"].split(':')[1]))).slice(-2) : "00";

      return [

kuniiskywalker

javascript:(
    function(){
        const uttr = new SpeechSynthesisUtterance(window.getSelection().toString());
        speechSynthesis.speak(uttr);
    }
)();

kuniiskywalker

raw形式の音声をwav形式に変換

docker run -v $(pwd):/work --rm bigpapoo/sox mysox -t raw -c 1 -r 16000 -b 16 -e signed-integer ex2_090.raw -t wav mono.wav

サンプリングレートを11025に変換

docker run -v $(pwd):/work --rm bigpapoo/sox mysox sample002.wav -r 11025 output.wav

kuniiskywalker

SetEnvIf Request_URI "/ibaraki*" ibaraki

AuthUserFile /home/.htpasswd
AuthGroupFile /dev/null
AuthName "Input your ID and Password."
AuthType Basic

# 以下いずれかの条件がtrueの場合は認証要求なし
Satisfy any

kuniiskywalker

select @n:=@n+1 as counter from table, (select @n:=0) as seq_tbl;

kuniiskywalker

データボリューム

table_A：　1,000,000件

table_B：　300,000件

STRAIGHT_JOINを使った集約関数クエリ