Joao C Costa joaocc

joaocc / acr-cleanup.sh

Created February 4, 2022 18:49

Cleaning up AzureML images from Azure Container Registry (ACR)

	ACR_NAME="${ACR_NAME:-myacr}"

	az acr show-usage -n "${ACR_NAME}" -o json

	DK_IMAGES=(
	"azureml/azureml_00000000111111110000000011111111"
	"azureml/azureml_11111111000000001111111100000000"
	)
	for i in "${DK_IMAGES[@]}"
	do

joaocc / check_multi_namespaces.sh

Last active March 27, 2022 11:03 — forked from lisawolderiksen/secrets_without_certificates.sh

Script to detect "orphaned" TLS secrets when Cert manager (cainjector) complains about "unable to fetch certificate that owns the secret", because deleting a Certificate will not (default) delete the Secret. (Ref. https://cert-manager.io/docs/usage/certificate/#cleaning-up-secrets-when-certificates-are-deleted)

	#!/usr/bin/env bash
	set -eo pipefail
	set -x

	while [ "$1" != "" ]
	do
	bash secrets_without_certificates.sh -n "$1"
	shift
	done

joaocc / UUID_v7_for_Postgres.sql

Created February 7, 2023 18:18 — forked from kjmph/A_UUID_v7_for_Postgres.sql

Postgres PL/pgSQL function for UUID v7 and a bonus custom UUID v8 to support microsecond precision as well. Read more here: https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

	-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

	create or replace function uuid_generate_v7()
	returns uuid
	as $$
	declare
	unix_ts_ms bytea;
	uuid_bytes bytea;
	begin
	unix_ts_ms = substring(int8send(floor(extract(epoch from clock_timestamp()) * 1000)::bigint) from 3);

joaocc / README.md

Created March 15, 2023 21:25 — forked from forivall/README.md

git-credential-manager reaper script

Simple background script to kill git-credential-manager when it hits the 100% cpu bug

joaocc / .mateuszwenus--save_restore_dependencies.sql

Last active October 25, 2023 07:28 — forked from mateuszwenus/save_restore_dependencies.sql

PostgreSQL: How to handle table and view dependencies

Forked from https://gist.github.com/mateuszwenus/