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:

	// 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.

	/**
	* Returns a Time Sortable ID with millisecond precision.
	*
	* Time component: 42 bits (2^42 = ~69 years)
	*
	* Random component: 22 bits (2^22 = 4,194,304)
	*
	* The time component is the count of milliseconds since 2020-01-01T00:00:00Z.
	*
	* Tags: tsid ulid snowflake id-generator generator time sortable sort order id

	package uuid;

	import java.nio.ByteBuffer;
	import java.security.SecureRandom;
	import java.time.Instant;
	import java.util.UUID;

	public class OtherUUIDUtil {

	private static final int UUID_LENGTH = 16;

	version: '3'

	services:

	traefik:
	container_name: traefik
	image: traefik:v2.0
	command:
	- "--api.insecure=true"
	- "--providers.docker=true"

	-- Copy/paste this file or execute with `psql -f thisfile.sql`

	CREATE ROLE owner CREATEDB LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;

	ALTER ROLE owner SET statement_timeout = 20000;
	ALTER ROLE owner SET lock_timeout = 3000;
	ALTER ROLE owner SET idle_in_transaction_session_timeout = 3000; -- v9.6+

	CREATE ROLE readwrite_users NOLOGIN;
	CREATE ROLE readonly_users NOLOGIN;

	CREATE ROLE owner LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;
	ALTER ROLE owner SET statement_timeout = 20000;
	ALTER ROLE owner SET lock_timeout = 3000;
	ALTER ROLE owner SET idle_in_transaction_session_timeout = 3000; -- v9.6+

	CREATE ROLE readwrite_users NOLOGIN;
	CREATE ROLE readonly_users NOLOGIN;

	CREATE DATABASE exampledb WITH OWNER owner ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';