gromgit’s gists

gromgit / sqlite_missing_column.sh

Last active February 19, 2025 10:14

	#!/usr/bin/env bash
	cmd() {
	echo ">>> $(printf '%q ' "$@")" >&2
	time "$@"
	}
	sqlite=/opt/homebrew/opt/sqlite/bin/sqlite3
	csvs=(perfect_0.csv perfect_1.csv imperfect_2.csv)

	# Generate CSVs
	for i in $(seq -f %07.0f 9999999); do

gromgit / build_sqtcl

Last active February 18, 2025 15:52

building statically-linked tclsh with built-in SQLite

	#!/usr/bin/env bash
	fatal() {
	printf 'FATAL ERROR: %s' "$*"
	exit 1
	}
	base=tcl${ver:-9.0.1}
	cd "$(dirname "$0")" \|\| fatal "unable to cd to script dir"
	instroot=$(pwd)/inst
	[[ -s ${base}-src.tar.gz ]] \|\| fatal "unable to find src tarball 'tcl${ver}-src.tar.gz'"
	rm -fr build "$instroot" "$base"

gromgit / sharexec

Created August 2, 2024 07:54

sharexec - create a shar that also runs a specific executable bundled in the shar

	#!/usr/bin/env bash
	# USAGE: sharexec [-d <dir>] <executable> <file>... > my.sh
	# Creates a shar file containing <executable> + all <file>s
	# On execution:
	# 1. unpack everything in <dir> (default: temp dir)
	# 2. run <executable>
	# 3. if temp dir used, remove it

	warn() {
	echo "WARNING: $*" >&2

gromgit / dotnet-sdk-api-install.log

Created February 4, 2023 03:35

HOMEBREW_INSTALL_FROM_API causes wrong path to be derived

	$ brew install --debug --cask dotnet-sdk
	/opt/homebrew/Library/Homebrew/shims/shared/curl --disable --cookie /dev/null --globoff --show-error --user-agent Homebrew/3.6.20-167-g7a5f614\ $Macintosh\;\ arm64\ Mac\ OS\ X\ 12.6.1$\ curl/7.79.1 --header Accept-Language:\ en --max-time 5 --retry 3 --fail https://formulae.brew.sh/api/cask-source/dotnet-sdk.rb
	/opt/homebrew/Library/Homebrew/shims/shared/curl --disable --cookie /dev/null --globoff --show-error --user-agent Homebrew/3.6.20-167-g7a5f614\ $Macintosh\;\ arm64\ Mac\ OS\ X\ 12.6.1$\ curl/7.79.1 --header Accept-Language:\ en --fail --progress-bar --silent --max-time 5 --retry 3 --location --remote-time --output /Users/aho/Library/Caches/Homebrew/api/cask.json --time-cond /Users/aho/Library/Caches/Homebrew/api/cask.json --compressed --silent https://formulae.brew.sh/api/cask.json
	/opt/homebrew/Library/Homebrew/shims/shared/curl --disable --cookie /dev/null --globoff --show-error --user-agent Homebrew/3.6.20-167-g7a5f614\ \(Macintosh\;\ arm64\ Mac\ OS\ X\ 1

gromgit / dotnet-sdk-api-install.log

Created February 1, 2023 00:52

HOMEBREW_INSTALL_FROM_API causes wrong path to be derived

	$ brew install --debug --cask dotnet-sdk
	/opt/homebrew/Library/Homebrew/shims/shared/curl --disable --cookie /dev/null --globoff --show-error --user-agent Homebrew/3.6.20-167-g7a5f614\ $Macintosh\;\ arm64\ Mac\ OS\ X\ 12.6.1$\ curl/7.79.1 --header Accept-Language:\ en --max-time 5 --retry 3 --fail https://formulae.brew.sh/api/cask-source/dotnet-sdk.rb
	/opt/homebrew/Library/Homebrew/shims/shared/curl --disable --cookie /dev/null --globoff --show-error --user-agent Homebrew/3.6.20-167-g7a5f614\ $Macintosh\;\ arm64\ Mac\ OS\ X\ 12.6.1$\ curl/7.79.1 --header Accept-Language:\ en --fail --progress-bar --silent --max-time 5 --retry 3 --location --remote-time --output /Users/aho/Library/Caches/Homebrew/api/cask.json --time-cond /Users/aho/Library/Caches/Homebrew/api/cask.json --compressed --silent https://formulae.brew.sh/api/cask.json
	/opt/homebrew/Library/Homebrew/shims/shared/curl --disable --cookie /dev/null --globoff --show-error --user-agent Homebrew/3.6.20-167-g7a5f614\ \(Macintosh\;\ arm64\ Mac\ OS\ X\ 1

gromgit / # bzt - 2022-01-24_23-37-20.txt

Created January 24, 2022 15:37

bzt on macOS 12 - Homebrew build logs

	Homebrew build logs for bzt on macOS 12
	Build date: 2022-01-24 23:37:20

gromgit / # sc-im - 2021-05-27_14-37-02.txt

Created May 27, 2021 14:37

sc-im on Ubuntu 18.04.5 LTS - Homebrew build logs

	Homebrew build logs for sc-im on Ubuntu 18.04.5 LTS
	Build date: 2021-05-27 14:37:02

gromgit / # yaws - 2021-05-24_10-05-03.txt

Created May 24, 2021 10:05

yaws on Ubuntu 18.04.5 LTS - Homebrew build logs

	Homebrew build logs for yaws on Ubuntu 18.04.5 LTS
	Build date: 2021-05-24 10:05:03

gromgit / test_prefix.sh

Created March 11, 2021 09:09

	#!/usr/bin/env bash
	tapdir=$HOMEBREW_REPOSITORY/Library/Taps
	tmpd=$(mktemp -d)
	trap 'rm -fr "$tmpd" "${tapdir}"/test/homebrew-tap[0-9]*' EXIT

	# Set up taps for testing
	# Tap with Formula
	[[ -d "${tapdir}"/gromgit/homebrew-dev ]] \|\| brew tap gromgit/dev
	# Tap with HomebrewFormula
	[[ -d "${tapdir}"/mikosa/homebrew-awsp ]] \|\| brew tap mikosa/awsp https://github.com/mikosa/aws-permission

gromgit / dump_bcrypt_hash.c

Created May 30, 2018 05:51

Dump salt and digest of bcrypt hash

	// Original src: https://github.com/pyca/bcrypt/blob/master/src/_csrc/bcrypt.c

	#include <stdio.h>
	#include <string.h>
	#include <sys/types.h>

	// Maps to character set "./ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"
	static const u_int8_t index_64[128] = {
	255, 255, 255, 255, 255, 255, 255, 255, 255, 255,
	255, 255, 255, 255, 255, 255, 255, 255, 255, 255,

Adrian Ho gromgit