jeabraham

jeabraham / GedcomBackup.scpt

Last active October 6, 2020 23:45

Applescript GUI Script to backup Family Tree Maker tree to a gedcome file

	set backup_location to "/Volumes/ExtraDisk/FamilyTreeMakerBackups"

	backup_recent_tree("Abraham family tree 2018.ftm", backup_location)
	backup_recent_tree("de Kat Family Tree_2017-05-13.ftm", backup_location)

	on backup_recent_tree(tree_name, backup_location)
	try
	tell application "Family Tree Maker 2019"
	activate
	end tell

jeabraham / compress_old_dirs.sh

Created February 2, 2021 19:01

Shell script to compress directories more than 10 weeks old, using AFSC tool

	# MacOS has on-the-fly decompression, but not on-the-fly compression.
	# AFSC tool https://github.com/RJVB/afsctool.git is handy
	# for applying compression, but if you're actively working
	# on something, you'll be writing new files, meaning stuff won't stay.
	# compressed. Even saving a new
	# version of a file from an application usually means a brand
	# new (uncompressed) file.

	# Also, directories containing compressed files like jpg images
	# or movies won't benefit from file system level compression.

jeabraham / postgres_queries_and_commands.sql

Created April 7, 2022 08:08 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'