Skip to content

Instantly share code, notes, and snippets.

View 4k 60fps to 720p 60fps
ffmpeg -i "Aly-Fila-Tomorrowland-Belgium-2019-W1-360p.mp4" -vn -c:a copy "Aly-Fila-Tomorrowland-Belgium-2019-W1.mp4"
View gist:34c1c4a6b497b2dabde05af737455cc5
ffmpeg -i "unstoppable_feat_micah_ariss.mp4" "unstoppable_feat_micah_ariss.flac"
View gist:d50e81b1dd9bef0f4b253d27fdddf851
sudo su - postgres
# Create dump to file
/usr/pgsql-9.5/bin/pg_dump --no-owner --no-acl some_db > /tmp/some_db
# Import from file
psql --username=root some_db < /tmp/some_db
---------------------------------------------------
sudo su - postgres
psql
CREATE ROLE postgres_user WITH CREATEDB ENCRYPTED PASSWORD 'password' LOGIN; # don't user upcase in role name!
View gist:79425d76106271fc6e48082e7801efdd
ffmpeg -y -ss 0 -i video.mp4 -i video2.mp4 -filter_complex '[0:v]concat=n=1:v=1:a=0 [v]; [1:a]concat=n=1:v=0:a=1 [a]' -map '[v]' -map '[a]' -codec:v libx264 -pix_fmt yuv420p -preset fast -strict -2 -t 736 result.mp4
View gist:249ecfb48a1860393909cf39626736c6
ffmpeg -f lavfi -i amovie=Chen_style_Taiji_Chen_Yu_application_2.mp4,volumedetect -f null /dev/null
View gist:bfe1088609de35a13ab0ce98f5c7c154
(function(d) {
var wf = d.createElement('script'), s = d.scripts[0];
wf.src = 'https://ajax.googleapis.com/ajax/libs/webfont/1.6.26/webfont.js';
wf.async = true;
s.parentNode.insertBefore(wf, s);
})(document);
View gist:7437eff46b7c84ac972974c6757e150e
#!/usr/bin/env ruby
# encoding: utf-8
# frozen_string_literal: true
require 'benchmark'
require 'pg'
conn = PG.connect host: '127.0.0.1', dbname: 'dbname', user: 'root', password: 'root'
# conn = PG.connect host: '127.0.0.1', dbname: 'dbname', user: 'postgres', password: 'postgres', port: 12548 # container