Skip to content

Instantly share code, notes, and snippets.

View squirrel532's full-sized avatar

Squirrel squirrel532

46 followers · 49 following
  • Taipei, Taiwan
View GitHub Profile
@squirrel532
squirrel532 / pre-commit
Created September 20, 2018 07:35 — forked from samhemelryk/pre-commit
A git pre-commit hook example.
#!/bin/bash
#
# This pre-commit hook checks that you havn't left and DONOTCOMMIT tokens in
# your code when you go to commit.
#
# To use this script copy it to .git/hooks/pre-commit and make it executable.
#
# This is provided just as an example of how to use a pre-commit hook to
# catch nasties in your code.
@squirrel532
squirrel532 / pyproject.toml
Created February 27, 2020 07:44
[tool.poetry]
name = "hello"
version = "2020.02.27"
description = "zzzz"
authors = ["aarrr <aarrrr@example.com>"]
[tool.poetry.dependencies]
python = "~2.7 || ~3.7"
pytest = "*"
@squirrel532
squirrel532 / install_vim.sh
Created June 14, 2020 15:13
Build vim from source on macOS
git clone https://github.com/vim/vim
cd vim
./configure --with-features=huge --enable-multibyte \
--enable-python3interp=yes \
--with-python3-config-dir=$(python3-config --configdir) \
--enable-luainterp=yes \
--enable-cscope \
--prefix=/usr/local \
--with-luajit \
@squirrel532
squirrel532 / SQL Cheat Sheet.md
Created October 13, 2020 09:42 — forked from janikvonrotz/SQL Cheat Sheet.md
SQL Cheat Sheet#SQL#Markdown

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

Datatypes

Text types

@squirrel532
squirrel532 / gist:4e32429503146f570b3d2dffc6ef9598
Created October 28, 2023 19:32
QMK BIOI G60BLE
Th is a note for those who want to build `qmk/g60ble` firmware for their BIOI G60BLE keyboard.
1. Replace vid by `0x8101` in `info.json`. I wrote this gist based on release `0.22.14` because qmk might change in the future.
1. There is a typo in `LAYOUT_60_hhkb` keymap that maps top-right key into nothing.
The correct config of that key:
```
{"matrix": [2, 13], "x": 12.75, "y": 2, "w": 2.25}
```
@squirrel532
squirrel532 / gist:d5da86b53749d21767dd8d3bbd4db15b
Created June 3, 2026 07:05
MIC-711-ON USB 3.2 Fix on JetPack 7.2 (L4T r39) — Engineering Notes
> Disclamer: This note is generate by Claude Opus 4.8 and manually tested on a real device. It does fix my problem, please take it at risk.
● MIC-711-ON USB 3.2 Fix on JetPack 7.2 (L4T r39) — Engineering Notes
Problem
After flashing an Advantech MIC-711-ON (Jetson Orin Nano, module p3767-0004) with stock NVIDIA JetPack 7.2 / L4T R39.2.0:
- USB 3.2 ports ran at USB 2.0 speed (480M) only — e.g. an Orbbec Gemini 305 USB-3 camera capped at 480M.
- One USB 2.0 port was completely dead.