Kushal Billaiya connectkushal

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

Using Git to Manage a Live Web Site

Overview

As a freelancer, I build a lot of web sites. That's a lot of code changes to track. Thankfully, a Git-enabled workflow with proper branching makes short work of project tracking. I can easily see development features in branches as well as a snapshot of the sites' production code. A nice addition to that workflow is that ability to use Git to push updates to any of the various sites I work on while committing changes.

Reference

WARNING

May contain out of date information. Check the comments below!

The list of actions listed below was taken mostly from Book Of Zeus with minor modifications and did the job well for Ubuntu version, which was available at that moment (May 2016). This gist was created for internal use and was never meant to be discovered by the web, although Google managed to find and index this page, which was a great surprise for me. Please check the original source for the updated information (links are provided in most of the sections), and read the comments below: they provide more details about the usage experience.

System Updates

http://bookofzeus.com/harden-ubuntu/initial-setup/system-updates/

Keeping the system updated is vital before starting anything on your system. This will prevent people to use known vulnerabilities to enter in your system.

	#!/bin/bash
	#
	# What is that
	# ============
	#
	# This script will help you setting up your digital ocean
	# infrastructure with Ansible v2.0+ and DO API v2
	#
	# Usually, when working with DO, one is supposed to use digital_ocean.py
	# inventory file, and spin up instances in a playbook.

	CREATE TABLE books (
	isbn char(14) NOT NULL,
	title varchar(255),
	author varchar(255),
	price decimal(5,2)
	);

	INSERT INTO books (isbn, title, author, price) VALUES
	('978-1503261969', 'Emma', 'Jayne Austen', 9.44),
	('978-1514274873', 'Journal of a Soldier', NULL, 5.49),

	.
	├── books
	│ ├── handlers.go
	│ └── models.go
	├── config
	│ └── db.go
	└── main.go

	{
	"repositories": [
	{
	"type": "path",
	"url": "../relative/project/path"
	}
	],
	"require": {
	"${project}": "dev-${branch}"
	}

	.sidebar_newsletter_sign_up,
	.sidebar_subscribe,
	.sign-up-form-single,
	.signup-form--header,
	.signup-with-checkboxes,
	.skinny-sign-up,
	.slidedown-newsletter,
	.small-newsletter,
	.social-link-mail,
	.social_newsletter_box,