Brad Montgomery bradmontgomery

SQL for reporting queries

Datatypes: JSON, HLL

JSON

http://www.postgresql.org/docs/9.3/static/functions-json.html

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

Convert MOV to GIF using FFmpeg and ImageMagick

I tried a few different techniques to make a GIF via command-line and the following gives me the best control of quality and size. Once you're all setup, you'll be pumping out GIFs in no time!

Preparation

Install FFmpeg

$ brew install ffmpeg [all your options]
- Example: $ brew install ffmpeg --with-fdk-aac --with-ffplay --with-freetype --with-frei0r --with-libass --with-libvo-aacenc --with-libvorbis --with-libvpx --with-opencore-amr --with-openjpeg --with-opus --with-rtmpdump --with-schroedinger --with-speex --with-theora --with-tools

Install ImageMagick

	$ mkvirtualenv test && workon test
	New python executable in test/bin/python2.7
	Not overwriting existing python script test/bin/python (you must use test/bin/python2.7)
	Installing setuptools, pip...done.
	$ pip --version
	pip 1.5.4 from /Users/scottburns/.virtualenvs/test/lib/python2.7/site-packages (python 2.7)
	$ date; pip install numpy pandas scipy > /dev/null; date
	Fri Jun 27 11:19:57 CDT 2014
	Fri Jun 27 11:20:35 CDT 2014

	# How to throttle the FCC to dial up modem speeds on your website using Apache.

	# Ported from https://gist.github.com/kyledrake/e6046644115f185f7af0

	## The blog post that started it all: https://neocities.org/blog/the-fcc-is-now-rate-limited
	##
	## Current known FCC address ranges:
	## https://news.ycombinator.com/item?id=7716915
	##
	## Confirm/locate FCC IP ranges with this: http://whois.arin.net/rest/net/NET-165-135-0-0-1/pft

	#!/usr/bin/env python
	# Quick and dirty demonstration of CVE-2014-0160 by
	# Jared Stafford ([email protected])
	# Modified so that it finds cookies

	import sys
	import struct
	import socket
	import time
	import select

	#!/usr/bin/env python2
	"""
	Author: takeshix <[email protected]>
	PoC code for CVE-2014-0160. Original PoC by Jared Stafford ([email protected]).

	Supportes all versions of TLS and has STARTTLS support for SMTP,POP3,IMAP,FTP and XMPP.
	"""

	import sys,struct,socket
	from argparse import ArgumentParser

	# A guide to prevent pain and suffering while upgrading to OS X Mavericks
	# This will vary greatly depending on system set up, so read the instructions carefully

	# Back up Virtulenvs
	####################

	# Very important!
	# For each virtualenv you have, run "pip freeze > requirements.txt" while in the activated virtualenv
	# in order to prevent loss of dependencies during the upgrade.

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

	- hosts: all

	tasks:
	- name: ensure googley fast nameservers
	sudo: True
	template: src=../templates/resolv.conf
	dest=/etc/resolv.conf force=true
	owner=root
	group=root
	mode=0644