Skip to content

Instantly share code, notes, and snippets.

View rossmcdonald's full-sized avatar

Ross McDonald rossmcdonald

View GitHub Profile
@rossmcdonald
rossmcdonald / db.yml
Created September 14, 2021 13:57
Standalone postgres helm deployment
postgresqlUsername: kong
postgresqlDatabase: kong
existingSecret: kong-enterprise-postgres-password
service:
port: 5432
@rossmcdonald
rossmcdonald / .bash_profile
Created August 27, 2021 14:50
Create gifs from the shell with ffmpeg and gifsicle
function convertgif() {
echo "Converting $@"
ffmpeg -i "$@" -pix_fmt rgb24 -r 15 -f gif - | gifsicle --optimize=0 -o "${@%????}.gif"
}
@rossmcdonald
rossmcdonald / query-logging.sh
Created January 17, 2020 17:59
PostgreSQL query logging
# enable query logging
sed -i "s/.*log_statement = .*/log_statement = 'all'/" /home/node/postgresql/*/main/postgresql.conf
supervisorctl signal sighup postgres
# disable query logging
sed -i "s/log_statement = .*/log_statement = 'none'/" /home/node/postgresql/*/main/
supervisorctl signal sighup postgres
@rossmcdonald
rossmcdonald / docker-compose.yml
Created November 15, 2019 16:54
GitLab docker-compose
version: "2"
services:
redis:
restart: always
image: sameersbn/redis:4.0.9-2
command:
- --loglevel warning
volumes:
- redis-data:/var/lib/redis:Z
@rossmcdonald
rossmcdonald / main.js
Created October 18, 2019 14:34
Add anchor links to headers using jquery
let link_svg = '<svg xmlns="http://www.w3.org/2000/svg" height="16px" width="16px" aria-hidden="true" focusable="false" data-prefix="fas" data-icon="link" class="svg-inline--fa fa-link fa-w-2" role="img" viewBox="0 0 512 512"><path fill="currentColor" d="M326.612 185.391c59.747 59.809 58.927 155.698.36 214.59-.11.12-.24.25-.36.37l-67.2 67.2c-59.27 59.27-155.699 59.262-214.96 0-59.27-59.26-59.27-155.7 0-214.96l37.106-37.106c9.84-9.84 26.786-3.3 27.294 10.606.648 17.722 3.826 35.527 9.69 52.721 1.986 5.822.567 12.262-3.783 16.612l-13.087 13.087c-28.026 28.026-28.905 73.66-1.155 101.96 28.024 28.579 74.086 28.749 102.325.51l67.2-67.19c28.191-28.191 28.073-73.757 0-101.83-3.701-3.694-7.429-6.564-10.341-8.569a16.037 16.037 0 0 1-6.947-12.606c-.396-10.567 3.348-21.456 11.698-29.806l21.054-21.055c5.521-5.521 14.182-6.199 20.584-1.731a152.482 152.482 0 0 1 20.522 17.197zM467.547 44.449c-59.261-59.262-155.69-59.27-214.96 0l-67.2 67.2c-.12.12-.25.25-.36.37-58.566 58.892-59.387 154.781.36 214.59a152.454 152.454 0 0 0 20
@rossmcdonald
rossmcdonald / docker-install.sh
Last active September 6, 2019 18:26
Install Docker on Ubuntu
#!/bin/bash
sudo apt-get remove -y docker docker-engine docker.io containerd runc
sudo apt-get update
sudo apt-get install -y \
apt-transport-https \
ca-certificates \
curl \
gnupg-agent \
software-properties-common
import influxdb
host = 'my.influxdb.server'
port = 8086
dbname = 'my_db'
def write_dicts(measurement, tagDict, fieldDict):
myclient = influxdb.InfluxDBClient(host=host, port=port, database=dbname)
# data is a list of points
data = []