tkalfigo’s gists

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 / 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 / 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 / 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 / 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 / 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 / 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/)

tkalfigo / Linux Postgresql boot script (sysv style)

Last active April 11, 2016 08:50

	#! /bin/sh

	# chkconfig: 2345 98 02
	# description: PostgreSQL RDBMS
	# File adjusted based on PGSRC/contrib/start-scripts/linux

	# This is an example of a start/stop script for SysV-style init, such
	# as is used on Linux systems. You should edit some of the variables
	# and maybe the 'echo' commands.
	#

tkalfigo / crosstab.sql

Created March 23, 2016 10:20 — forked from romansklenar/crosstab.sql

PostgreSQL "pivot table" example using tablefunc extension

	CREATE EXTENSION tablefunc;

	CREATE TABLE sales(year int, month int, qty int);
	INSERT INTO sales VALUES(2007, 1, 1000);
	INSERT INTO sales VALUES(2007, 2, 1500);
	INSERT INTO sales VALUES(2007, 7, 500);
	INSERT INTO sales VALUES(2007, 11, 1500);
	INSERT INTO sales VALUES(2007, 12, 2000);
	INSERT INTO sales VALUES(2008, 1, 1000);
	INSERT INTO sales VALUES(2009, 5, 2500);

tkalfigo / plv8-javascript-modules-loading.sql

Last active August 29, 2015 14:24 — forked from rafaelveloso/plv8-javascript-modules-loading.sql

	/******************************************************************************
	How to load Javascript modules into postgres
	******************************************************************************/
	CREATE EXTENSION IF NOT EXISTS plv8

	/******************************************************************************
	First step is download the Javascript module file
	Example with undescore-min and node-jpath
	******************************************************************************/

Thalis K. tkalfigo