Skip to content

Instantly share code, notes, and snippets.

View chandlerroth's full-sized avatar
🏗️
Always building!

Chandler Roth chandlerroth

🏗️
Always building!
View GitHub Profile

Keybase proof

I hereby claim:

  • I am chandlerroth on github.
  • I am chandlerroth (https://keybase.io/chandlerroth) on keybase.
  • I have a public key ASA7H5NhuukZfGUbOxkbYQmib2-FbPiy33owroP41WdfVgo

To claim this, I am signing this object:

@chandlerroth
chandlerroth / find_machine_config.ps
Created September 16, 2020 19:35
Where is my machine.config?
[System.Runtime.InteropServices.RuntimeEnvironment]::SystemConfigurationFile
-- grant UPDATE privilege to column on a particular table
GRANT UPDATE 'column' ON db.table to 'user.name'@'%';
#!/bin/bash
# Claim ownership of a directory for your user
sudo chown -R $(whoami) /directory/you/want/to/own
@chandlerroth
chandlerroth / link-icloud-projects.sh
Last active March 8, 2018 03:14
Create symlink for iCloud projects
totalCash = 40,000
allocatedMoney = 0 = SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()−1,COLUMN()))
goalAmount[0] = 10,000
goalAmount[1] = 2,000
goalAmount[2] = 5,000
if (goalAmount[1] <= (totalCash - allocatedMoney)) {
goalAmount[1]
} else {
totalCash - allocatedMoney
@chandlerroth
chandlerroth / .vimrc
Last active August 29, 2015 14:05
Vim setup for Mac OSX
" General setup
filetype off
set nocompatible
set clipboard=unnamed
set backspace=2
set laststatus=2
" Vundle setup
set rtp+=~/.vim/bundle/Vundle.vim
call vundle#begin()
@chandlerroth
chandlerroth / useful-commands.sh
Last active December 16, 2015 15:19
Useful commands
npm -qa # Displays all installed packages
openssl pkcs12 -in filename.pfx -nocerts -out key.pem # Export the private key file from the pfx file
openssl rsa -in key.pem -out server.key # Remove the passphrase from the private key
@chandlerroth
chandlerroth / install-freetds.sh
Last active December 16, 2015 14:09 — forked from johncalvinyoung/centos-rbenv-install-system-wide.sh
Useful CentOS server config scripts
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz && mkdir freetds-stable && tar –xf freetds-stable.tgz -C freetds-stable --strip-components 1 && rm -rf freetds-stable.tgz
pushd freetds-stable
./configure && make && make install && make clean
popd
rm -rf freetds-stable