Moe Amaya moeamaya

Install MySQL on macOS Sierra

This procedure explains how to install MySQL using Homebrew on macOS Sierra 10.12

Install Homebrew

Installing Homebrew is effortless, open Terminal and enter :
$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.

Install MySQL

At this time of writing, Homebrew has MySQL version 5.7.15 as default formulae in its main repository :

Super basic bash guide →

This guide meant to help absolute beginners use the command line on Mac and Linux computers. For windows, you'll need to install the git command line tool or cygwin in order to use these commands. For Mac, you can open the command line with the Terminal application, inside Applications > Utilities.

This guide is supposed to be brief enough to be learned in a few minutes. For more in-depth guidance on using the command line, try this tutorial or this tutorial. Please feel free to leave comments suggesting changes,

	# connect to production
	Stipe.api_key = production_key
	plans = Stripe::Plan.all

	# connect to sandbox
	Stripe.api_key = test_key
	plans.each do \|plan\|
	Stripe::Plan.create(plan.attributes)
	end

	-- original source: https://medium.com/adhawk-engineering/using-postgresql-to-generate-slugs-5ec9dd759e88

	-- https://www.postgresql.org/docs/9.6/unaccent.html
	CREATE EXTENSION IF NOT EXISTS unaccent;

	-- create the function in the public schema
	CREATE OR REPLACE FUNCTION public.slugify(
	v TEXT
	) RETURNS TEXT
	LANGUAGE plpgsql

	require 'sidekiq/api'

	# 1. Clear retry set

	Sidekiq::RetrySet.new.clear

	# 2. Clear scheduled jobs

	Sidekiq::ScheduledSet.new.clear

	<!doctype html>
	<html>
	<title>Flatten.js, General SVG Flattener</title>

	<head>
	<script>
	/*
	Random path and shape generator, flattener test base: http://jsfiddle.net/xqq5w/embedded/result/
	Basic usage example: http://jsfiddle.net/Nv78L/3/embedded/result/

	daemon off;
	# Heroku dynos have at least 4 cores.
	worker_processes <%= ENV['NGINX_WORKERS'] \|\| 4 %>;

	events {
	use epoll;
	accept_mutex on;
	worker_connections 1024;
	}

	// Add on element with overflow
	-webkit-mask-image: -webkit-radial-gradient(white, black);

	/* bling.js */

	window.$ = document.querySelectorAll.bind(document);

	Node.prototype.on = window.on = function (name, fn) {
	this.addEventListener(name, fn);
	};

	NodeList.prototype.__proto__ = Array.prototype;

	<% pages = sitemap.resources.find_all{\|p\| p.source_file.match(/\.html/) } %>
	<?xml version="1.0" encoding="UTF-8"?>
	<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
	<% pages.each do \|p\| %>
	<url>
	<loc>http://youdomain.com/<%=p.destination_path.gsub('/index.html','')%></loc>
	<priority>0.7</priority>
	</url>
	<% end %>
	</urlset>