Skip to content

Instantly share code, notes, and snippets.


Daniel Serodio dserodio

View GitHub Profile
dserodio / Vagrantfile
Last active Oct 14, 2020 — forked from lorn/Vagrantfile
View Vagrantfile
# -*- mode: ruby -*-
# vi: set ft=ruby :
Vagrant.configure("2") do |config|
config.vm.provider :virtualbox do |vb| = "ubuntu.local"
vb.customize [ 'modifyvm', :id, '--memory', '512' ]
vb.customize [ 'modifyvm', :id, '--cpus', '1' ]
dserodio /
Last active Oct 14, 2020
Keybase proof

Keybase proof

I hereby claim:

  • I am dserodio on github.
  • I am dserodio ( on keybase.
  • I have a public key whose fingerprint is CFB1 D267 024B 720A F4F5 27AB 6C51 A8CC BB58 BCC8

To claim this, I am signing this object:

dserodio /
Last active Sep 16, 2020
AWS snippets
# find the owner of an AWS access key
for user in $(aws iam list-users --output text | awk '{print $NF}'); do
aws iam list-access-keys --user $user --output text
# alternative that uses jq(1) insteaed of awk(1)
for user in $(aws iam list-users --query 'Users[*].UserName' --output text); do
dserodio / psql_check_ssl.sql
Created Aug 20, 2020
Check if PostgreSQL is using SSL
View psql_check_ssl.sql
SELECT, s.ssl, s.version, a.client_addr, a.usename, a.datname, a.query
FROM pg_stat_ssl AS s
JOIN pg_stat_activity AS a ON =;
-- You can see `t|f` in `ssl` field
dserodio /
Created Aug 12, 2020
Hide Google Sheets columns with zeros
function onOpen() {
// get active spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
// create menu
var menu = [{name: "Hide columns", functionName: "hideColumns"},
dserodio /
Last active Apr 7, 2020
Useful for testing downtime while applying modifications in RDS
while true; do
date -Isec | sed -e 's/+00:00//' | tr '\n' ' '
pg_isready -h -U USER -d DB_NAME
sleep 1
done | tee connection-test-$(date -Imin).log
dserodio /
Last active Sep 13, 2019
Misc bash snippets
# Show timestamp for history output
export HISTTIMEFORMAT="%d/%m/%y %T "
"""Replace 'name' tag with 'Name' and 'application' with 'Application'
import boto3
def uppercaseTagKeys(arn, name, application=None):
tags = {}
if name:
tags['Name'] = name
dserodio / Dockerfile
Last active Apr 12, 2019
Dockerfile for multi-stage build of a Ruby app which needs Node at build time (credits:
View Dockerfile
# Dockerfile for a multi-stage build of a Ruby app which needs Node at build time
# Thanks to for sharing
FROM ruby:2.5.1 as builder
RUN curl -sL | bash - &&\
curl -sS | apt-key add - &&\
echo "deb stable main" | tee /etc/apt/sources.list.d/yarn.list
dserodio /
Last active Dec 17, 2018
Some git tips

Don't blame people for changing whitespaces or moving code

git blame will show the author of the last commit that modified the particular line. If whitespaces were removed or that piece of code was moved around, blame will show that commit and you might blame the wrong person.

git blame -w -M

-w will ignore whitespaces and -M will detect moved or copied lines.