Ben Ward BenWard
BenWard
/ local-albums.sql
Created
December 18, 2023 01:34
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/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.) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (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.)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <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 …
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| !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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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, |
NewerOlder