Ravi K shreram

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)

NOTE: This is a question I found on StackOverflow which I’ve archived here, because the answer is so effing phenomenal.

If you are not into long explanations, see [Paolo Bergantino’s answer][2].

#Starting Python Web development in Mac OS X#

Objective: Getting started with Python Development Operating System: Mac OS X Python version installed: 3.5 (5th December 2015)

Add kiosk.js file with the content below to your www folder in config.

Like any other custom script, use ui-lovelace.yaml resources section to reference the kiosk.js file.

Make sure you add kiosk somewhere in your URL. You can use it in the id of your view or in the query string.

	#!/bin/bash

	# Author: Erik Kristensen
	# Email: [email protected]
	# License: MIT
	# Nagios Usage: check_nrpe!check_docker_container!_container_id_
	# Usage: ./check_docker_container.sh _container_id_
	#
	# Depending on your docker configuration, root might be required. If your nrpe user has rights
	# to talk to the docker daemon, then root is not required. This is why root privileges are not

	/* open up chrome dev tools (Menu > More tools > Developer tools)
	* go to network tab, refresh the page, wait for images to load (on some sites you may have to scroll down to the images for them to start loading)
	* right click/ctrl click on any entry in the network log, select Copy > Copy All as HAR
	* open up JS console and enter: var har = [paste]
	* (pasting could take a while if there's a lot of requests)
	* paste the following JS code into the console
	* copy the output, paste into a text file
	* open up a terminal in same directory as text file, then: wget -i [that file]
	*/

	# -- coding: utf-8 --

	#------------------------------------------------------------------------------
	#
	# Automated IMDB Top 250 Plex collection script by /u/SwiftPanda16
	#
	# * Use at your own risk! *
	# * I am not responsible for damages to your Plex server or libraries. *
	#
	#------------------------------------------------------------------------------

	#!/bin/bash
	#
	# Perform local backups of Gitter.im chat rooms.

	GITTER_ARCHIVE_URL="https://gitter.im/%s/archives/%s"

	usage() {
	echo "usage: $(basename $0) -f -r <chat-room> [-o <output-dir>] [-s <YYYY/MM/DD>] [-e <YYYY/MM/DD>]" 1>&2
	exit 1
	}

	midnight-remake:
	# Main colors
	primary-color: '#2980b9'
	accent-color: '#f1c40f'
	dark-primary-color: 'var(--accent-color)'
	light-primary-color: 'var(--accent-color)'

	# Text colors
	primary-text-color: '#ffffff'
	text-primary-color: 'var(--primary-text-color)'

	#!/bin/bash
	# Copyright 2018, Anthony Wharton
	# Single script that can be called that generates certificates using the
	# certbotFreeDNSAuthHook.sh and certbotFreeDNSCleanupHook.sh scripts.

	# This should be used as guidence of my usage, and changed to your needs. Note
	# the generic `/path/to/...` and `DOMAIN.COM`, which should be replaced with
	# your script location and domain respectively. In addition, for this to be
	# used on a live system, one must remove the `--dry-run` flag.