magnetikonline

PostgreSQL list tables without defined primary key

This query can be handy for tasks such as setting up a logical replication publication, where by default a table's PRIMARY KEY is used to identify subscriber side rows for update or delete.

By locating tables without a PRIMARY KEY (tisk!), we're able to either update the table schema, or use an alternative replica identity type.

SELECT tbl.table_catalog,tbl.table_schema,tbl.table_name
FROM information_schema.tables tbl
WHERE

magnetikonline

Node.js HTTP echo server

Simple HTTP server, listening on localhost:8083 which just echoes back HTTP requets sent to it.

Blantant ripoff of: https://gist.github.com/bszwej/62c327d773051816ed4949fd40c82c74

magnetikonline

Delete all AWS CodeBuild build history

Quick way to delete all existing build history from AWS CodeBuild using the AWS CLI.

#!/bin/bash -e

buffer=()
for buildId in $(aws codebuild list-builds --query 'ids.join(`\n`,@)' --output text); do
 buffer+=($buildId)

magnetikonline

Install AWS CLI v2 from source

Bash script to install the latest released version of the AWS CLI v2 from the distrubuted source.

Using this method to exectue the CLI under a MacBook M1 laptop as a native ARM binary - rather than falling back to Rosetta. Currently the offically packaged macOS .pkg doesn't support both Intel/M1 architectures.

Script designed to be re-run - will blow away an existing install and re-install the latest available version.

Note

This install script assumes you have installed a suitable version of Python 3 - has been tested against:

magnetikonline

Using curl to AWS V4 sign request to AWS_IAM API Gateway endpoint

Small Bash script, calling curl with the --aws-sigv4 option to AWS V4 sign a given request for use with an IAM authorized API Gateway endpoint.

Usage

./aws-api-gateway-iam.sh \
  --request GET \
 "https://api-gateway.mydomain.com/this/route/aws-iam-authz"

magnetikonline

GitHub Markdown cheatsheet

• Colored alerts
• Expand/collapse zone

Colored alerts

> [!NOTE]
> Note.

magnetikonline

macOS execute command upon directory change via launchd

Using launchd to watch a filesystem directory and upon create/change to a file with the directory, execute a command.

Install

For this example:

• Watching directory of: /path/to/watch.
• Upon file change, execute: /path/to/command argument1 argument2.

magnetikonline

Docker volume backup and restore scripts

Backup a Docker volume to tar archive:

$ ./docker-volume-backup.sh \
  DOCKER_VOLUME_NAME \
  ARCHIVE_NAME.tgz

magnetikonline

Node.js strict mode enabled?

A quick test, this relies on the fact that this will not exist and point to the global scope when running in strict mode.

console.log('strict:',(function() { return (this === undefined); })());

Tip

Strict mode is enabled by default within ES module enabled packages.

magnetikonline

Import all GPG keys for GitHub organisation users

Fetches a GitHub organisation member list and proceeds to gpg --import public GPG key(s) for each member associated against their profile.

Requires:

• curl for GitHub API calls
• jq for parsing GitHub REST API responses
• and (obviously) gpg