Claire Hernandez clrh

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

Typing vagrant from the command line will display a list of all available commands.

Be sure that you are in the same directory as the Vagrantfile when running these commands!

Creating a VM

vagrant init -- Initialize Vagrant with a Vagrantfile and ./.vagrant directory, using no specified base image. Before you can do vagrant up, you'll need to specify a base image in the Vagrantfile.
vagrant init <boxpath> -- Initialize Vagrant with a specific box. To find a box, go to the public Vagrant box catalog. When you find one you like, just replace it's name with boxpath. For example, vagrant init ubuntu/trusty64.

Starting a VM

vagrant up -- starts vagrant environment (also provisions only on the FIRST vagrant up)

Description

This simple script will take a picture of a whiteboard and use parts of the ImageMagick library with sane defaults to clean it up tremendously.

The script is here:

#!/bin/bash
convert "$1" -morphology Convolve DoG:15,100,0 -negate -normalize -blur 0x1 -channel RBG -level 60%,91%,0.1 "$2"

Results

The Best of the Best Practices (BOBP) Guide for Python

A "Best of the Best Practices" (BOBP) guide to developing in Python.

In General

Values

"Build tools for others that you want to be built for you." - Kenneth Reitz
"Simplicity is alway better than functionality." - Pieter Hintjens

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

	// ==UserScript==
	// @name Sophy with Pfaf
	// @namespace http://tampermonkey.net/
	// @version 0.4
	// @description Display Sophy phytotypes with Pfaf data
	// @author Clrh
	// @match https://sophy.tela-botanica.org/*
	// @grant GM_xmlhttpRequest
	// @grant GM_addStyle
	// ==/UserScript==

	require 'httparty'
	require 'json'
	require 'time'


	SCHEDULER.every '5m', :first_in => 0 do \|job\|
	projects = ["REPOSITORY NAMES"]

	prs = []
	projects.each do \|project\|

	#!/bin/sh

	BACKUP_DATE=`date +%Y-%m-%d_%H-%M-%S`
	BACKUP_DIR="~/PEAK/BACKUPS/$BACKUP_DATE"

	mkdir -p "$BACKUP_DIR"
	cd "$BACKUP_DIR"

	sudo adb pull /data/local/storage/persistent/

	/*
	* script to export data in all sheets in the current spreadsheet as individual csv files
	* files will be named according to the name of the sheet
	* author: Michael Derazon
	*/

	function onOpen() {
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}];
	ss.addMenu("csv", csvMenuEntries);