Skip to content

Instantly share code, notes, and snippets.

View gugsrs's full-sized avatar

Gustavo Siqueira gugsrs

View GitHub Profile
@gugsrs
gugsrs / sp
Created September 9, 2020 08:11 — forked from wandernauta/sp
sp is a command-line client for Spotify's dbus interface. Play, pause, skip and search tracks from the comfort of your command line.
#!/usr/bin/env bash
#
# This is sp, the command-line Spotify controller. It talks to a running
# instance of the Spotify Linux client over dbus, providing an interface not
# unlike mpc.
#
# Put differently, it allows you to control Spotify without leaving the comfort
# of your command line, and without a custom client or Premium subscription.
#
@gugsrs
gugsrs / postgres-cheatsheet.md
Created December 7, 2018 11:25 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
@gugsrs
gugsrs / tmux-cheatsheet.markdown
Created November 27, 2017 16:14 — forked from MohamedAlaa/tmux-cheatsheet.markdown
tmux shortcuts & cheatsheet

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname
@gugsrs
gugsrs / create_sqs_sns.py
Last active May 7, 2019 20:47
Script to create SQS and SNS from yaml
#!/usr/bin/env python
import sys
import yaml
from subprocess import call
def main():
f = open(sys.argv[1])
data = yaml.load(f)
create_queues(data['Local']['Queues'])