Skip to content

Instantly share code, notes, and snippets.

View eyeye's full-sized avatar
🏠
Working from home

eyeye

🏠
Working from home
View GitHub Profile
@eyeye
eyeye / iterm2-solarized.md
Created October 2, 2018 03:33 — forked from kevin-smets/iterm2-solarized.md
iTerm2 + Oh My Zsh + Solarized color scheme + Meslo powerline font + [Powerlevel9k] - (macOS)

Default

Default

Powerlevel9k

Powerlevel9k

[http "https://github.com"]
proxy = socks5://127.0.0.1:1080
[https "https://github.com"]
proxy = socks5://127.0.0.1:1080
@eyeye
eyeye / link.md
Created July 29, 2020 12:58 — forked from joechenrh/link.md
download path
@eyeye
eyeye / closure_table.md
Created May 13, 2021 02:50
Persistent tree structure using closure table in MySQL

Using closure tables to manage hierarchical relations in MySQL

Create DB tables

Create a table to represent tree nodes.

CREATE TABLE `tree_node` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `data_body` text,

node_deleted datetime DEFAULT NULL,