Honbra HonbraDev

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)

	echo off
	echo ; set +v # > NUL
	echo ; function GOTO { true; } # > NUL

	GOTO WIN
	# bash part, replace it to suit your needs
	exit 0

	:WIN
	REM win part, replace it to suit your needs

	/**
	* Fancy ID generator that creates 20-character string identifiers with the following properties:
	*
	* 1. They're based on timestamp so that they sort after any existing ids.
	* 2. They contain 72-bits of random data after the timestamp so that IDs won't collide with other clients' IDs.
	* 3. They sort lexicographically (so the timestamp is converted to characters that will sort properly).
	* 4. They're monotonically increasing. Even if you generate more than one in the same timestamp, the
	* latter ones will sort after the former ones. We do this by using the previous random bits
	* but "incrementing" them by 1 (only in the case of a timestamp collision).
	*/

-#Delete local tags.
-git tag -l | xargs git tag -d
-#Fetch remote tags.
-git fetch
-#Delete remote tags.
-git tag -l | xargs -n 1 git push --delete origin
-#Delete local tasg.
-git tag -l | xargs git tag -d

	#!/bin/bash
	#youtube-dl --external-downloader axel --external-downloader-args "-n 15 -a -k" "$@"
	youtube-dl --external-downloader aria2c --external-downloader-args "-c -j 5 -x 10 --summary-interval=0" "$@"