Joel Taylor joelataylor

Multiple MySQL Versions for Development

Options included below:

Using Docker docker-compose
Using Homebrew brew

Using Docker (recommended)

This gist was originally created for Homebrew before the rise of Docker, yet it may be best to avoid installing mysql via brew any longer. Instead consider adding a barebones docker-compose.yml for each project and run docker-compose up to start each project's mysql service.

Debug your PHP in Docker with Intellij/PHPStorm and Xdebug

For your local dev, create a Dockerfile that is based on your production image and simply install xdebug into it. Exemple:

FROM php:5

RUN yes | pecl install xdebug \
&amp;&amp; echo "zend_extension=$(find /usr/local/lib/php/extensions/ -name xdebug.so)" &gt; /usr/local/etc/php/conf.d/xdebug.ini \

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

Haversine Formula

used to calculate the great circle distance between two points on the earth (specified in decimal degrees)

Earth's Radius

Miles: 3956
Kilometers: 6371

	# -----------------------------------------------------------------
	# .gitignore for WordPress @salcode
	# ver 20180808
	#
	# From the root of your project run
	# curl -O https://gist.githubusercontent.com/salcode/b515f520d3f8207ecd04/raw/.gitignore
	# to download this file
	#
	# By default all files are ignored. You'll need to whitelist
	# any mu-plugins, plugins, or themes you want to include in the repo.

	server {
	include /home/webmaster/www/codeable.io.conf;

	server_name codeable.io;
	listen 443 ssl spdy default_server;

	root /home/webmaster/www/codeable.io;
	index index.php index.html;

	error_log /var/log/nginx/codeable.io.error.log warn;