BenWard’s gists

BenWard / local-albums.sql

Created December 18, 2023 01:34

	SELECT
	COUNT(Track.id) AS playCount,
	CanonicalArtist.title AS ArtistName,
	CanonicalPage.title AS AlbumName,
	FROM
	-- Tables to query playlist info
	tracks AS Track
	INNER JOIN broadcasts AS Broadcast ON (Track.broadcast_id = Broadcast.id)
	INNER JOIN programs AS Program ON (Program.id = Track.program_id)
	-- Tables to query canonical presentation

BenWard / s3-buffer.sh

Last active October 11, 2019 07:23

Move files from an s3 bucket to a second buffer bucket, if the buffer bucket contains fewer than $file_count objects.

	#!/bin/sh
	#file_count=100
	#source_bucket="example-log-stream"
	#buffer_bucket="example-log-stream-buffer"

	# Move $file_count files from an s3 bucket to a second buffer bucket, if the buffer
	# bucket contains fewer than $file_count objects.
	#
	# We use this to prevent a logstash s3 input filter blowing up our ELK server when backlog of
	# files builds up in s3 (e.g traffic spikes, or after period of system downtime.)

BenWard / subl.bash

Last active August 29, 2015 14:13

A simple wrapper for `subl`, which handles opening explicit arguments, `sublime-project` definitions if present, or falls back to open the current directory.

	function subl {
	if [ -n "$1" ]; then
	command subl $1
	elif [ -f *.sublime-project ]; then
	command subl *.sublime-project
	else
	command subl .
	fi
	}

BenWard / gist:7f47ee00da22dd52ff09

Created October 15, 2014 08:55

Dirty little hack script to make the Creek.FM time-stamp field update live, to make it easier to post tracks at the right time.

	(function realTimeTrackTime () {
	function padNumber (i) {
	i = "" + i;
	if (i.length == 1) return "0" + i;
	return i;
	}

	function updatePlaytime () {
	var d = new Date()
	window.requestAnimationFrame(function () {

BenWard / gist:1f38be8e28df87fced81

Created October 15, 2014 08:14

Quick script to generate end-times from track lengths for tracks played on Creek.FM

	(function endTimesFromTrackLength () {

	function padNumber (i) {
	i = "" + i;
	if (i.length == 1) return "0" + i;
	return i;
	}

	function timestampToSecs (dateString) {
	return Date.parse(dateString.replace(" ", "T") + "-07:00") / 1000;

BenWard / gist:4189f5cf1452adac41fc

Last active August 29, 2015 14:06

Quick and dirty function to extract tracklistings from a BFF.FM show playlist and convert it into a Mixcloud compatible blob of text. Recognises gaps in songs and creates chapter breaks automatically.

	(function mixcloudify (startHour) {
	var TALK_BREAK_MINIMUM = 4, // minimum length to insert a talk break
	showDate;

	function showTime () {
	var start = startHour.split(":").map(function (item) {
	return padNumber(item);
	});

	return Date.parse([

BenWard / extended-tweet-embed.html

Created May 9, 2013 23:52

Expanded version of the Twitter embed code that includes static Tweet actions using Web Intents. (Won't actually initialize as a JavaScript embed due to a parsing assumption on our part, but I'll fix that when I get a chance.)

	<blockquote class="twitter-tweet" cite="https://twitter.com/mroth/status/332642087713521664">
	<p>Best practices for nicely embedding a static tweet in a GitHub README.md? (Twitter's embed code obviously won't work due to SCRIPT tags.)</p>
	<p>— Matthew Rothenberg (<a href="https://twitter.com/mroth/">@mroth</a>)
	<a href="https://twitter.com/mroth/status/332642087713521664">May 9, 2013</a> ·
	<a href="https://twitter.com/intent/tweet?in_reply_to=332642087713521664">Reply</a> ·
	<a href="https://twitter.com/intent/retweet?tweet_id=332642087713521664">Retweet</a> ·
	<a href="https://twitter.com/intent/favorite?tweet_id=332642087713521664">Favourite</a>
	</p>
	</blockquote>

BenWard / tumblr_export.js

Created March 25, 2013 06:49

Quick and dirty script to pull down all of your posts from Tumblr as raw, unformatted JSON responses. Useful for crude back-ups, or if you're going to transform them later and only want to hit the API once. There's no rate limiting or back-off or anything, and the blog I wrote it for only had 580 posts, so I'm not sure what issues you might run …

	!function () {
	// You'll need an application registered at http://www.tumblr.com/oauth/apps
	// Just put the OAuth Consumer Key here (Tumblr's version of application-auth
	// is really simple and unsigned.)
	const key = "";
	// Next, put your Tumblr domain name here. That might be 'benw.tumblr.com' or
	// 'blog.benward.me'.
	const domain = "example.tumblr.com";

	// Since we're pasting this on gist rather than giving you a full repo to

BenWard / oembed.rb

Created March 15, 2013 23:36

Dirty little ruby script to get oEmbed from URLs, for use with automator actions in Mac OSX. Enables embedding Tweets and Flickr photos (and probably others) for selected URLs. Rather fragile.

	require 'rubygems'
	require "open-uri"
	require 'nokogiri'
	require 'json'

	ARGV.each do \|f\|
	doc = Nokogiri::HTML(open(f))
	doc.css('link[type="application/json+oembed"]').each do \|link\|
	oembed_uri = link['href']
	oembed = open(oembed_uri).read

BenWard / gist:2580401

Created May 2, 2012 20:52

Sublime Text 2 Settings

	{
	"theme": "Soda Light.sublime-theme",
	"color_scheme": "Packages/Color Scheme - Default/Sunburst.tmTheme",
	"font_size": 13,
	"tab_size": 2,
	"draw_white_space": "all",
	"gutter": true,
	"margin": 2,
	"rulers": [78, 80],
	"draw_minimap_border": false,

Ben Ward BenWard