Skip to content

Instantly share code, notes, and snippets.

View zenweasel's full-sized avatar
🏠
Working from home

Brent Hoover zenweasel

🏠
Working from home
89 followers · 47 following
View GitHub Profile
@zenweasel
zenweasel / 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'
),
@zenweasel
zenweasel / 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">
@zenweasel
zenweasel / 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
@zenweasel
zenweasel / 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
@zenweasel
zenweasel / 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:

@zenweasel
zenweasel / sql that helps.md
Created January 22, 2014 17:14 — forked from selenamarie/sql that helps.md
@zenweasel
zenweasel / 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.
@zenweasel
zenweasel / 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

Idiot-Proof Git Aliases

@zenweasel
zenweasel / 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'
@zenweasel
zenweasel / 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