Skip to content

Instantly share code, notes, and snippets.

View philihp's full-sized avatar
👨‍💻
Turning caffeine into code

‮Philihp Busby philihp

👨‍💻
Turning caffeine into code
View GitHub Profile
libname frc 'u:\public\frc';
data frc.records(keep=team_id opponent_id result);
set frc.results;
array red(1:3) red1-red3;
array blue(1:3) blue1-blue3;
select;
when(redScore > blueScore) result = 2;
when(redScore < blueScore) result = 0;
when(redScore = blueScore) result = 1;
end;
@philihp
philihp / gist:8023422
Last active December 31, 2015 17:59
query for aaron
select c.name, m.serialnumber,
first_value(l.username) over (order by l.timestamp desc) as username
from machines m
inner join computersmachine cm on (m.id=cm.machineid)
inner join computers c on (cm.computerid=c.id)
left join logins l on (l.machineid=m.id)
@philihp
philihp / 2016-11-06-pgp-transition-statement.txt
Created November 7, 2016 10:06
PGP Key Transition Statement
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1,SHA512
2016-11-06 05:25:00 +0000
I am replacing my old DSA-1024 key with a stronger RSA-4096 key. The primary
motivation is to store my key on a Yubikey Nano which doesn't support DSA,
however there is a possibility that the old key has been compromised. Although
I don't have any evidence to suspect this, I certainly haven't been as careful
over the years as I could have.
Verifying that "philihp.id" is my Blockstack ID. https://onename.com/philihp
machine:
environment:
JAVA_TOOL_OPTIONS: '-Dfile.encoding=UTF8 -Duser.timezone=UTC'
_JAVA_OPTIONS: '-Xms512m -Xmx1024m -Xss2m'
java:
version: oraclejdk8
python:
version: 2.7.6
services:
- docker
@philihp
philihp / Node_AWS_Linux.md
Created February 8, 2017 00:24 — forked from nrollr/Node_AWS_Linux.md
Install Node.js on Amazon Linux (EC2)

##Installing Node.js on Amazon Linux AMI

The following will guide you through the process of installing Node.js on an AWS EC2 instance running Amazon Linux AMI 2016.09 - Release Notes

For this process I'll be using a t2.micro EC2 instance running Amazon Linux AMI (ami-d41d58a7). Once the EC2 instance is up-and-running, connect to your server via ssh

@philihp
philihp / nginx.conf
Last active December 5, 2017 23:28 — forked from sumardi/nginx.default.conf
Install PHP-FPM, Nginx & MySQL on EC2 with Amazon Linux AMI
# Install linux update, followed by GCC and Make
sudo yum -y update
sudo yum install -y gcc make
# Install Nginx and PHP-FPM
sudo yum install -y nginx php56-fpm
# Install PHP extensions
sudo yum install -y php56-devel php56-mysql php56-pdo \
php56-pear php56-mbstring php56-cli php56-odbc \
@philihp
philihp / gist:77ed7ac4cfab93ffb97990359e375831
Created December 30, 2018 05:47
Installing new Ruby 2.6.0 with rbenv
brew upgrade ruby-build
rbenv install 2.6
@philihp
philihp / gist:e14f40c974834e47704e85918ab61471
Created June 4, 2020 03:17
60f23428-ffa8-4a73-90b9-e11e0b7ed852
see rfong
date name g1 s1 g2 s2 g3 s3 g4 s4
2016-01-21 a56c54f2-4c30-44bc-a9c8-35ae9c307a30 ville 249 phil 222 ken 215 aaron 0
2016-02-19 I love the smell of napalm in the morning ville 173 aaron 137 phil 136 ken 0
2016-03-16 All that is necessary for the triumph of Ville is that bad men do nothing phil 250 ville 236 ken 197 aaron 163
2016-04-19 2016D ville 161 phil 150 ken 144 aaron 0
2016-05-19 2016E ken 180 aaron 165 ville 149 phil 126
2016-06-24 2016F ken 194 phil 165 aaron 156 ville 155
2016-07-20 Vacation for (from) Aaron ken 126 phil 104 ville 92
2020-08-23 2016G phil 176 ville 164 aaron 148 ken 125
2016-09-29 2016H ken 180 phil 169 ville 158 aaron 149