Buu Pham phamquocbuu

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.

Multiple SSH Keys settings for different github account

create different public key

create different ssh key according the article Mac Set-Up Git

$ ssh-keygen -t rsa -C "your_email@youremail.com"

IP Tables (iptables) Cheat Sheet

IPTables is the Firewall service that is available in a lot of different Linux Distributions. While modifiying it might seem daunting at first, this Cheat Sheet should be able to show you just how easy it is to use and how quickly you can be on your way mucking around with your firewall.

Resources

The following list is a great set of documentation for iptables. I used them to compile this documentation.

How-To Geek: The Beginner’s Guide to iptables, the Linux Firewall: https://www.howtogeek.com/177621/the-beginners-guide-to-iptables-the-linux-firewall/
IPTables Essentials: Common Firewall Rules and COmmands https://www.digitalocean.com/community/tutorials/iptables-essentials-common-firewall-rules-and-commands

	server {
	listen 443;
	server_name example.com;

	error_log /var/log/nginx/example_com_error.log warn;

	ssl on;
	ssl_certificate /etc/nginx/ssl/your.crt; #certificate chains
	ssl_certificate_key /etc/nginx/ssl/your.key; #private key

	/**
	* Mass (bulk) insert or update on duplicate for Laravel 4/5
	*
	* insertOrUpdate([
	* ['id'=>1,'value'=>10],
	* ['id'=>2,'value'=>60]
	* ]);
	*
	*
	* @param array $rows

	<?php

	// Converts a number into a short version, eg: 1000 -> 1k
	// Based on: http://stackoverflow.com/a/4371114
	function number_format_short( $n, $precision = 1 ) {
	if ($n < 900) {
	// 0 - 900
	$n_format = number_format($n, $precision);
	$suffix = '';
	} else if ($n < 900000) {

	// AUTO GENERATE SIMPLE UNIQUE ID'S FOR NON-EMPTY ROWS
	//
	// Author: Carlos Perez, clayperez@gmail.com
	//
	// Purpose: This Google Sheets script fires when any cell is edited and
	// inserts a random (reasonably unique) UID of ID_LENGTH length
	// into the specified ID_COLUMN. For instance if the first column in the
	// sheet specified by SHEETNAME is the column where you would like the
	// UID injected, then ID_COLUMN should be 1.
	//

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	tell application "Google Chrome"
	reload active tab of window 1
	end tell