AlexBaitov’s gists

AlexBaitov / postgres_queries_and_commands.sql

Created October 2, 2019 08:31 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

AlexBaitov / pedantically_commented_playbook.yml

Created December 21, 2015 06:20 — forked from marktheunissen/pedantically_commented_playbook.yml

Insanely complete Ansible playbook, showing off all the options

	---
	# ^^^ YAML documents must begin with the document separator "---"
	#
	#### Example docblock, I like to put a descriptive comment at the top of my
	#### playbooks.
	#
	# Overview: Playbook to bootstrap a new host for configuration management.
	# Applies to: production
	# Description:
	# Ensures that a host is configured for management with Ansible.

AlexBaitov / closurize.php

Created November 25, 2015 10:20 — forked from rintaun/closurize.php

closurize(): Converts any valid PHP callable into a Closure. Requires PHP 5.4.0+.

	<?php
	/**
	* Converts any valid PHP callable into a Closure. Requires PHP 5.4.0+.
	*
	* The ramifications of this are many, but basically it means that any function
	* or method can be converted into a Closure, bound to another scope, and
	* executed easily. Works properly even with private methods.
	*
	* - On success, returns a Closure corresponding to the provided callable.
	* - If the parameter is not callable, issues an E_USER_WARNING and returns a

AlexBaitov / AnObj.php

Created November 24, 2015 08:36 — forked from nick-mok/AnObj.php

This is a revision of George Mihailhoff's PHP Anonymous Object Class. I stumbled upon this class as I was looking for a way to attach functions to properties in a stdClass. This is not directly possible as there is no __call function inbuilt. And I found this code on a stackoverflow post that George had answered. However the implementation didn'…

	<?php

	class AnObj
	{
	protected $methods = array();
	protected $properties = array();

	public function __construct(array $options)
	{

AlexBaitov / json_merge.coffee

Created November 10, 2015 08:53 — forked from jphaas/json_merge.coffee

	#To install:
	#
	#In your git configuration (for instance, .git/config to do it at the project level), add:
	#
	#[merge "json_merge"]
	# name = A custom merge driver for json files
	# driver = coffee json_merge.coffee %O %A %B
	# recursive = binary
	#
	#In your project's .gitattributes file, add something like:

AlexBaitov / mergelog.py

Created November 10, 2015 08:43 — forked from seanh/mergelog.py

A custom merge driver for git, for automatically merging my 'log.txt' file in a simplistic way.

	#!/bin/env python
	"""mergelog

	This is a custom merge driver for git. It should be called from git
	with a stanza in .git.config like this:

	[merge "mergelog"]
	name = A custom merge driver for my log.txt file.
	driver = ~/scripts/mergelog %O %A %B %L
	recursive = binary