Skip to content

Instantly share code, notes, and snippets.

View joverlee521's full-sized avatar

Jover Lee joverlee521

  • Seattle, WA
View GitHub Profile
#!/bin/bash
# Modified for TSV based on the comment from @paulfitz at
# https://github.com/paulfitz/daff/issues/127#issuecomment-433538271
if [[ -z "$2" ]]; then
echo "Call as foo.tsv foo.sqlite"
exit 1
fi
header=$(head -n1 $1)
header=$(echo $header | sed "s/ /, /g")
@joverlee521
joverlee521 / jsonb_containment.txt
Created May 13, 2020 00:31
shipping.scan_follow_up_encounters_query_plan
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop Left Join (cost=1312.91..99487.74 ro
@joverlee521
joverlee521 / gist:23557038429aeeb0b1274d6ad9203ebb
Created September 15, 2018 17:17 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream