BryGom brygom

brygom / fullquery

Created March 13, 2017 18:44 — forked from OllieJones/fullquery

Fast nearest-location finder for SQL (MySQL, PostgreSQL, SQL Server)

	SELECT zip, primary_city,
	latitude, longitude, distance
	FROM (
	SELECT z.zip,
	z.primary_city,
	z.latitude, z.longitude,
	p.radius,
	p.distance_unit
	* DEGREES(ACOS(COS(RADIANS(p.latpoint))
	* COS(RADIANS(z.latitude))

brygom / change_owner_postgresql_objects

Created March 4, 2017 07:00

Change owner to objects in PostgreSQL. Code from Anvesh Patel

	CREATE OR REPLACE FUNCTION ChangeObjectsOwnerShip(text)
	returns text language plpgsql volatile
	AS $f$
	BEGIN
	EXECUTE $1;
	RETURN $1;
	END;
	$f$;

	-- Tables, Sequences and Views

brygom / install_psql_php.sh

Created December 14, 2016 04:00 — forked from doole/install_psql_php.sh

Install PostgreSQL PHP extensions on Mac OS X

	#!/bin/bash

	# Install Xcode Command Line Tools first (required)
	xcode-select --install

	# Check PHP version `php --version`
	PHP_VER=$(php -v \| head -1 \| awk '{ print $2 }')

	# Extensions directory (default: empty string)
	EXT_DIR=""

brygom / IMEI.class

Created September 13, 2016 23:01

Get IMEI from ANDROID Application

	public class IMEI{

	public String getIMEI(){
	//add
	//<uses-permission android:name="android.permission.READ_PHONE_STATE" />
	//in manifest
	TelephonyManager tm = (TelephonyManager)getSystemService(TELEPHONY_SERVICE);
	String imei= tm.getDeviceId();
	return imei;

brygom / gist:edc88062a341c40e825f44f1817e5b0d

Created July 5, 2016 01:03 — forked from pitch-gist/gist:2999707

HTML: Simple Maintenance Page

	<!doctype html>
	<title>Site Maintenance</title>
	<style>
	body { text-align: center; padding: 150px; }
	h1 { font-size: 50px; }
	body { font: 20px Helvetica, sans-serif; color: #333; }
	article { display: block; text-align: left; width: 650px; margin: 0 auto; }
	a { color: #dc8100; text-decoration: none; }
	a:hover { color: #333; text-decoration: none; }
	</style>