Discover gists

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)

This document expands upon the official Arch Linux Wiki installation guide by covering some more steps:

	"""
	A micro event loop library implementation from scratch.

	This library provides a minimal but feature-complete asynchronous event loop
	implementation for educational purposes. It demonstrates the core concepts of
	asynchronous programming including:

	- Task scheduling and management
	- I/O multiplexing with non-blocking sockets
	- Timeouts and sleep functionality

	On OSX Yosemite and above, in a terminal window:

	1. Switch to the root user.

	$ sudo su -

	2. Create a Dummynet pipe that represents a slow, unreliable network:

	# dnctl pipe 1 config bw 10Kbit/s delay 300 plr 0.1 noerror

	import Combine
	import SwiftUI

	struct CountdownView: View {
	@State private var countdown: Int = 15 * 60
	@State private var displayedTime = "15:00"
	@State private var countdownTimer: AnyCancellable?

	@State private var isShowingLaurels = false
	@State private var isShowingExpiry = false

	// Types for the result object with discriminated union
	type Success<T> = {
	data: T;
	error: null;
	};

	type Failure<E> = {
	data: null;
	error: E;
	};

	#!/bin/bash
	#
	# scripts/test.sh
	#
	# * Generates `coverage/index.html`: HTML artifact for download,
	# * Generates `coverage/report.xml`: report of failed tests in Junit format, and
	# * Validates the minimum code coverage still applies.
	#
	# Depends on:
	# * github.com/jstemmer/go-junit-report

	#!/usr/bin/env python
	"""How to do regular expressions in sqlite3 (using python)."""
	from __future__ import division, absolute_import, print_function, unicode_literals

	import re
	import sys
	import time
	import datetime
	import sqlite3