ericmdev

MySQL

Getting started:

• http://www.sqlteaching.com/
• https://www.codecademy.com/courses/learn-sql

Related tutorial: http://cd64.de/mysql-cli

SQL joins infografic: http://cd64.de/sql-joins

ericmdev

# to install the latest stable version:
brew install scala --with-docs
 
# to install scala-2.10:
brew install https://raw.github.com/gist/4340744/scala.rb --with-docs
 
# to switch versions (from https://github.com/mxcl/homebrew/wiki/External-Commands):
brew switch scala 2.9.2
brew switch scala 2.10.0
 

ericmdev

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

ericmdev

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Set the Server Timezone to CST
echo "America/Chicago" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

# Enable Ubuntu Firewall and allow SSH & MySQL Ports
ufw enable
ufw allow 22

ericmdev

#!/bin/bash

aptitude -y install expect

// Not required in actual script
MYSQL_ROOT_PASSWORD=abcd1234

SECURE_MYSQL=$(expect -c "

set timeout 10

ericmdev

#!/bin/sh
BOOT2DOCKER_CERTS_DIR=/var/lib/boot2docker/certs
CERTS_DIR=/etc/ssl/certs
CAFILE=${CERTS_DIR}/ca-certificates.crt

for cert in $(/bin/ls -1 ${BOOT2DOCKER_CERTS_DIR}); do
    SRC_CERT_FILE=${BOOT2DOCKER_CERTS_DIR}/${cert}
    CERT_FILE=${CERTS_DIR}/${cert}
    HASH_FILE=${CERTS_DIR}/$(/usr/local/bin/openssl x509 -noout -hash -in ${SRC_CERT_FILE} 2>/dev/null)

ericmdev

Sublime Text 2 – Useful Shortcuts (Mac OS X)

General

⌘T	go to file
⌘⌃P	go to project
⌘R	go to methods
⌃G	go to line
⌘KB	toggle side bar
⌘⇧P	command prompt

ericmdev

#!/bin/sh                                                                                                                                                                            

remove_dangling() {
   echo "Removing dangling images ..."
   docker rmi $(docker images -f dangling=true -q)
}

remove_stopped_containers() {
    echo "Removing stopped containers ..."
    docker rm $(docker ps -qa)

ericmdev

Linux fun-o-matic

How to have some fun using the terminal.

1. Install cowsay [0] via : sudo apt-get install cowsay
2. Install fortune [1] via : sudo apt-get install fortune
3. Make sure you have Ruby installed via : ruby -v
4. Install the lolcat [2] via : gem gem install lolcat
5. Profit!

ericmdev

#!/bin/bash

echo "All certificates in ca-certificates.crt, listed by subject:"
awk -v cmd='openssl x509 -noout -subject' '/BEGIN/{close(cmd)};{print | cmd}' < /etc/ssl/certs/ca-certificates.crt

echo "All certificates in ca-certificates.crt, listed by subject, check for presence of VeriSign's 'Class 3 Public Primary - G5':"
awk -v cmd='openssl x509 -noout -subject' '/BEGIN/{close(cmd)};{print | cmd}' < /etc/ssl/certs/ca-certificates.crt | grep "G5"