Andrew Kramarev akramarev

## jq-convert-json-csv.sh
# https://earthly.dev/blog/convert-to-from-json/
cat simple.json| jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'

## disable-fks.sql
-- If SET (or equivalently SET SESSION) is issued within a transaction that is later aborted, the effects of the SET command disappear when the transaction is rolled back. Once the surrounding transaction is committed, the effects will persist until the end of the session, unless overridden by another SET.

SET session_replication_role = 'replica';
...
SET session_replication_role = 'origin';

## check-open-handlers-connections.sh
lsof -p 66298

## get-db-indexes.sql
SELECT tablename,
       count(1) as count
FROM pg_indexes p
WHERE p.tablename not like 'pg_%'
GROUP BY p.tablename
ORDER BY p.tablename

## git-local-cleanup
git remote prune origin
git branch -vv | grep 'origin/.*: gone]' | awk '{print $1}' | xargs git branch -D
	# https://earthly.dev/blog/convert-to-from-json/
	cat simple.json\| jq -r '(map(keys) \| add \| unique) as $cols \| map(. as $row \| $cols \| map($row[.])) as $rows \| $cols, $rows[] \| @csv'
	-- If SET (or equivalently SET SESSION) is issued within a transaction that is later aborted, the effects of the SET command disappear when the transaction is rolled back. Once the surrounding transaction is committed, the effects will persist until the end of the session, unless overridden by another SET.

	SET session_replication_role = 'replica';
	...
	SET session_replication_role = 'origin';
	SELECT tablename,
	count(1) as count
	FROM pg_indexes p
	WHERE p.tablename not like 'pg_%'
	GROUP BY p.tablename
	ORDER BY p.tablename
	git remote prune origin
	git branch -vv \| grep 'origin/.*: gone]' \| awk '{print $1}' \| xargs git branch -D