Gage Peterson justgage

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

The Ultimate Git Alias Setup

If you use git on the command-line, you'll eventually find yourself wanting aliases for your most commonly-used commands. It's incredibly useful to be able to explore your repos with only a few keystrokes that eventually get hardcoded into muscle memory.

Some people don't add aliases because they don't want to have to adjust to not having them on a remote server. Personally, I find that having aliases doesn't mean I that forget the underlying commands, and aliases provide such a massive improvement to my workflow that it would be crazy not to have them.

The simplest way to add an alias for a specific git command is to use a standard bash alias.

# .bashrc

The introduction to Reactive Programming you've been missing

(by @andrestaltz)

This tutorial as a series of videos

If you prefer to watch video tutorials with live-coding, then check out this series I recorded with the same contents as in this article: Egghead.io - Introduction to Reactive Programming.

	function toSentence(array) {
	var wordsConnector = ", ",
	twoWordsConnector = " and ",
	lastWordConnector = ", and ",
	sentence;

	switch(array.length) {
	case 0:
	sentence = "";
	break;

	#!/usr/bin/env node

	var fs = require('fs');
	var exec = require('child_process').exec;


	/*
	* lesswatch usage:
	*
	* `lesswatch` to watch the current directory

	(* ocamlfind ocamlopt -o exmpl -package curl -linkpkg exmpl.ml *)
	open Printf

	let _ = Curl.global_init Curl.CURLINIT_GLOBALALL

	(*
	*************************************************************************
	** Aux. functions
	*************************************************************************
	*)

	(ns test.cometd-client
	(:import (org.cometd.bayeux.client ClientSessionChannel$MessageListener)
	(org.cometd.client BayeuxClient BayeuxClient$State)
	(org.cometd.client.transport ClientTransport LongPollingTransport)
	(org.eclipse.jetty.client HttpClient)))

	(def channel-name "/my-channel")

	(def client-url "http://localhost:8080/cometd")

	/**
	* IE 5.5+, Firefox, Opera, Chrome, Safari XHR object
	*
	* @param string url
	* @param object callback
	* @param mixed data
	* @param null x
	*/
	function ajax(url, callback, data, x) {
	try {

	var source = require('vinyl-source-stream');
	var gulp = require('gulp');
	var gutil = require('gulp-util');
	var browserify = require('browserify');
	var reactify = require('reactify');
	var watchify = require('watchify');
	var notify = require("gulp-notify");

	var scriptsDir = './scripts';
	var buildDir = './build';

	<html>
	<head>
	<style type="text/css">
	.slider{
	margin:50px auto;
	width:500px;
	height:300px;
	overflow:hidden;
	position:relative;
	border:5px solid #eaeaea;