Peter Mescalchin magnetikonline

Google spreadsheet auto sort rows after cell change

Example: Spreadsheet of expenses (sheet name Expenses) starting from the sixth row (allowing for headers/etc.) with each expense date in column A. After update of any expense row date cell, all line items are automatically resorted by date.

How to implement:

From Google spreadsheet goto: Extensions -> Apps Script.
Enter the following JavaScript code:

Sending AWS SNS message subscription into Slack workflow

Inspired by: https://stackoverflow.com/a/72574950

A no-code solution to push messages sent to an AWS SNS topic into Slack via a workflow webhook.

Create a new Slack Workflow, using From a webhook as the triggering event.
Include the following Data variables:

Message

Jira un-thread item comments bookmarklet

Atlassian added the concept of Threaded Comments around September 2025.

Currently there is no formal method to "un-thread" a conversation into a sequential list of comments. This bookmarklet is a (hacky) attempt to un-thread ticket comments and place in descending date order.

Usage

Create a new empty bookmark. Name it appropriately (e.g. Jira comment un-thread).
Copy contents of bookmarklet.js place into the URL of the new bookmark.

Chrome extensions I use

Locate unused AWS security groups

For an AWS Security Group to be considered in-use/active it will be assigned to an Elastic network interface (ENI's).

The following Python script will determine currently unused security groups by:

Query AWS for all active ENI's in an account region.
For each interface, extract the attached security group(s).
Query AWS for all security groups within the same account region.
Determine where and output a security group which currently has zero assignments to any active ENI's.

Extract AWS IAM action list tables to JSON

A quick-and-dirty browser script for extracting action list tables from AWS Identity and Access Management pages to JSON documents.

Once in JSON, these IAM action lists can be easily queried using tools such as jq to answer questions such as:

List all Write IAM actions for service X.
List all Read IAM actions for service X resource type Y.

Usage example

Install Rsync on macOS from source

Bash script to install a much more recent version of rsync from source on macOs.

Requires as a minimum Xcode CLI tools (no need for a full install). Can be installed via the following:

$ xcode-select --install

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

	include "/usr/local/share/nano/*.nanorc"

	set mouse
	set tabsize 2

	bind M-f nextword main
	bind M-b prevword main

	import fs from 'node:fs';
	// const fs = require('fs');

	function buildCommand(deps,flag = '') {
	if (!deps) return;
	const packages = Object.entries(deps)
	.map(([name,version]) => `${name}@${version.replace(/^[\^~]/,'')}`)
	.join(' ');

	if (flag) {