Shyam Sankarraman shyam

shyam / ffencode.txt

Created January 16, 2021 17:07 — forked from jemekite/ffencode.txt

ffmpeg preserve metadata

ffmpeg -i input.mp4 -vcodec h264 -acodec aac -map_metadata 0 output.mp4

shyam / aws-cf-logs

Last active October 9, 2020 15:15 — forked from shapeshed/aws-cf-logs

Fetch AWS Cloudfront Logs, decompress, combine into a single file and remove comments

	#!/usr/bin/env bash

	BUCKET=$1
	CWD=$(pwd)

	if [[ -n $1 ]]; then
	aws s3 sync s3://$BUCKET/cf-logs .
	cat *.gz > combined.log.gz
	find $CWD ! -name 'combined.log.gz' -name '*.gz' -type f -exec rm -f {} +
	gzip -d combined.log.gz

shyam / postgres_queries_and_commands.sql

Created July 21, 2016 05:44 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

shyam / Disable strict mode in homebrew mysql

Last active August 29, 2015 14:06

	(ffr@ffr:mysql [master] ❷ ->0)$ cat /usr/local/opt/mysql/my.cnf
	[mysqld]

	sql_mode=NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES

shyam / gist:1940844

Created February 29, 2012 13:30 — forked from lelayf/gist:1929949

Procedure for installing and setting Sun JDK Java 6 on Amazon Linux AMI 64bit

	# Get latest Sun Java SDK in v6 from Oracle
	wget http://download.oracle.com/otn-pub/java/jdk/6u31-b04/jdk-6u31-linux-x64-rpm.bin

	# make it exec
	chmod +x jdk-6u31-linux-x64-rpm.bin

	# Install Java
	sudo ./jdk-6u31-linux-x64-rpm.bin

	# Check if the default java version is set to sun jdk