scottsd

CREATE TABLE City (
  ID BIGSERIAL,
  Name varchar(35) NOT NULL DEFAULT '',
  CountryCode varchar(3) NOT NULL DEFAULT '',
  District varchar(20) NOT NULL DEFAULT '',
  Population int NOT NULL DEFAULT '0'

)
;

sandfox

This example assumes your running a recent Ubuntu with upstart installed and you have install n from npm.

To see an example use of this ina a wider context, look at this gist for deploying node.js + nginx

Adapt as required.

1. Put the node.conf in /etc/init/
2. Create a folder for individual site configs to live in /etc/node
3. Put the node-test.conf inside /etc/node
4. Create the folder for the logs /var/logs/node

jhgaylor

class A(models.Model):
    things = models.ManyToManyField("B", through=ThroughModel)

class B(models.Model):
    text = models.TextField()

class ThroughModel(models.Model):
    a = models.ForeignKey(A)
    b = models.ForeignKey(B)
    extra = models.BooleanField()

irazasyed

Change default Mac OS X PHP to MAMP's PHP Installation and Install Composer Package Management

---

Instructions to Change PHP Installation

---

First, Lets find out what version of PHP we're running (To find out if it's the default version).

To do that, Within the terminal, Fire this command:

which php

asugai

$ cd ~
$ sudo curl -sS https://getcomposer.org/installer | sudo php
$ sudo mv composer.phar /usr/local/bin/composer
$ sudo ln -s /usr/local/bin/composer /usr/bin/composer

then you can run 
$ sudo composer install

irazasyed

Homebrew Permissions Denied Issues Solution

sudo chown -R $(whoami) $(brew --prefix)/*

hofmannsven

MySQL

Getting started

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

Related tutorials

• MySQL-CLI
• Analyzing Business Metrics

ARolek

I needed a newer version of ImageMagick than is available on the yum packages on Amazon Linux. I tried using the remi repo but it failed with dependency errors. Here is what I did to install ImageMagick with support for PNG, JPG, and TIFF.

download the most recent package

wget http://www.imagemagick.org/download/ImageMagick.tar.gz

uncomress the package

joecliff

var CryptoJS = require("crypto-js");//replace thie with script tag in browser env

//encrypt
var rawStr = "hello world!";
var wordArray = CryptoJS.enc.Utf8.parse(rawStr);
var base64 = CryptoJS.enc.Base64.stringify(wordArray);
console.log('encrypted:', base64);

//decrypt
var parsedWordArray = CryptoJS.enc.Base64.parse(base64);

mauris

<?php

function runCommand ()
{
    $command = 'php artisan queue:listen > /dev/null & echo $!';
    $number = exec($command);
    file_put_contents(__DIR__ . '/queue.pid', $number);
}

if (file_exists(__DIR__ . '/queue.pid')) {