ianthrive

Keybase proof

I hereby claim:

• I am ianthrive on github.
• I am ianthrive (https://keybase.io/ianthrive) on keybase.
• I have a public key ASCF0C2HlS5xcLlaKqC29XdE4HwR9RUHoTxVZu9W0N1KzQo

To claim this, I am signing this object:

ianthrive

CREATE OR REPLACE FUNCTION first_dow_of_month(year INTEGER, month INTEGER, dow INTEGER)
 RETURNS date LANGUAGE plpgsql
AS $$
DECLARE
	first_day DATE := (year||'-'||month||'-1')::DATE;
	first_day_plus_week DATE := first_day + '1 week'::INTERVAL;
BEGIN
	RETURN first_day_plus_week + dow - DATE_PART('dow', first_day_plus_week)::INTEGER;
END;
$$;

ianthrive

CREATE OR REPLACE FUNCTION json_diff(l JSONB, r JSONB) RETURNS JSONB LANGUAGE sql AS $$
	SELECT jsonb_object_agg(a.key, a.value) FROM
		( SELECT key, value FROM jsonb_each(l) ) a LEFT OUTER JOIN
		( SELECT key, value FROM jsonb_each(r) ) b ON a.key = b.key
	WHERE a.value != b.value OR b.key IS NULL;
$$;

ianthrive

function levenshtein(a, b) {
	if(a.length == 0) return b.length; 
	if(b.length == 0) return a.length; 
 
	var matrix = [];
 
	// increment along the first column of each row
	var i;
	for(i = 0; i <= b.length; i++) {
		matrix[i] = [i];

ianthrive

CREATE OR REPLACE FUNCTION public.random_md5() RETURNS text LANGUAGE sql
AS $$ SELECT md5(gen_random_bytes(1024)); $$;

CREATE OR REPLACE FUNCTION public.sha256(subject bytea) RETURNS text LANGUAGE sql
AS $function$ SELECT ENCODE(DIGEST($1, 'sha256'), 'hex'); $function$

CREATE OR REPLACE FUNCTION public.random_sha256() RETURNS text LANGUAGE sql
AS $$ SELECT sha256(gen_random_bytes(1024)); $$;

ianthrive

# OS X 10.10
sudo discoveryutil udnsflushcaches; sudo discoveryutil mdnsflushcache

# OS X 10.9
dscacheutil -flushcache; sudo killall -HUP mDNSResponder

# OS X 10.7-10.8
sudo killall -HUP mDNSResponder

# OS X 10.5-10.6

ianthrive

create or replace function diff_elements(anyarray, anyarray)
returns anyarray language sql immutable as $$
select array(
  select unnest($2)
  except
  select unnest($1)
);$$;

create operator - (
procedure = diff_elements,

ianthrive

CREATE OR REPLACE FUNCTION is_leap_year(year integer)
RETURNS BOOLEAN AS $$
        SELECT ($1 % 4 = 0) AND (($1 % 100 <> 0) or ($1 % 400 = 0))
$$ LANGUAGE sql IMMUTABLE STRICT;
 
CREATE OR REPLACE FUNCTION is_leap_year(date date)
RETURNS BOOLEAN AS $$
        SELECT DATE_PART('month', DATE_TRUNC('year', $1)+'1 months 28 days'::INTERVAL) = 2;
$$ LANGUAGE sql IMMUTABLE STRICT;

ianthrive

CREATE OR REPLACE FUNCTION public.extract_nth_dow(d date) RETURNS integer
AS $$
	-- Calculates and returns the Nth day of the week for the given date.
	SELECT (EXTRACT(day FROM d)::INTEGER - 1) / 7 + 1;
$$ LANGUAGE sql;

ianthrive

sudo defaults write /Library/Preferences/com.apple.loginwindow HiddenUsersList -array-add dlt