Skip to content

Instantly share code, notes, and snippets.


Robert Sigler rmrfslashbin

View GitHub Profile
rmrfslashbin /
Last active Nov 13, 2022
Trino SQL Queries

Helpful Trino queries

... to fetch data from my aws-cf-rtl and Trino/Superset projects.


I run Trino in a local Docker container. A Trino query can be invoked from the CLI by passing the query into the --execute param.

docker exec -it trino-us-east-1 trino --output-format ALIGNED --execute "${QUERY}"
rmrfslashbin /
Last active Apr 9, 2022
Minimal MacOS setup guide. System/UI and CLI (zsh, Oh My Zsh, brew, etc).
rmrfslashbin /
Last active Oct 28, 2021
Python API Credentials Storage

How to store & access API credentials in Python projects

This gist will explore how to leverage a "dotenv" ecosystem to mange application credentials.

Github Repo

The gist follows code in the repo

The twelve-factor app

The Twelve-Factor App concept provides numerous best-practice guidelines for applications and scipts. This gist will provide a python-based foundation, using the dotenv concept, to manage application credentials as described here:


rmrfslashbin / main.go
Last active Sep 22, 2021
Golang function to return a "simple number"
View main.go
package main
import (
func main() {
rmrfslashbin /
Created Aug 21, 2021
A simple one-liner to re-process videos from the phone.

ffmpeg -i ${INPUT} -c:v libx265 -preset veryslow -vf 'format=yuv420p' -crf 28 ${OUTPUT}.mp4

rmrfslashbin /
Last active Apr 4, 2021
Quick guide to setting up Clevis TPM/Luks boot-time unlock

A brief guide to set up TPM based luks partition unlocing at boot-time.


The TPM must be enabled in the BIOS

Software install

sudo apt install \
  clevis \
 clevis-luks \
#!/usr/bin/env python3
# This script walks block storage devices and locates
# EC2 instance stores. It then lables the disks as
# LMV2 physical volumes (PV), creates an LVM2 volume
# group (VG), then an LVM2 logical volume (LV) and
# finally formats the new LV as XFS.
rmrfslashbin /
Last active Dec 29, 2020
ESLint fix-on-save for VSCode

ESLint fix-on-save for VSCode

This brief guide will enable fix-on-save in VScode for js and vue files.

Install ESLint

ESLint needs to be installed twice: once inside your project and once globally.

# Install globally
$ npm install -g eslint

# Install in project
rmrfslashbin /
Created Oct 3, 2019
Convert a string to hex
#!/usr/bin/env python
import binascii
def getHex(string):
x = binascii.hexlify(string.encode())
y = str(x,'ascii')
print("hex ", y)
rmrfslashbin /
Last active Jul 23, 2022
FoxyProxy: HOW-TO route all traffic through a proxy EXCEPT blacklisted domains.

FoxyProxy URL pattern filters.

This recipe sets up FoxyProxy to route all traffic through a proxy EXCEPT blacklisted domain (they will go out directly).


This receipe assumes a fresh FoxyProxy install, one proxy for everthing, excluding defined domains.

FoxyProxy Configuration

  • FoxyProxy should be set to Use proxies based on their pre-defined patterns and priorities.
  • Add a new proxy and configure the Proxy Details tab as needed.