nyzm / nearby-coordinates.sql

Created April 22, 2018 06:04 — forked from statickidz/nearby-coordinates.sql

Ordering with SQL by nearest latitude & longitude coordinates (MySQL & SQLite)

	---
	METHOD 1

	This should roughly sort the items on distance in MySQL, and should work in SQLite.
	If you need to sort them preciser, you could try using the Pythagorean theorem (a^2 + b^2 = c^2) to get the exact distance.
	---
	SELECT *
	FROM table
	ORDER BY ((lat-$user_lat)(lat-$user_lat)) + ((lng - $user_lng)(lng - $user_lng)) ASC

nyzm / README.md

Created January 15, 2018 15:18 — forked from remcotolsma/README.md

WordPress development environment on Mac with Brew, Nginx, PHP 7, PHP-FPM, MariaDB, phpMyAdmin and more

Brew

http://brew.sh/

brew tap homebrew/dupes
brew tap homebrew/versions
brew tap homebrew/homebrew-php

nyzm / countries.sql

Created July 31, 2017 10:56 — forked from paulochf/countries.sql

	CREATE TABLE IF NOT EXISTS `country` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`iso` char(2) NOT NULL,
	`name` varchar(80) NOT NULL,
	`nicename` varchar(80) NOT NULL,
	`iso3` char(3) DEFAULT NULL,
	`numcode` smallint(6) DEFAULT NULL,
	`phonecode` int(5) NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;

nyzm / gist:8ef2be0ebfe546258e91dbd906761901

Created July 26, 2017 06:44

Exit signals

	$ kill -l
	1) SIGHUP 2) SIGINT 3) SIGQUIT 4) SIGILL
	5) SIGTRAP 6) SIGABRT 7) SIGBUS 8) SIGFPE
	9) SIGKILL 10) SIGUSR1 11) SIGSEGV 12) SIGUSR2
	13) SIGPIPE 14) SIGALRM 15) SIGTERM 16) SIGSTKFLT
	17) SIGCHLD 18) SIGCONT 19) SIGSTOP 20) SIGTSTP
	21) SIGTTIN 22) SIGTTOU 23) SIGURG 24) SIGXCPU
	25) SIGXFSZ 26) SIGVTALRM 27) SIGPROF 28) SIGWINCH
	29) SIGIO 30) SIGPWR 31) SIGSYS 34) SIGRTMIN
	35) SIGRTMIN+1 36) SIGRTMIN+2 37) SIGRTMIN+3 38) SIGRTMIN+4

nyzm / html_for_international_calling coes.htm

Created July 11, 2017 10:09 — forked from andyj/html_for_international_calling coes.htm

HTML <select> international calling codes for each country

	<!-- country codes (ISO 3166) and Dial codes. -->
	<select name="countryCode" id="">
	<option data-countryCode="GB" value="44" Selected>UK (+44)</option>
	<option data-countryCode="US" value="1">USA (+1)</option>
	<optgroup label="Other countries">
	<option data-countryCode="DZ" value="213">Algeria (+213)</option>
	<option data-countryCode="AD" value="376">Andorra (+376)</option>
	<option data-countryCode="AO" value="244">Angola (+244)</option>
	<option data-countryCode="AI" value="1264">Anguilla (+1264)</option>
	<option data-countryCode="AG" value="1268">Antigua & Barbuda (+1268)</option>

nyzm / API.md

Created June 1, 2017 05:18 — forked from iros/API.md

Documenting your REST API

Title

<Additional information about your API call. Try to use verbs that match both request type (fetching vs modifying) and plurality (one vs multiple).>

URL

<The URL Structure (path only, no root url)>
Method:

nyzm / elastic_search_ngram_analyzer_for_urls.sh

Created April 22, 2014 03:52 — forked from karmi/elastic_search_ngram_analyzer_for_urls.sh

	# ========================================
	# Testing n-gram analysis in ElasticSearch
	# ========================================

	curl -X DELETE localhost:9200/ngram_test
	curl -X PUT localhost:9200/ngram_test -d '
	{
	"settings" : {
	"index" : {
	"analysis" : {

nyzm / es.sh

Created March 19, 2014 07:59

	cd ~
	sudo apt-get update
	sudo apt-get install openjdk-7-jre-headless -y

	### Check http://www.elasticsearch.org/download/ for latest version of ElasticSearch and replace wget link below

	# NEW WAY / EASY WAY
	wget https://download.elasticsearch.org/elasticsearch/elasticsearch/elasticsearch-1.0.1.deb
	sudo dpkg -i elasticsearch-1.0.1.deb

nyzm / gist:9595516

Created March 17, 2014 08:01

localrc for devstack

	# Misc
	DATABASE_PASSWORD=password
	ADMIN_PASSWORD=password
	SERVICE_PASSWORD=password
	SERVICE_TOKEN=password
	RABBIT_PASSWORD=password

	# Reclone each time
	RECLONE=yes