zlargon

#!/usr/bin/env node

const { Alchemy, Network } = require('alchemy-sdk');
const ethers = require('ethers');
const EthDater = require('ethereum-block-by-date');

const config = {
  apiKey: '3zNbANvcjr5yUHtnGKxXGdnX3dUYxL2X',
  network: Network.ETH_MAINNET,
};

zlargon

# https://gist.github.com/spicycode/1229612
# https://tmuxguide.readthedocs.io/en/latest/tmux/tmux.html

# 0 is too far from `
set -g base-index 1

# detach
bind -n C-e detach-client

# create new tab

zlargon

:: https://serverfault.com/a/351154
cmd /c "start rundll32 sysdm.cpl,EditEnvironmentVariables"

zlargon

# get env var
function get_env() {
  VAR=$(grep ${1} .env)
  echo ${VAR#*=}
}

zlargon

zlargon

#!/bin/bash

sudo sntp -sS pool.ntp.org

zlargon

#!/bin/bash

# create alfred-backup folder
mkdir -p alfred-backup/preferences/features/websearch

# prefs.plist
cp ~/Library/Application\ Support/Alfred/Alfred.alfredpreferences/preferences/features/websearch/prefs.plist \
  alfred-backup/preferences/features/websearch

# resources (images)

zlargon

git config --global user.name         "zlargon"
git config --global user.email        "[email protected]"
git config --global color.ui          true
git config --global core.editor       vim
git config --global core.ignorecase   true
git config --global alias.br          branch
git config --global alias.co          checkout
git config --global alias.cp          cherry-pick
git config --global alias.st          stash
git config --global alias.sub         submodule

zlargon

SET GLOBAL local_infile = true;
SHOW GLOBAL VARIABLES LIKE 'local_infile';

LOAD DATA LOCAL INFILE '<file.csv>'
INTO TABLE '<table_name>'
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;             -- ignore the field names

zlargon

cat INPUT_FILE | sed 's/^/PREFIX/' | sed 's/$/SIFFIX/' > OUTPUT_FILE