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 / blockstack ID

Created November 26, 2018 16:01

Verifying my Blockstack ID is secured with the address 1EqA3rUVJbCUATQowatgcADNYUoQALhyza https://explorer.blockstack.org/address/1EqA3rUVJbCUATQowatgcADNYUoQALhyza

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 / logback.xml

Last active January 27, 2017 07:05

Logback configuration with JSON output when run in a container

	<?xml version="1.0" encoding="UTF-8"?>
	<configuration debug="false" scan="true" scanPeriod="120 seconds" packagingData="false">

	<if condition='p("HOME").startsWith("/app")'><then> <!-- Docker -->
	<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
	<encoder class="net.logstash.logback.encoder.LogstashEncoder">
	<!--<timeZone>UTC</timeZone>-->
	<timeZone>Brazil/East</timeZone>
	<includeContext>false</includeContext>
	<includeCallerData>false</includeCallerData>

elifarley / Kotlin + Spring Data

Last active October 13, 2016 15:28

JdbcTemplate examples in Kotlin

.

elifarley / Kotlin + Spring Data + MS SQL

Last active October 24, 2018 14:14

Kotlin + Spring Data + MS SQL - Insert rows via stored procedure using Spring Data; Select using native SQL query

.

elifarley / dt2asbigint.sql

Created January 8, 2016 17:36

DateTime2 to BigInt - MS SQL

	-- Monotonic function that returns a bigint representing a given datetime2.

	CREATE FUNCTION dt2asbigint(@dt datetime2) RETURNS BIGINT WITH SCHEMABINDING AS
	BEGIN
	declare @twoAsBigInt bigint = 2
	declare @bytesInDate int = 3
	declare @bitsInTime int = 8 * (8 - @bytesInDate)

	declare @bigdatetime binary(9) = cast(@dt as binary(9))
	declare @bigdate bigint = cast(reverse(substring(@bigdatetime, 7, @bytesInDate)) as binary(3))

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 / onename.md

Created November 19, 2015 01:45

Verifying that +elifarley is my blockchain ID. https://onename.com/elifarley

Elifarley C. elifarley