Dan dantheman213

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

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

PostgreSQL & PL/pgSQL Stored Functions Cheatsheet

Boiler-plate stored function

CREATE OR REPLACE FUNCTION public.sp_user_ins_status(status smallint)
  RETURNS integer
  LANGUAGE plpgsql
AS $function$

youtube-dl cheat sheet

Docs and Binary for youtube-dl are located here:

https://github.com/rg3/youtube-dl/

Install dependencies

apt-get install libav-tools ffmpeg # Linux (either one of either should do) brew install ffmpeg # OSX choco install ffmpeg # Windows

	import android.util.Log;

	import java.security.SecureRandom;
	import java.security.cert.CertificateException;
	import java.security.cert.X509Certificate;

	import javax.net.ssl.HostnameVerifier;
	import javax.net.ssl.HttpsURLConnection;
	import javax.net.ssl.SSLContext;
	import javax.net.ssl.SSLSession;

	using System;
	using System.Net;
	using System.Net.Sockets;
	using System.Text;

	namespace UDP
	{
	public class UDPSocket
	{
	private Socket _socket = new Socket(AddressFamily.InterNetwork, SocketType.Dgram, ProtocolType.Udp);

	#!/bin/sh

	# AUTHOR
	# DANIEL E. GILLESPIE (2016)
	# https://github.com/dantheman213

	# DESCRIPTION
	# Export your app's table schemas and stored functions from a PostgreSQL
	# database into individual *.sql files for easy management and source control.

	#!/bin/sh

	# AUTHOR
	# DANIEL E. GILLESPIE (2016)
	# https://github.com/dantheman213

	# DESCRIPTION
	# Import all *.sql files in a folder recuresively into your PostgreSQL database

	# Batch export all table schemas and stored functions with this script located here:

	'use strict';

	const later = require('later');
	const logger = require('./logger')('guard');
	const pm2 = require('pm2');

	const schedule = later.parse.recur().every(10).second();

	// set local timezone
	later.date.localTime();