Skip to content

Instantly share code, notes, and snippets.

View joerx's full-sized avatar
💭
I may be slow to respond.

Jörg Henning joerx

💭
I may be slow to respond.
  • Transferwise
  • Singapore
View GitHub Profile
@joerx
joerx / README.md
Last active December 13, 2022 16:24

Minimalistic Development Box with Libvirt

Linux only, requires KVM and QEMU. libvirt and related components need to be installed. Provisions a development VM based on Ubuntu 20.04. Current working directory will be shared with the guest. This is a PoC, not intended to be a fully functional tool. For any serious use case, use something like Vagrant

@joerx
joerx / shorten.sh
Created August 17, 2020 12:01
Shorten AWS region name using regex
echo "eu-central-1" | sed -E s'/([a-z]{2})-([a-z]{1})[a-z]+-([0-9]{1})/|\1\2\3|/' # 'euc1'
{
"[terraform]": {
"editor.formatOnSave": true,
"editor.tabSize": 2
},
"terraform.indexing": {
"enabled": false,
"liveIndexing": false,
"delay": 500,
"exclude": [
@joerx
joerx / gist:6e398bb26e5527a948647a15cb76f7f3
Last active November 30, 2019 09:18
Russian roulette, Terraform edition. Because `rm -rf /` doesn't quite cut it anymore.
RISK=5
[[ $(( ( RANDOM % 6 ) + 1 )) -gt $RISK ]] && echo "terraform destroy -target module.production_db -auto-approve"
# for discussion and alternatives, see https://unix.stackexchange.com/questions/227662/how-to-rename-multiple-files-using-find
find . -type f -name general.tf -not -path '*/.terraform/*' -exec sh -c 'x="{}"; mv "$x" "${x/general/backend}"' \;
@joerx
joerx / psql.md
Last active July 22, 2019 11:02
Postgres Cheat Sheet

List databases

\list
\l

Connect

<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
function helmns() {
ctx=`kubectl config current-context`
ns=`kubectl config view -o=jsonpath="{.contexts[?(@.name==\"$ctx\")].context.namespace}"`
echo "Using tiller-namespace $ns"
helm --tiller-namespace $ns $@
}
@joerx
joerx / snippets.sh
Created December 21, 2018 13:05
Extract docker images from drone yaml
images=$(cat .drone.yml | grep "image: quay.io" | grep -v "hb-backend" | sed -e 's/[[:space:]]\{0,\}image: quay.io\/\(.*\)\/\(.*\)/\1\/\2/' | awk -F ':' '{ print $1 ":" ($2==""?"latest":$2) }' | uniq)
@joerx
joerx / script.sh
Created December 4, 2018 08:47
Delete RDS snapshots
#!/bin/sh
for snap in $(cat deleteme.txt); do
echo delete $snap
aws rds delete-db-snapshot --db-snapshot-identifier $snap
done