hbasria / is_private_ip

Created July 7, 2015 15:26

	CREATE OR REPLACE FUNCTION is_private_ip(p_prefix inet) RETURNS boolean AS
	$BODY$
	BEGIN

	RETURN (
	SELECT
	CASE
	WHEN '10.0.0.0/8'::inet >> p_prefix::inet
	OR '192.168.0.0/16'::inet >> p_prefix::inet
	OR '172.16.0.0/12'::inet >> p_prefix::inet THEN True

hbasria / save_restore_dependencies.sql

Last active August 29, 2015 14:24 — forked from mateuszwenus/save_restore_dependencies.sql

	--select deps_save_and_drop_dependencies('public','test_table')

	--select deps_restore_dependencies('public','test_table')

	--select * from deps_saved_ddl

	create table deps_saved_ddl
	(
	deps_id serial primary key,
	deps_view_schema varchar(255),

hbasria / dict_items

Last active August 29, 2015 14:17

	#result = dict_items(response, 'Body/findResponse/result/Interface')
	def dict_items(dict, path, separator='/'):

	for item in path.split(separator):
	if item in dict:
	dict = dict[item]

	if type(dict) is str and len(dict)<=0:
	return None
	else:

hbasria / weeks-grouping.sql

Last active August 29, 2015 14:15 — forked from hgmnz/weeks-grouping.sql

	WITH weeks AS (
	SELECT distinct date_trunc('week', dates)::date AS start,
	daterange(date_trunc('week', dates)::date, (date_trunc('week', dates) + interval '7 days')::date) week
	FROM generate_series(date '2013-01-01', now(), '1 day')
	dates ORDER BY 1
	)
	SELECT weeks.start,
	count(whatever.*) as count
	FROM whatever
	JOIN weeks

hbasria / graphite.md

Last active August 29, 2015 14:07 — forked from kgadek/graphite.md

Installing Graphite:

Graphite does two things:

Store numeric time-series data
Render graphs of this data on demand

What Graphite does not do is collect data for you, however there are some tools out there that know

hbasria / logstash-template.json

Last active August 29, 2015 14:06 — forked from deverton/logstash-template.json

	{
	"template": "logstash-*",
	"settings" : {
	"number_of_shards" : 1,
	"number_of_replicas" : 0,
	"index" : {
	"query" : { "default_field" : "@message" },
	"store" : { "compress" : { "stored" : true, "tv": true } }
	}
	},

hbasria / gunicorn

Created July 8, 2014 14:19 — forked from xspager/gunicorn

	#!/bin/sh

	### BEGIN INIT INFO
	# Provides: gunicorn
	# Required-Start: $all
	# Required-Stop: $all
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: starts the gunicorn server
	# Description: starts gunicorn using start-stop-daemon

hbasria / elasticsearch.yml

Created June 4, 2014 22:16 — forked from poolski/elasticsearch.yml

	# /etc/elasticsearch/elasticsearch.yml
	#
	# Remember the cluster name if you ever add extra nodes
	cluster.name: logstash
	# If you leave node.name blank, it'll autogenerate a node name each time you start ES, picking from 3000 marvel comicbook heroes.
	node.name: "log-indexer"
	node.master: true
	node.data: true

	# Set the bind address specifically (IPv4 or IPv6)

hbasria / installing postgresql 9.3.2 on ubuntu 12.04.md

Created April 15, 2014 11:50 — forked from pyk/installing postgresql 9.3.2 on ubuntu 12.04.md

installing postgresql 9.3.2 on ubuntu 12.04

follow official guide

$ echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" > /etc/apt/sources.list.d/pgdg.list
$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
$ sudo apt-get update
$ sudo apt-get install postgresql-9.3 postgresql-contrib-9.3

you should succesfully installing postgresql 9.3.2 on your machine.

hbasria / Linux Static IP

Created January 5, 2014 21:33 — forked from fernandoaleman/Linux Static IP

	## Configure eth0
	#
	# vi /etc/sysconfig/network-scripts/ifcfg-eth0

	DEVICE="eth0"
	NM_CONTROLLED="yes"
	ONBOOT=yes
	HWADDR=A4:BA:DB:37:F1:04
	TYPE=Ethernet
	BOOTPROTO=static

Basri A. hbasria

Installing Graphite:

installing postgresql 9.3.2 on ubuntu 12.04

follow official guide