Adam Zell azell

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER D

Installation

mkdir -p ~/.config && touch ~/.config/ssh-agent.pid
Paste the contents of ssh-agent-manage.sh into your .bashrc or .bash_profile or similar
killall -9 ssh-agent
Start a new terminal session (note: old sessions will not see ssh-agent, only new ones)

Details

This snippet, when included in .bashrc, will ensure that your session has a working ssh-agent with all your ssh keys loaded into it. It does this without creating separate ssh-agent processes by:

	-- DateDiff function that returns the difference between two timestamps in the given date_part (weeks, months, etc) as an integer
	-- This behaves like the DateDiff function in warehouses like Redshift and Snowflake, which count the boundaries between date_parts
	CREATE OR REPLACE FUNCTION datediff (date_part VARCHAR(30), start_t TIMESTAMP, end_t TIMESTAMP)
	RETURNS INT AS $diff$

	DECLARE
	years INT = 0;
	days INT = 0;
	hours INT = 0;
	minutes INT = 0;

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1" />
	<title>Fisher-Yates</title>
	</head>
	<body>
	<h1>Fisher-Yates Shuffling in Javascript</h1>
	<p>Open the console, ensure that the accompanying javascript file is also available, then click the button below.</p>

	CREATE FUNCTION uuid_time_nextval(interval_length int default 60, interval_count int default 65536)
	RETURNS uuid
	LANGUAGE plpgsql
	AS $$
	DECLARE
	v_i int;
	v_prefix_bytes int = 0;
	v_time bigint;
	v_bytes int[16] = '{}';
	v_hex text[16] = '{}';

	#!/usr/bin/env bash

	set -Eeuo pipefail
	trap cleanup SIGINT SIGTERM ERR EXIT

	script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P)

	usage() {
	cat <<EOF
	Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -p param_value arg1 [arg2...]

	// Thank you to the folks at the C++ slack channel,
	// along with @lewissbaker for the excellent literature
	// (even though it took me a few days to be convinced
	// it really was so).

	#include <uv.h>

	#include <iostream>
	#include <experimental/coroutine>

	CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

	-- My port of https://github.com/kurttheviking/uuid-with-v6-js
	-- A hacky translation of:
	-- - http://gh.peabody.io/uuidv6/
	-- - https://tools.ietf.org/html/draft-peabody-dispatch-new-uuid-format
	CREATE OR REPLACE FUNCTION uuid_v1_to_v6(v1 uuid)
	RETURNS uuid AS $$
	DECLARE
	v6 text;

	public class LookasideCache {
	private CacheCluster cacheCluster;
	private LeaseUtils leaseUtils;

	/**
	* Read a value utilizing a lookaside cache.
	*
	* @param key whose value is to be returned
	* @param sourceOfTruthComputation the function to use to fetch the value from the
	* source of truth if that should become necessary.