Skip to content

Instantly share code, notes, and snippets.

View as's full-sized avatar

as

View GitHub Profile
@dlsniper
dlsniper / Dockerfile
Last active June 27, 2018 07:06
Dockerfile to test your Go code with the latest version of Go 1.10
FROM golang:1.10beta2
ADD . /go/src/github.com/<user>/<repo>
WORKDIR /go/src/github.com/<user>/<repo>
RUN go test -coverpkg=all -coverprofile cover.out ./...
explain analyze select * from user_details where details -> 'info' ->> 'crop' = 'Corn' and details -> 'info' ->> 'farmSize' = '2-3' limit 50;
QUERY PLAN |
----------------------------------------------------------------------------------------------------------------------------------------------------------|
Limit (cost=1000.00..136551.01 rows=50 width=426) (actual time=3.764..4.346 rows=50 loops=1) |
-> Gather (cost=1000.00..255835.90 rows=94 width=426) (actual time=0.165..40.441 rows=50 loops=1) |
Workers Planned: 2 |
Workers Launched: 2
@sirlaurie
sirlaurie / build-ffmpeg-and-mpv.sh
Last active March 4, 2024 16:11
a script for building ffmpeg and mpv with capable playing dolby vision
#!/usr/bin/env zsh
# just for macOS
#
# The default options for installing ffmpeg and mpv via brew do not include the activation of libplacebo.
# As a result, when playing videos in Dolby Vision, the color mapping is not accurate. To resolve this issue,
# a script is used to compile ffmpeg with libplacebo activated, followed by the building of mpv.
# Extra: build mpv bundle, with jxl
if [ "$(uname -s)" != "Darwin" ]; then
@nateify
nateify / FEL2P8.sh
Created May 2, 2023 02:05
Simplified method of remuxing MKV with Dolby Vision P7 FEL to P8.1 with EL discarded
#!/bin/bash
if [ "$#" -ne 1 ]; then
echo "Usage: $0 input_file" >&2
exit 1
fi
input_file="$1"
input_dir=$(dirname "$input_file")
input_base=$(basename "${input_file%.*}")