Joemar Tagpuno joemar-tagpuno

Useful emoji for git commit messages

If you add emoji to your commit messages for a GitHub repo, they become less boring, and you can convey the kind of change you're adding. See the full set of GitHub supported emoji here (also useful for easy copy&paste via a simple click).

The following is a possible scheme to use:

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Here is a high level overview for what you need to do to get most of an Android environment setup and maintained.

Prerequisites (for Homebrew at a minimum, lots of other tools need these too):

XCode is installed (via the App Store)
XCode command line tools are installed (xcode-select --install will prompt up a dialog)
Java

Install Homebrew:

ruby -e "$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)"

How-to setup a simple git push deployment

These are my notes basically. At first i created this gist just as a reminder for myself. But feel free to use this for your project as a starting point. If you have questions you can find me on twitter @thomasf https://twitter.com/thomasf This is how i used it on a Debian Wheezy testing (https://www.debian.org/releases/testing/)

Discuss, ask questions, etc. here https://news.ycombinator.com/item?id=7445545

On the server (example.com)

Note: Some of these shortcuts have been remapped for my own convenience (Preferences->Keymap). These are Mac shortcuts, just use the Windows/Linux equivalent of the Cmd/Option/Ctrl/Del keys.

####Search, Go to, Navigation ####

Cmd + P - Search file

Cmd + Shift + O - Search everywhere

(I swapped the above two recently because I use Cmd + P to search for files most of the time).

	#!/bin/bash -e
	# IMPORTANT. My phpstom installation exists on /opt/phpstorm.
	# Early Access program: https://confluence.jetbrains.com/display/PhpStorm/PhpStorm+Early+Access+Program
	# For stable releases try: https://data.services.jetbrains.com/products/download?code=PS&platform=linux

	if [ "$(whoami)" != "root" ]
	then
	echo "Sorry, you are not root."
	exit 1
	fi

	<?php
	$db_con = mysqli_connect("localhost", "username", "password", "database");
	$result = $db_con->query('SELECT * FROM some_table');
	if (!$result) die('Couldn\'t fetch records');
	$num_fields = mysqli_num_fields($result);
	$headers = array();
	while ($fieldinfo = mysqli_fetch_field($result)) {
	$headers[] = $fieldinfo->name;
	}
	$fp = fopen('php://output', 'w');

	// Get the template HTML and remove it from the doument.
	var previewNode = document.querySelector("#template");
	previewNode.id = "";
	var previewTemplate = previewNode.parentNode.innerHTML;
	previewNode.parentNode.removeChild(previewNode);

	var myDropzone = new Dropzone(document.body, { // Make the whole body a dropzone
	url: "/target-url", // Set the url
	thumbnailWidth: 80,
	thumbnailHeight: 80,

	<!-- HTML heavily inspired by http://blueimp.github.io/jQuery-File-Upload/ -->
	<div class="table table-striped" class="files" id="previews">

	<div id="template" class="file-row">
	<!-- This is used as the file preview template -->
	<div>
	<span class="preview"><img data-dz-thumbnail /></span>
	</div>
	<div>
	<p class="name" data-dz-name></p>

	<?php

	class SecureSessionHandler extends SessionHandler {

	protected $key, $name, $cookie;

	public function __construct($key, $name = 'MY_SESSION', $cookie = [])
	{
	$this->key = $key;
	$this->name = $name;