elifarley’s gists

elifarley / postgresql_cheats.sql

Created January 18, 2022 11:36 — forked from kgorman/postgresql_cheats.sql

	-- PostgreSQL cheat sheet

	--postgres is set up to use local.6 which is syslog'd to sflog001
	--slow query log is /var/log/localmessages
	--config files are always in /data/friend/*.conf

	--vacuums are set via cfengine, we use both manual and auto. vacuums/analyze help with frozen id's being recouped, and thus TX'id's not going over 2b thus causing massing shutdown/reset. Fix it to exp/imp high TX tables.

	--to log into psql: psql -U postgres -d <DB> (usually friend)

elifarley / ec2-host-from-tag-to-env-vars.sh

Last active December 15, 2016 17:02 — forked from marcellodesales/ec2-host-from-tag-to-env-vars.sh

Create Environment Variables in EC2 Hosts from EC2 Host Tags, just like Beanstalk or Heroku does!

	######
	# Author: Marcello de Sales ([email protected])
	# Description: Create Environment Variables in EC2 Hosts from EC2 Host Tags
	#
	### Requirements:
	# * Install jq library (sudo apt-get install -y jq)
	# * Install the EC2 Instance Metadata Query Tool (http://aws.amazon.com/code/1825)
	#
	### Installation:
	# * Add the Policy EC2:DescribeTags to a User

elifarley / hgbkp-jenkins.hgignore

Last active April 13, 2017 19:27 — forked from abayer/jenkins-git-backup.sh

Script for backing up Jenkins home to a Mercurial (Hg) repository.

# Moved to https://github.com/elifarley/docker-jenkins-uidfv/blob/master/hgbkp-jenkins.hgignore

elifarley / opb58enc-mssql.sql

Last active March 16, 2018 13:57 — forked from micahwalter/base58.sql

Order-Preserving Base-58

	-- num <= 430804206899405823: <= 10 digits
	-- num > 430804206899405823: 11 digits
	CREATE FUNCTION opb58enc (@num bigint) RETURNS char(11) WITH SCHEMABINDING AS
	BEGIN
	DECLARE @alphabet char(58) = '0123456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnpqrstuvwxyz'
	DECLARE @encoded varchar(11)
	DECLARE @divisor bigint
	DECLARE @mode int = 0

	SET @encoded = ''

elifarley / jira-curl.sh

Last active May 14, 2019 08:48 — forked from TheMightyLlama/jira-curl.sh

How to use curl and here-documents to post a JSON document to create an issue in Jira in a more readable way

	JIRA_REST_URL="${JIRA_REST_URL:-https://MYCOMPANY.jira.com/rest/api/2}"
	JIRA_CREDENTIALS="${JIRA_CREDENTIALS:-user:password}"

	# https://developer.atlassian.com/jiradev/api-reference/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-example-discovering-meta-data-for-creating-issues

	# https://MYCOMPANY.jira.com/rest/api/2/issue/createmeta?projectKeys=MYPROJ&issuetypeNames=MyIssueType&expand=projects.issuetypes.fields
	# customfield_10171: My Custom Field Name 1
	# customfield_10172: My Custom Field Name 2

	# This methods create a new issue of type 'MyIssueType' in project 'MYPROJ' with 2 custom fields

elifarley / 0_reuse_code.js

Last active August 29, 2015 14:18

Here are some things you can do with Gists in GistBox.

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

elifarley / reql.py

Last active August 29, 2015 14:16 — forked from RedBeard0531/functions.js

Compute sample standard deviation, coefficient of variation and other stats over large datasets in RethinkDB using Map-Reduce in ReQL. See https://github.com/rethinkdb/rethinkdb/issues/3769#issuecomment-77229538

	> load('functions.js')
	> db.stuff.drop()
	false
	> db.stuff.insert({value:1})
	> db.stuff.insert({value:2})
	> db.stuff.insert({value:2})
	> db.stuff.insert({value:2})
	> db.stuff.insert({value:3})
	> db.stuff.mapReduce(map, reduce, {finalize:finalize, out:{inline:1}}).results[0]
	{

Elifarley C. elifarley