Discover gists

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

	#!/usr/bin/env python3
	"""Vehicles Routing Problem (VRP)."""

	from functools import partial
	from ortools.constraint_solver import routing_enums_pb2
	from ortools.constraint_solver import pywrapcp

	# Vehicle 1: slow (speed: 20)
	# Vehicle 2: slow (speed: 20)
	# Vehicle 3: average (speed: 18)

	#!/usr/bin/env python3
	from ortools.constraint_solver import pywrapcp
	from ortools.constraint_solver import routing_enums_pb2


	def create_data_model(input_data=None):
	"""Stores the data for the problem."""
	data = {}
	data['distance_matrix'] = [
	[

	You are Manus, an AI agent created by the Manus team.

	You excel at the following tasks:
	1. Information gathering, fact-checking, and documentation
	2. Data processing, analysis, and visualization
	3. Writing multi-chapter articles and in-depth research reports
	4. Creating websites, applications, and tools
	5. Using programming to solve various problems beyond development
	6. Various tasks that can be accomplished using computers and the internet

	i386 : iPhone Simulator
	x86_64 : iPhone Simulator
	arm64 : iPhone Simulator
	iPhone1,1 : iPhone
	iPhone1,2 : iPhone 3G
	iPhone2,1 : iPhone 3GS
	iPhone3,1 : iPhone 4
	iPhone3,2 : iPhone 4 GSM Rev A
	iPhone3,3 : iPhone 4 CDMA
	iPhone4,1 : iPhone 4S

	#!/bin/bash

	# Generate the frames
	for i in {0..1800}
	do
	echo "Generating frame $i"
	convert -background black -fill white -size 480x320 -pointsize 48 -gravity center label:${i} frame${i}.png
	done

	# Combine frames into H.264 MP4 video. (29.97fps & 30fps)

	Add the following in .zshrc:

	...
	plugins=(osx git zsh-autosuggestions zsh-syntax-highlighting zsh-nvm docker kubectl)
	...

	### Fix slowness of pastes with zsh-syntax-highlighting.zsh
	pasteinit() {
	OLD_SELF_INSERT=${${(s.:.)widgets[self-insert]}[2,3]}
	zle -N self-insert url-quote-magic # I wonder if you'd need `.url-quote-magic`?

	volatile int i = 1;
	while(i);
	// then change i = 0 from debugger
	// mind = blown