Jacob Johansen JacobJohansen

Senior Software Engineer: DevOps, SecOps, Frontend, Backend, ETL

JacobJohansen / convert-pgp-to-ssh.sh

Created November 18, 2021 18:14 — forked from mdellavo/convert-pgp-to-ssh.sh

Convert PGP Public Key to OpenSSH

	# import the public key
	gpg --import ../alice.asc
	gpg --export $KEYID \| openpgp2ssh $KEYID

JacobJohansen / s3-to-alb-with-lambda.py

Created November 18, 2021 20:11 — forked from Burekasim/s3-to-alb-with-lambda.py

access s3 objects with ALB using lambda

	import os
	import json
	import boto3
	from botocore.exceptions import ClientError


	def lambda_handler(event, context):
	# use 'AWS_REGION' environment variable from lambda built-in variables
	aws_region = os.environ['AWS_REGION']
	bucket_name = os.environ['BUCKET_NAME']

JacobJohansen / postgres_queries_and_commands.sql

Created March 29, 2024 19:05 — 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%'