Skip to content

Instantly share code, notes, and snippets.

View tkalfigo's full-sized avatar

Thalis K. tkalfigo

5 followers · 1 following
  • Berlin, Germany
View GitHub Profile
@tkalfigo
tkalfigo / wal_archive_scp.sh
Last active June 21, 2019 11:48
Bash shell script for WAL archiving over ssh to remote host when doing replication with Postgresql
#!/bin/bash -x
PG_DATA_DIR="/home/postgresql/data";
DEST_HOST="example.com";
DEST_DIR="/home/remote_user/WAL_ARCHIVE";
SCP_USERNAME="remote_user";
# uses ssmtp to send email [for setup see: http://www.havetheknowhow.com/Configure-the-server/Install-ssmtp.html]
EMAIL_RECIPIENT="myself@example.com";
EMAIL_MSG="To: myself@example.com\nFrom: myself@example.com\nSubject: Replication error\n\n";
#in case of error, how long to sleep before retrying
@tkalfigo
tkalfigo / encrypt_decrypt_example.js
Created June 8, 2019 11:42 — forked from erans/encrypt_decrypt_example.js
Example of encryption and decryption in node.js
var crypto = require("crypto")
function encrypt(key, data) {
var cipher = crypto.createCipher('aes-256-cbc', key);
var crypted = cipher.update(data, 'utf-8', 'hex');
crypted += cipher.final('hex');
return crypted;
}
@tkalfigo
tkalfigo / agg.sql
Created September 29, 2017 19:49 — forked from ryandotsmith/agg.sql
Postgres array concatenation aggregate function.
CREATE AGGREGATE array_accum (anyarray)
(
sfunc = array_cat,
stype = anyarray,
initcond = '{}'
);
@tkalfigo
tkalfigo / .psqlrc
Last active September 11, 2017 22:00
My .psqlrc
\set QUIET 1
\pset null '(null)'
\pset linestyle unicode
\pset border 2
\timing
\set ON_ERROR_ROLLBACK interactive
\set HISTFILE ~/.psql_history- :HOST - :DBNAME
\set HISTSIZE 2000
\set PROMPT1 '%n@%/[%M:%>] # '
\set PROMPT2 '> '
@tkalfigo
tkalfigo / bash-git-prompt additional file to have user@host on the prompt
Created July 7, 2017 10:12
# Add this file as ~/.git-prompt-colors.sh
# This is the custom theme template for gitprompt.sh
override_git_prompt_colors() {
GIT_PROMPT_THEME_NAME="Custom"
GIT_PROMPT_START_USER="_LAST_COMMAND_INDICATOR_ ${ResetColor} ${Yellow}${PathShort}${ResetColor}"
GIT_PROMPT_START_ROOT="${GIT_PROMPT_START_USER}"
GIT_PROMPT_END_USER=" \n${Green}[${USER}@${HOSTNAME%%.*}] ${Time12a}${ResetColor} $ "
}
@tkalfigo
tkalfigo / gist:8093636
Last active July 4, 2017 19:03
Useful git aliases
# alias gitlo='git log --no-walk --tags --pretty="%h %d %s" --decorate=full --oneline'
alias gitlo='git log --pretty="%h %ad %d %s (%an)" --decorate=full --graph -n 30 | grep -E --color "^|tag: "'
alias gitloa='git log --no-walk --tags --pretty="%h %d %s" --decorate=full --author=youremail@foo.com --oneline'
alias gitbra="git branch -vva"
alias gitsta="git status"
alias gitdif="git diff --color-words"
alias gitlosum="git log --stat --summary"
alias gitdifstat="git diff --stat --summary"
alias gitpull="git pull --rebase"
alias gitpru="git remote prune origin"
@tkalfigo
tkalfigo / Sudocabulary + neofetch in .bashrc
Created April 13, 2017 18:59
# pretty terminal system info
/usr/bin/neofetch
# sudocabulary [https://github.com/badarsh2/Sudocabulary]
chmod +x ~/.vocab
~/.vocab
@tkalfigo
tkalfigo / lodashify.js
Created April 9, 2017 11:54 — forked from khalilovcmd/lodashify.js
to import lodash into chrome dev tools console
var el = document.createElement('script');
el.src = "https://raw.githubusercontent.com/lodash/lodash/3.10.1/lodash.min.js";
el.type = "text/javascript";
document.head.appendChild(el)
@tkalfigo
tkalfigo / ChromeExtensionGulp.js
Created March 28, 2017 09:05 — forked from TravelingTechGuy/ChromeExtensionGulp.js
Gulp file for building a Chrome Extension
'use strict';
//npm install gulp gulp-minify-css gulp-uglify gulp-clean gulp-cleanhtml gulp-jshint gulp-strip-debug gulp-zip --save-dev
var gulp = require('gulp'),
clean = require('gulp-clean'),
cleanhtml = require('gulp-cleanhtml'),
minifycss = require('gulp-minify-css'),
jshint = require('gulp-jshint'),
stripdebug = require('gulp-strip-debug'),
@tkalfigo
tkalfigo / setup-headless-selenium-xvfb.sh
Created March 14, 2017 10:33 — forked from alonisser/setup-headless-selenium-xvfb.sh
#!/bin/bash
#
# Bash script to setup headless Selenium (uses Xvfb and Chrome)
# (Tested on Ubuntu 12.04) trying on ubuntu server 14.04
# Add Google Chrome's repo to sources.list
echo "deb http://dl.google.com/linux/chrome/deb/ stable main" | sudo tee -a /etc/apt/sources.list
# Install Google's public key used for signing packages (e.g. Chrome)
# (Source: http://www.google.com/linuxrepositories/)