MrHen’s gists

MrHen / genre.txt

Last active February 26, 2024 15:21

Random lists

MrHen / Readme.md

Created June 15, 2019 02:22

AST Examples

Links

MrHen / aboutturnis.txt

Last active September 18, 2019 14:22

Riddles

	aboutTurn Is...

	Where: Skating Class
	Judges Score: 2.7

	Some square confronts you and begins asking you questions that just don't seem important.

	1. Q9K4 KRUXNLT K9ERA "HG MQNJ IULVI4" DK1 "RVRVLYB IS07V0 02HGI" (XIB TIRZNLF GNL QIS9 OYGEGC9E ASJ2VL)?
	2. Q9K4 S9 K1KVH VPOC'9 C1RKW K5UEVLW?
	3. 9K 9K4I9WI4 LVEFV GI1U, XI14 AI UIB 1EELVRAK4IA WVLO CNL "QIDKMI" (CI PJJPIVA WK "XI1OM LPWZ")?

MrHen / thoughts.md

Last active October 31, 2018 19:31

Clean Code

function buildUser({ firstName, lastName }) {

MrHen / db_sizes.sql

Last active July 3, 2019 16:01

Postgres Debugging

	SELECT
	pg_database.datname,
	pg_size_pretty(pg_database_size(pg_database.datname)) AS size
	FROM pg_database;

MrHen / fdw.sql

Last active September 5, 2018 21:15

Postgres FDW

	CREATE EXTENSION IF NOT EXISTS postgres_fdw;
	CREATE EXTENSION IF NOT EXISTS dblink;

	CREATE SERVER {server_name}
	FOREIGN DATA WRAPPER postgres_fdw
	OPTIONS (
	host {src_host},
	port {src_port},
	dbname {src_db}
	)

MrHen / generate_series.sql

Last active November 16, 2018 16:21

Sample Data

	INSERT INTO {table_schema}.{table_name} (
	name,
	city,
	customer_id,
	last_purchase,
	nps,
	value_tier,
	customer_since
	)
	SELECT

MrHen / json_unwind.sql

Created January 18, 2018 21:27

Postgres JSON Unwind

	with contacts as (
	select cr.id as contact_record_id
	, cr.customer_id
	, cr.form_version_id
	, r.key as question_id
	, r.value#>>'{}' as question_response
	from cx_snapshot.contacts_newcontactrecord cr
	, jsonb_each(cr.fields::jsonb->'responses') r
	)
	, questions as (

MrHen / snapshot_changes.sql

Created December 29, 2017 19:09

Snapshot SQL

	EXPLAIN ANALYZE SELECT COALESCE(src.key, dst.key) as key
	, dst.key IS NULL as added
	, src.key IS NULL as removed
	, COALESCE(md5(src::text) <> md5(dst::text), false) as changed
	, md5(src::text) as src_hash
	, md5(src::text) as dst_hash

	FROM "ab_two" as src
	FULL OUTER JOIN "ab_one" as dst ON (src.key = dst.key)

MrHen / unerror.js

Created October 20, 2017 14:56

Unerror

	function unerror (value) {
	if (value instanceof Error) {
	var error = {}

	Object.getOwnPropertyNames(value).forEach(function (key) {
	error[key] = value[key]
	})

	return error
	}