Skip to content

Instantly share code, notes, and snippets.

View 6farer's full-sized avatar
☣️
doing me

Eric Kim 6farer

☣️
doing me
View GitHub Profile
SELECT
CONCAT('ALTER TABLE ',
tbl.TABLE_SCHEMA,
'.',
tbl.TABLE_NAME,
' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;')
FROM
information_schema.TABLES tbl
WHERE
tbl.TABLE_SCHEMA = 'DBNAMEGOESHERE*****'

Keybase proof

I hereby claim:

  • I am 6farer on github.
  • I am 6farer (https://keybase.io/6farer) on keybase.
  • I have a public key whose fingerprint is 03CD 7EC7 0487 7AE7 6220 524E 183A 1EE9 FF31 7E0E

To claim this, I am signing this object:

@6farer
6farer / SSL cert generation.sh
Created March 9, 2016 15:40
Generate SSL Certificates
#! /bin/bash
NAME=$1
if [ -z $NAME ]; then
echo "First parameter should be a name for the output files, e.g. devint.company.local"
exit -1
fi
openssl genrsa -out $NAME.key 2048
openssl req -new -key $NAME.key -out $NAME.csr
@6farer
6farer / latency.txt
Last active December 28, 2015 22:53 — forked from jboner/latency.txt
Latency Numbers Every Programmer Should Know
Latency Comparison Numbers
--------------------------
L1 cache reference 0.5 ns
Branch mispredict 5 ns
L2 cache reference 7 ns 14x L1 cache
Mutex lock/unlock 25 ns
Main memory reference 100 ns 20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy 3,000 ns
Send 1K bytes over 1 Gbps network 10,000 ns 0.01 ms
Read 4K randomly from SSD* 150,000 ns 0.15 ms
@6farer
6farer / bash-cheatsheet.sh
Created December 28, 2015 22:51 — forked from LeCoupa/bash-cheatsheet.sh
Bash CheatSheet for UNIX Systems
#!/bin/bash
#####################################################
# Name: Bash CheatSheet for Mac OSX
#
# A little overlook of the Bash basics
#
# Usage:
#
# Author: J. Le Coupanec
# Date: 2014/11/04
@6farer
6farer / gist:a442d8169ba30ea947b0
Created August 4, 2015 05:39
NodeJS .gitignore
lib-cov
*.seed
*.log
*.csv
*.dat
*.out
*.pid
*.gz
pids