stilliard

# 2gb example
# ref: https://www.digitalocean.com/community/tutorials/how-to-configure-virtual-memory-swap-file-on-a-vps

cd /var
touch swap.img
chmod 600 swap.img
dd if=/dev/zero of=/var/swap.img bs=2048k count=1000
mkswap /var/swap.img
swapon /var/swap.img
echo "/var/swap.img    none    swap    sw    0    0" >> /etc/fstab

stilliard

# ref: https://github.com/prasmussen/gdrive

# prerequisite:
#  In google drive, setup your folder for storing the backups
#  Then grab the code from the url e.g. https://drive.google.com/drive/folders/xxxxx where xxxxx is the code
#  This code will be used later in the cron command, keep it secret, keep it safe

# install gdrive sync for backups
wget https://drive.google.com/uc?id=0B3X9GlR6EmbnQ0FtZmJJUXEyRTA -O /usr/local/bin/gdrive
chmod 755 /usr/local/bin/gdrive

stilliard

// Highlight text
// then open console and run:
document.execCommand('strikeThrough')

stilliard

{
    // The tab key will cycle through the settings when first created
    // Visit http://wbond.net/sublime_packages/sftp/settings for help
     
    // sftp, ftp or ftps
    "type": "ftps",
 
    "save_before_upload": true,
    "upload_on_save": true,
    "sync_down_on_open": true,

stilliard

SELECT table_name, index_name, GROUP_CONCAT(DISTINCT column_name), index_type
FROM information_schema.statistics
WHERE table_name = 'categories'
AND non_unique = 1
GROUP BY table_name, index_name, index_type

stilliard

SELECT table_name, index_name, GROUP_CONCAT(column_name)
FROM information_schema.statistics
WHERE table_schema = 'my_db'
AND non_unique = 1
GROUP BY table_name, index_name ;

stilliard

git config alias.migrate-to '!f() { make checkout BRANCH=$1; }; f'

stilliard

# Delete old docker containers
sudo docker rm `sudo docker ps --no-trunc -a -q`

# Delete old docker images
sudo docker rmi $(sudo docker images -a | grep -P '([A-z0-9_\-<>\/]+)\s+([A-z0-9_\-<>\/]+)\s+([A-z0-9_\-<>\/]+).*$' | awk '{print $3}')

stilliard

<VirtualHost *:8080>
    ServerName PROJECT_NAME.dev
    ServerAlias www.PROJECT_NAME.dev
    DocumentRoot PROJECT_DIR
    <Directory "PROJECT_DIR">
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted
    </Directory>
</VirtualHost>

stilliard

<?php 

/**
 * Dump the given value to stdout
 *
 * @param  mixed  $value
 * @return void
 */
function dout($value)
{