Ryan Scherler ryanscherler

How to use MAMP with the mysql2 gem and Ruby 1.9.3-p194 via rbenv

Let's say you're a web developer who happens to work with both MAMP and Ruby when building different types of websites. Let's say you also like to keep your MySQL stuff in one place and don't like having to juggle both a local MySQL install as well as a MAMP MySQL install. Well, you can indeed connect your ruby apps to MAMP's MySQL. Here's a tutorial on how to do it.

Important! Before you do anything, download and install MAMP. MAMP Pro will work as well. At the time of this writing, MAMP 2.1.1 is the latest.

First, install Ruby via rbenv

Install homebrew
Install rbenv: brew install rbenv, follow any instructions homebrew gives you after the installation is complete.

	# This is a template .gitignore file for git-managed WordPress projects.
	#
	# Fact: you don't want WordPress core files, or your server-specific
	# configuration files etc., in your project's repository. You just don't.
	#
	# Solution: stick this file up your repository root (which it assumes is
	# also the WordPress root directory) and add exceptions for any plugins,
	# themes, and other directories that should be under version control.
	#
	# See the comments below for more info on how to add exceptions for your

	#!/usr/bin/env ruby

	# Pow Port
	#
	# Quickly and easily change the port that Pow is running on. This allows
	# you too run Apache and Pow side-by-side (on different ports of course).
	#
	# WARNING: This will OVERWRITE your ~/.powconfig file. If you have custom
	# configurations in there, please back it up first.
	#

	<!doctype html>
	<html>
	<body>
	<header role="banner">
	<a href="/" rel="home">My company</a>
	<nav role="navigation">
	<a href="/about">About</a>
	<a href="/contact">Contact</a>
	</nav>
	</header>

	Perl and PHP Regular Expressions

	PHP regexes are based on the PCRE (Perl-Compatible Regular Expressions), so any regexp that works for one should be compatible with the other or any other language that makes use of the PCRE format. Here are some commonly needed regular expressions for both PHP and Perl. Each regex will be in string format and will include delimiters.
	All Major Credit Cards

	This regular expression will validate all major credit cards: American Express (Amex), Discover, Mastercard, and Visa.

	//All major credit cards regex
	'/^(?:4[0-9]{12}(?:[0-9]{3})?\|5[1-5][0-9]{14}\|6011[0-9]{12}\|622((12[6-9]\|1[3-9][0-9])\|([2-8][0-9][0-9])\|(9(([0-1][0-9])\|(2[0-5]))))[0-9]{10}\|64[4-9][0-9]{13}\|65[0-9]{14}\|3(?:0[0-5]\|[68][0-9])[0-9]{11}\|3[47][0-9]{13})*$/'

	<?php

	require("postmark.php");

	$postmark = new Postmark("your-api-key","from-email","optional-reply-to-address");

	$result = $postmark->to("reciver@example.com")
	->subject("Email Subject")
	->plain_message("This is a plain text message.")
	->attachment('File.pdf', base64_encode(file_get_contents('sample.pdf')), 'application/pdf')

	<?php

	/**
	* Fixes sticky post ordering in WordPress anywhere the order is not explicitly defined.
	*
	* Updates a post's menu order whenever the sticky posts option is updated
	*
	* Props to Simon Fransson of http://dessibelle.se/ for a bugfix where 'unstickied' posts were not updated
	*
	* @param Array $stickies An array of post IDs

	// Placeholder @mixin for Sass
	//
	// A mixin to style placeholders in HTML5 form elements.
	// Includes also a .placeholder class to be used with a polyfill e.g.
	// https://github.com/mathiasbynens/jquery-placeholder
	// Requires Sass 3.2.
	//
	// Example usage (.scss):
	//
	// input {

	<?php
	use Symfony\Component\Security\Core\Encoder\MessageDigestPasswordEncoder;
	$encoder = new MessageDigestPasswordEncoder();
	echo $encoder->encodePassword('foo', '');
	// 5FZ2Z8QIkA7UTZ4BYkoC+GsReLf569mSKDsfods6LYQ8t+a8EW9oaircfMpmaLbPBh4FOBiiFyLfuZmTSUwzZg==

	<?php
	function rh_get_widget_data_for_all_sidebars() {
	global $wp_registered_sidebars;

	$output = array();
	foreach ( $wp_registered_sidebars as $sidebar ) {
	if ( empty( $sidebar['name'] ) ) {
	continue;
	}
	$sidebar_name = $sidebar['name'];