Enrique Benitez bntzio

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

Fixing our local environment with Browsersync

Whenever we change our templates we still have to use our build script and this can get annoying. Thankfully with webpack-dev-server and BrowserSync we can fix this:

npm i -D browser-sync browser-sync-webpack-plugin webpack-dev-server

BrowserSync will act like a proxy, waiting for webpack to do its thing and then reloading the browser for us.

	[{
	"Note": "The first two digits (ranging from 10–43) correspond to the province, while the last two digits correspond either to the city/delivery zone (range 01–50) or to the district/delivery zone (range 51–99). Afghanistan Postal code lookup",
	"Country": "Afghanistan",
	"ISO": "AF",
	"Format": "NNNN",
	"Regex": "^\\d{4}$"
	}, {
	"Note": "With Finland, first two numbers are 22.",
	"Country": "Åland Islands",
	"ISO": "AX",

	import * as anchor from "@project-serum/anchor";
	import { findAssociatedTokenAddress, sendAndConfirm } from "../utils/helpers";
	import { isBrowser, tokenMint } from "../utils/common";
	import { ShadowDriveResponse } from "../types";

	/**
	*
	* @param {anchor.web3.PublicKey} key - PublicKey of a Storage Account
	* @returns {ShadowDriveResponse} - Confirmed transaction ID
	*/

	const readline = require('readline')
	const blank = '\n'.repeat(process.stdout.rows)
	console.log(blank)
	readline.cursorTo(process.stdout, 0, 0)
	readline.clearScreenDown(process.stdout)


	/*
	##Device = Desktops
	##Screen = 1281px to higher resolution desktops
	*/

	@media (min-width: 1281px) {

	//CSS

	const delay = ms => new Promise(resolve => setTimeout(resolve, ms));

	async function something() {
	console.log("this might take some time....");
	await delay(5000);
	console.log("done!")
	}

	something();

	passwd bntz
	osascript -e 'tell application "Finder" to sleep'

	// 🔥 Node 7.6 has async/await! Here is a quick run down on how async/await works

	const axios = require('axios'); // promised based requests - like fetch()

	function getCoffee() {
	return new Promise(resolve => {
	setTimeout(() => resolve('☕'), 2000); // it takes 2 seconds to make coffee
	});
	}