Brent Hoover brent-hoover

🏠

Working from home

Making eCommerce go brrr for > 20 years

brent-hoover / New New Index Bloat Query

Created May 13, 2014 17:56 — forked from jberkus/New New Index Bloat Query

	WITH btree_index_atts AS (
	SELECT nspname, relname, reltuples, relpages, indrelid, relam,
	regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
	indexrelid as index_oid
	FROM pg_index
	JOIN pg_class ON pg_class.oid=pg_index.indexrelid
	JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
	JOIN pg_am ON pg_class.relam = pg_am.oid
	WHERE pg_am.amname = 'btree'
	),

brent-hoover / cast_init.html

Created February 8, 2014 18:50 — forked from Scarygami/cast_init.html

	<!DOCTYPE html>
	<html>
	<head>
	<title>Chromecast init</title>
	<script src="https://www.gstatic.com/cv/js/sender/v1/cast_sender.js"></script>
	</head>
	<body>
	<div id="message"></div>

	<script type="text/javascript">

brent-hoover / cast_loader.js

Created February 8, 2014 18:47 — forked from Scarygami/cast_loader.js

	/*
	* Copyright (c) 2014 Gerwin Sturm, FoldedSoft e.U. / www.foldedsoft.at
	*
	* Licensed under the Apache License, Version 2.0 (the "License"); you may
	* not use this file except in compliance with the License. You may obtain
	* a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing, software

brent-hoover / create_nginx_key.sh

Last active August 29, 2015 13:55 — forked from jessedearing/gist:2351836

Set up self-signed key for Nginx

	#!/bin/bash
	echo "Generating an SSL private key to sign your certificate..."
	openssl genrsa -des3 -out myssl.key 1024

	echo "Generating a Certificate Signing Request..."
	openssl req -new -key myssl.key -out myssl.csr

	echo "Removing passphrase from key (for nginx)..."
	cp myssl.key myssl.key.org
	openssl rsa -in myssl.key.org -out myssl.key

brent-hoover / tmux_cheatsheet.markdown

Created January 31, 2014 07:26 — forked from henrik/tmux_cheatsheet.markdown

tmux cheatsheet

As configured in my dotfiles.

start new:

tmux

start new with session name:

brent-hoover / sql that helps.md

Created January 22, 2014 17:14 — forked from selenamarie/sql that helps.md

JSON

brent-hoover / websocket.py

Created January 15, 2014 16:32 — forked from sris/websocket.py

	# Author: Jacob Kristhammar, 2010
	#
	# Updated version of websocket.py[1] that implements latest[2] stable version
	# of the websocket protocol.
	#
	# NB. It's no longer possible to manually select which callback that should
	# be invoked upon message reception. Instead you must override the
	# on_message(message) method to handle incoming messsages.
	# This also means that you don't have to explicitly invoke
	# receive_message, in fact you shouldn't.

brent-hoover / git-aliases.md

Created January 11, 2014 04:50 — forked from geelen/Article.md

Some more git aliases for doing the right thing by default

brent-hoover / html5_video_conv.bash

Created December 25, 2013 22:46 — forked from zpea/html5_video_conv.bash

	#!/bin/bash

	#
	# video conversion script for publishing as HTML 5 video, via videojs (with hd button extension)
	# 2011 by zpea
	# feel free to use as public domain / Creative Commons CC0 1.0 (http://creativecommons.org/publicdomain/zero/1.0/)
	#

	FFMPEG=/usr/bin/ffmpeg
	HD_SUFFIX='_hd'

brent-hoover / uninstall_homebrew.sh

Created November 17, 2013 23:17 — forked from mxcl/uninstall_homebrew.sh

	#!/bin/sh
	# Just copy and paste the lines below (all at once, it won't work line by line!)
	# MAKE SURE YOU ARE HAPPY WITH WHAT IT DOES FIRST! THERE IS NO WARRANTY!

	function abort {
	echo "$1"
	exit 1
	}

	set -e