Skip to content

Instantly share code, notes, and snippets.

Colin Bendell colinbendell

Block or report user

Report or block colinbendell

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@colinbendell
colinbendell / snowflake-r
Last active Mar 30, 2018
simple query in R backing against snowflake
View snowflake-r
library(dbplyr)
library(dplyr.snowflakedb)
options(dplyr.jdbc.classpath = "~/Downloads/snowflake-jdbc-3.5.3.jar")
# Update with credentials
snowflake_db <- src_snowflakedb(user = ""password = "", account = "ab123456", region = "us-east-1", opts = list(warehouse = "import", db = "cloudinary", schema = "public"))
benchmarks <- tbl(snowflake_db, in_schema("cto","lossy_benchmark_fast_v1_1"))
@colinbendell
colinbendell / convert_giphy_gifs.sh
Created Dec 4, 2017
Simple mass conversion of GIF to MP4 (h264/h265), WebM (vp8/vp9) and WebP
View convert_giphy_gifs.sh
#!/bin/sh
curl 'https://giphy.com/page/2?next=2017-12-01%2004%3A15%3A01&amp%3Bis=1&is=1&json=true' -o gipyurls.json
jq .[].gifs[].images.original.url gipyurls.json |cut -d / -f 5 | parallel -j 20 --gnu curl https://media2.giphy.com/media/{}/giphy.gif -o {}.gif
parallel -j 20 --gnu "ffmpeg -f gif -i {} {}.h264.mp4" ::: *.gif
parallel -j 20 --gnu "ffmpeg -f gif -i {} -c:v libx265 {}.h265.mp4" ::: *.gif
parallel -j 20 --gnu "ffmpeg -f gif -i {} -c:v libvpx {}.vp8.webm" ::: *.gif
parallel -j 20 --gnu "ffmpeg -f gif -i {} -c:v libvpx-vp9 {}.vp9.webm" ::: *.gif
@colinbendell
colinbendell / imagedata.js
Last active Dec 5, 2017
Extract a set of image information from a webpage
View imagedata.js
let imgData = Array.from(document.getElementsByTagName("img"))
.map(v => {
var rect = v.getBoundingClientRect();
var vHeight = (window.innerHeight || doc.documentElement.clientHeight);
var vWidth = (window.innerWidth || doc.documentElement.clientWidth);
var vDPR = window.devicePixelRatio;
return {
src: v.currentSrc,
cssWidth: v.clientWidth,
naturalWidth: v.naturalWidth,
You can’t perform that action at this time.