Skip to content

Instantly share code, notes, and snippets.

Daniel Serodio dserodio

View GitHub Profile
@dserodio
dserodio / test-psql-connectivity.sh
Last active Apr 7, 2020
Useful for testing downtime while applying modifications in RDS
View test-psql-connectivity.sh
while true; do
date -Isec | sed -e 's/+00:00//' | tr '\n' ' '
pg_isready -h YOUR_RDS_INSTANCE.rds.amazonaws.com -U USER -d DB_NAME
sleep 1
done | tee connection-test-$(date -Imin).log
View rename_lambda_tags.py
"""Replace 'name' tag with 'Name' and 'application' with 'Application'
"""
import boto3
def uppercaseTagKeys(arn, name, application=None):
tags = {}
if name:
tags['Name'] = name
@dserodio
dserodio / Dockerfile
Last active Apr 12, 2019
Dockerfile for multi-stage build of a Ruby app which needs Node at build time (credits: https://github.com/gomex)
View Dockerfile
# Dockerfile for a multi-stage build of a Ruby app which needs Node at build time
#
# Thanks to https://github.com/gomex for sharing
FROM ruby:2.5.1 as builder
RUN curl -sL https://deb.nodesource.com/setup_8.x | bash - &&\
curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add - &&\
echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list
@dserodio
dserodio / say.sh
Created Nov 12, 2018
Using Google Text to Speech (TTS) in Linux CLI
View say.sh
# gTTS (Google Text-to-Speech), a Python library and CLI tool to interface with Google Translate's text-to-speech API
# https://github.com/pndurette/gTTS
pipsi install gTTS
sudo apt install mpg123
say() {
gtts-cli "$@" | mpg123 -
}
@dserodio
dserodio / history.sh
Last active Sep 13, 2019
Misc bash snippets
View history.sh
# Show timestamp for history output
export HISTTIMEFORMAT="%d/%m/%y %T "
@dserodio
dserodio / README.md
Created Sep 24, 2018
Config. AWS PostgreSQL RDS to use pgbadger
View README.md

Set the following properties in RDS:

log_min_duration_statement = 250
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
log_autovacuum_min_duration = 0
@dserodio
dserodio / docker-stats.sh
Created Aug 23, 2018
Sane `docker stats` for ECS #docker
View docker-stats.sh
# `docker stats` in Docker 17.06.2, used in ECS at the moment, shows container IDs instead of names
# see https://github.com/moby/moby/issues/20973
docker stats $(docker ps --format={{.Names}})
@dserodio
dserodio / dropdown.md
Created Aug 9, 2018 — forked from citrusui/dropdown.md
"Dropdowns" in Markdown
View dropdown.md
How do I dropdown?
This is how you dropdown.

<details>
<summary>How do I dropdown?</summary>
<br>
This is how you dropdown.
View collapse_all_files_in_diff.js
// https://github.com/isaacs/github/issues/514#issuecomment-408216389
Array.from(document.getElementsByClassName('js-details-target')).forEach(function(element){element.click()})
View interrupt.py
"""Handle SIGINT (aka Ctrl+C)"""
import sys
import signal
signal.signal(signal.SIGINT, lambda signal_number, current_stack_frame: sys.exit(1))
You can’t perform that action at this time.