detj

# List all Google Cloud regions and zones
#
# It may ask to enable the [compute.googleapis.com] API if it has not been enabled earlier.
gcloud compute zones list

# List all Google Cloud zones of a region
gcloud compute zones list | rg us-central

# Set the default region for a configuration
gcloud config set compute/region REGION_NAME

detj

# List all configurations
gcloud config configurations list

# Activate a configuration
gcloud config configurations activate CONFIGURATION_NAME

# Rename a configuration
gcloud config configurations rename CONFIGURATION_NAME --new-name=NEW_NAME

detj

# List all the enabled Google Cloud APIs
gcloud services list --enabled

detj

# This command keeps the last 5 revisions and deletes the rest.
# --quiet - do not prompt for (Y/n)
# Replace <name> with the name of of the Cloud Run service
#
# Depending on the count of unused revisions this operation will
# take a few minutes to complete.
gcloud run revisions list --service=<name> --format="value(metadata.name)" | tail -n +6 | xargs -n1 gcloud run revisions delete --quiet

detj

-- Drop all connections except the one running this query
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'measure'
  AND pid <> pg_backend_pid();

detj

#!/usr/bin/env bash

git describe --tags --abbrev=0

detj

rclone mount <remote-name>:<bucket-name> <local-dir> \
    --daemon \
    --devname <device-name> \
    --allow-other \
    --vfs-cache-mode full \
    --vfs-cache-max-size 10G \
    --log-level INFO \
    --log-file /tmp/rclone-vfs-remote-mount.log

detj

# "test" is the input
printf "test" | openssl dgst -sha256 -binary | openssl base64

# output - n4bQgYhMfWWaL+qgxVrQFaO/TxsrC4Is0V1sFbDwCgg=

detj

brew list --installed-on-request

detj

# syntax
# gh repo view <repo> --json createdAt

# example
gh repo view measure-sh/measure --json createdAt