davidpanofsky

[{
    "Note": "The first two digits (ranging from 10–43) correspond to the province, while the last two digits correspond either to the city/delivery zone (range 01–50) or to the district/delivery zone (range 51–99). Afghanistan Postal code lookup",
    "Country": "Afghanistan",
    "ISO": "AF",
    "Format": "NNNN",
    "Regex": "^\\d{4}$"
}, {
    "Note": "With Finland, first two numbers are 22.",
    "Country": "Åland Islands",
    "ISO": "AX",

davidpanofsky

*** RSA

# Generate self-signed certificate with RSA 4096 key-pair
openssl req -x509 -nodes -days 3650 -newkey rsa:4096 -keyout rsakey.pem -out rsacert.pem

# print private and public key
openssl rsa -in rsakey.pem -text -noout

# print certificate
openssl x509 -in rsacert.pem -text -noout

davidpanofsky

# Latest version can be used by adding following command to your ~/.bash_profile:
#   eval "$(curl -s https://gist.githubusercontent.com/davidpanofsky/a50689c0b500f43c3d7c92a5f6303fdd/raw/helpers.bash)"

# prefer brew installed awscli over local virtualenv
if [ -x /usr/local/bin/aws ]; then
    AWS=/usr/local/bin/aws
else
    AWS=aws
fi

davidpanofsky

CREATE EXTERNAL TABLE IF NOT EXISTS alb_logs (
	type string, 
	timestamp string, 
	elb string, 
	client_ip string, 
	client_port int,
	target_ip string,
	target_port int, 
	request_processing_time double, 
	target_processing_time double,