Sean Trane Sciarrone seantrane

My Visual Studio Code Preferences

The various settings I use in VS Code. Useful, not only for new setups, but also sharing with others.

These preferences are organized in the order you might configure VS Code from scratch.

Keyboard Shortcuts (keybindings.json)
Settings (settings.json)
Extensions
Workspace config (projects.code-workspace)

CI/CD Services & Software Comparison

There are a lot of continuous integration and continuous delivery services. All of them have a different set of functionality; some of them require payment, some of them are free, some only manage continuous integration and not delivery/deployment, etc.

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

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

Commands

A collection of common shell commands.

Confluence User Macros

Here are some User Macros for Atlassian Confluence.

There are two types of markup in Liquid: Output and Tag.

Output markup (which may resolve to text) is surrounded by

{{ matched pairs of curly brackets (ie, braces) }}

Tag markup (which cannot resolve to text) is surrounded by

	#!/usr/bin/env bash
	#
	# This is a modification from https://gist.github.com/omegahm/28d87a4e1411c030aa89
	# Colours and convention picked from https://robinpowered.com/blog/best-practice-system-for-organizing-and-tagging-github-issues/
	#
	# Instructions
	# Bash 4+ is needed because of associative arrays
	# jq (https://stedolan.github.io/jq/)
	# Create access Token from Github (https://help.github.com/articles/creating-an-access-token-for-command-line-use/) and save it under ".token" file
	# Comment / Uncomment / Add, all the labels you want

	#!/usr/bin/env bash
	# shellcheck disable=SC2034
	# --------------------------------------------------------------------------------------------------
	# ==================================================================================================
	# ==================================================================================================
	# **************************************************************************************************
	#
	# ,ad8888ba, 88 88
	# d8"' `"8b 88 88
	# d8' 88 88

	/* Time-Scales */
	$aTimeScale = array(
	'year' => 31536000,
	'month' => 2628000,
	'week' => 604800,
	'day' => 86400,
	'hour' => 3600,
	'minute' => 60
	);
	/* Expires */

	$mysqli = new mysqli($host,$user,$pass,$db,$port);
	if ($mysqli->connect_errno)
	{
	error_log('Database Connection Error: '.$db.' (URI: '.$_SERVER["REQUEST_URI"].'): #'.$mysqli->connect_errno.' - '.$mysqli->connect_error, 0);
	return false;
	}
	else
	{
	$aReturn = array();
	if ($result = $mysqli->query($sql))