memezilla’s gists

memezilla / json_manipulator.sql

Created March 7, 2017 03:58 — forked from matheusoliveira/json_manipulator.sql

Simple PostgreSQL functions to manipulate json objects. (Note: performance is not a concern for those functions)

	CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
	RETURNS json
	IMMUTABLE
	LANGUAGE sql
	AS $$
	SELECT ('{'\|\|string_agg(to_json(key)\|\|':'\|\|value, ',')\|\|'}')::json
	FROM (
	SELECT * FROM json_each(data)
	UNION ALL
	SELECT * FROM json_each(insert_data)

memezilla / postgresql_jsonb_crud.sql

Created March 7, 2017 03:51 — forked from inindev/postgresql_jsonb_crud.sql

Simple PostgreSQL 9.4 functions to manipulate jsonb objects adapted from Matheus de Oliveira's json_manipulator.sql. https://gist.github.com/matheusoliveira/9488951 (Note: performance is not a concern for those functions)

	/*
	* derivative work of Matheus de Oliveira's json_manipulator.sql
	* https://gist.github.com/matheusoliveira/9488951
	*
	* adapted to support postgresql 9.4 jsonb type
	* no warranties or guarantees of any kind are implied or offered
	*
	* license is as Matheus conferred it on 4/9/2015:
	* matheusoliveira commented on Apr 9
	* @hannes-landeholm, I'd like to take credit if you share them

memezilla / exif_gps.py

Created February 22, 2017 12:38 — forked from snakeye/exif_gps.py

Python: get GPS latitude and longitude coordinates from JPEG EXIF using exifread

	import exifread

	# based on https://gist.github.com/erans/983821

	def _get_if_exist(data, key):
	if key in data:
	return data[key]

	return None

memezilla / ng-book.conf

Created July 9, 2016 02:52 — forked from simkimsia/ng-book.conf

restler api nginx config

	server {
	listen 80;
	client_max_body_size 2M;
	server_name ng-book.oppoin.com;
	root /var/virtual/ng-book.oppoin.com/current/examples/http-api-server;

	location / {
	index index.html index.htm;
	}

memezilla / automongobackup.sh

Created April 26, 2016 07:33 — forked from infynyxx/automongobackup.sh

Backup script for MongoDB; Source: http://github.com/micahwedemeyer/automongobackup/raw/master/src/automongobackup.sh

	#!/bin/bash
	#
	# MongoDB Backup Script
	# VER. 0.1
	# Note, this is a lobotomized port of AutoMySQLBackup
	# (http://sourceforge.net/projects/automysqlbackup/) for use with
	# MongoDB.
	#
	# This program is free software; you can redistribute it and/or modify
	# it under the terms of the GNU General Public License as published by

memezilla / gist:d726573e75ecb635be34

Created January 27, 2016 01:01 — forked from Brant/gist:3c315504e1c98142f6a9

Forever, node.js, CentOS Service, Unprivileged User

	#!/bin/sh
	# chkconfig: 2345 85 15
	# description: Startup script for project.

	# exit on first error
	set -e

	# user running this script
	_user="$(id -u -n)"

memezilla / nginx.conf

Last active August 31, 2015 03:21 — forked from plentz/nginx.conf

Best nginx configuration for improved security(and performance). Complete blog post here http://tautt.com/best-nginx-configuration-for-security/

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

Lee memezilla