Pepe Navarro artefactop

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)

Using OTP's observer (appmon replacement) remotely

$ ssh remote-host "epmd -names"
epmd: up and running on port 4369 with data:
name some_node at port 58769

Note the running on port for epmd itself and the port of the node you're interested in debugging. Reconnect to the remote host with these ports forwarded:

$ ssh -L 4369:localhost:4369 -L 58769:localhost:58769 remote-host

openssl

Install

Install the OpenSSL on Debian based systems

sudo apt-get install openssl

	#See a nice git log:
	git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit --


	#configure that git log by default

	git config --global alias.lg "log --color --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit --"

	#next time just
	git lg

	-module(encode_uri_rfc3986).
	-author('Renato Albano <[email protected]>').

	-export([encode/1]).

	%% Taken from <http://erlangexamples.com/>,
	%% from <http://github.com/CapnKernul/httparadise>
	%% and <http://www.erlang.org/doc/man/edoc_lib.html>

	encode([C \| Cs]) when C >= $a, C =< $z ->

	date_to_integer_iso8601({date,{Y,M,D}}) ->
	datetime_to_integer_iso8601({datetime,{{Y,M,D},{0,0,0}}}).
	datetime_to_integer_iso8601({datetime,{{Y,M,D},{H,Min,S}}}) ->
	Y * 10000000000 + M * 100000000 + D * 1000000 + H * 10000 + Min * 100 + S.

	package main

	import (
	"net/http"
	"database/sql"
	"fmt"
	"log"
	"os"
	)

	# Inspired from http://coding4streetcred.com/blog/post/Asymmetric-Encryption-Revisited-(in-PyCrypto)
	# PyCrypto docs available at https://www.dlitz.net/software/pycrypto/api/2.6/

	from Crypto import Random
	from Crypto.PublicKey import RSA
	import base64

	def generate_keys():
	# RSA modulus length must be a multiple of 256 and >= 1024
	modulus_length = 256*4 # use larger value in production

	git branch -m old_branch new_branch # Rename branch locally
	git push origin :old_branch # Delete the old branch
	git push --set-upstream origin new_branch # Push the new branch, set local branch to track the new remote