bandicoot86’s gists

bandicoot86 / clickhouse-get-tables-size.sql

Created September 12, 2018 18:35 — forked from sanchezzzhak/clickhouse-get-tables-size.sql

clickhouse get tables size

	SELECT table,
	formatReadableSize(sum(bytes)) as size,
	min(min_date) as min_date,
	max(max_date) as max_date
	FROM system.parts
	WHERE active
	GROUP BY table

bandicoot86 / gist:c0b7e15003075330bcd548ba90f52e06

Created May 27, 2018 11:52 — forked from kgorman/gist:134896c7414fde8e090b

MongoDB Profiler Cheat Sheet

	// a list of useful queries for profiler analysis. Starting with the most basic.
	// 2.4 compatible
	//

	// output explained:
	//
	{
	"ts" : ISODate("2012-09-14T16:34:00.010Z"), // date it occurred
	"op" : "query", // the operation type
	"ns" : "game.players", // the db and collection

bandicoot86 / ThinkLight

Created February 4, 2018 14:33 — forked from vzaliva/ThinkLight

This script controll keyboard backlight on IBM ThinkPad X-series

	#!/bin/bash

	# Vadim Zaliva [email protected]
	# based on https://gist.github.com/hadess/6847281

	if [[ $EUID -ne 0 ]]; then
	echo "This script must be run as root" 1>&2
	exit 1
	fi

bandicoot86 / JoinerTest.java

Last active August 29, 2015 14:25 — forked from K0NRAD/JoinerTest.java

	@Test
	public void testJoiner() throws Exception {
	List<String> texts = Lists.newArrayList("eins", null, "drei", "vier", "fünf", "sechs", "sieben", null);
	String joined;
	String expected;

	joined = Joiner.on(";")
	.skipNulls()
	.join(texts);

bandicoot86 / IonicCordovaNetwork.js

Last active August 29, 2015 14:24 — forked from welcoMattic/IonicCordovaNetwork.js

	var myApp = angular.module('myApp').service('CordovaNetwork', ['$ionicPlatform', '$q', function($ionicPlatform, $q) {
	// Get Cordova's global Connection object or emulate a smilar one
	var Connection = window.Connection \|\| {
	"CELL" : "cellular",
	"CELL_2G" : "2g",
	"CELL_3G" : "3g",
	"CELL_4G" : "4g",
	"ETHERNET" : "ethernet",
	"NONE" : "none",
	"UNKNOWN" : "unknown",

bandicoot86 / ubuntu-compass-ruby

Last active August 29, 2015 14:09 — forked from stephanetimmermans/ubuntu-compass-ruby

	#https://gorails.com/setup/ubuntu/14.04
	sudo apt-get update
	sudo apt-get install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties
	sudo apt-get install libgdbm-dev libncurses5-dev automake libtool bison libffi-dev

	curl -L https://get.rvm.io \| bash -s stable
	source ~/.rvm/scripts/rvm
	echo "source ~/.rvm/scripts/rvm" >> ~/.bashrc
	rvm install 2.1.2
	rvm use 2.1.2 --default

bandicoot86 / database.yml.example mysql2

Created November 17, 2013 08:07 — forked from erichurst/database.yml.example mysql2

	# MySQL. Versions 4.1 and 5.0 are recommended.
	#
	# Install the MySQL driver:
	# gem install mysql2
	#
	# And be sure to use new-style password hashing:
	# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
	development:
	adapter: mysql2
	encoding: utf8

bandicoot86 / ajax-form.js

Created October 24, 2013 14:03 — forked from havvg/ajax-form.js

	jQuery(function($) {
	$('form[data-async]').live('submit', function(event) {
	var $form = $(this);
	var $target = $($form.attr('data-target'));

	$.ajax({
	type: $form.attr('method'),
	url: $form.attr('action'),
	data: $form.serialize(),

bandicoot86 / database.yml

Created October 8, 2013 16:35 — forked from danopia/database.yml

	# SQLite version 3.x
	# gem install sqlite3-ruby (not necessary on OS X Leopard)
	development:
	adapter: sqlite3
	database: db/development.sqlite3
	pool: 5
	timeout: 5000

	# Warning: The database defined as "test" will be erased and
	# re-generated from your development database when you run "rake".

Anton bandicoot86