Brad Krane bradkrane

Country	CountryCode	Currency	Code
New Zealand	NZ	New Zealand Dollars	NZD
Cook Islands	CK	New Zealand Dollars	NZD
Niue	NU	New Zealand Dollars	NZD
Pitcairn	PN	New Zealand Dollars	NZD
Tokelau	TK	New Zealand Dollars	NZD
Australian	AU	Australian Dollars	AUD
Christmas Island	CX	Australian Dollars	AUD
Cocos (Keeling) Islands	CC	Australian Dollars	AUD
Heard and Mc Donald Islands	HM	Australian Dollars	AUD

Setup psql 12.0 on Windows 10

No password localhost windows users
Usefull for on the command line: type <some_file>.psql | psql
Windows Binary 12.X as of writing https://www.postgresql.org/download/
Remember the postgress password for the step when opening pgAdmin later

Default install path: C:\Program Files\PostgreSQL\12\

Add pgsql path to command line

Batch Script and Git Setup for text diff of ODT files with LibreOffice

git Windows will diff docx files without any additional configuration but surprisingly, this is not the case for ODT files. This simple Window shell script and git attributes configuration allows for diffing ODT files with LibreOffice

Windows Shell Script

Copy the script below locally, I use %USERPROFILE%\scripts as the reference destination in the Configure Git section below, but you can choose whatever you want replacing the path with your own throughout the document.

Waring: this script assumes that the there is no .txt file that matches the filename less extension of the ODT file being diffed. This is a temporary work around for the --cat option of soffice.exe not working as advertized. Bug 129713

	# PostgreSQL Client Authentication Configuration File
	# ===================================================
	#
	# Refer to the "Client Authentication" section in the PostgreSQL
	# documentation for a complete description of this file. A short
	# synopsis follows.
	#
	# This file controls: which hosts are allowed to connect, how clients
	# are authenticated, which PostgreSQL user names they can use, which
	# databases they can access. Records take one of these forms:

	#Roll then connect to VM

	passwd # always change root
	apt update
	apt install aptitude
	aptitude # install security updates
	apt install fail2ban firehol unattended-upgrades apt-listchanges sudo
	apt install postgres ruby git emacs

	adduser brad

	regions = {
	AF: 'Africa',
	AS: 'Asia',
	CA: 'Central America',
	EU: 'European Union',
	NA: 'North America',
	OC: 'Oceania',
	OT: 'Other',
	SA: 'South America',
	AN: 'Antarctica',

	REM This is to fix teams issue: MS Teams keeps randomly crashing
	REM https://answers.microsoft.com/en-us/msoffice/forum/all/ms-teams-keeps-randomly-crashing/d4b3fd90-c77e-468a-82a7-8190db44f73f

	taskkill /F /IM teams.exe
	del /f /s /q %appdata%\Microsoft\teams\application cache\cache\*
	del /f /s /q %appdata%\Microsoft\teams\blob_storage\*
	del /f /s /q %appdata%\Microsoft\teams\databases\*
	del /f /s /q %appdata%\Microsoft\teams\GPUcache\*
	del /f /s /q %appdata%\Microsoft\teams\IndexedDB\*
	del /f /s /q "%appdata%\Microsoft\teams\Local Storage\*"

	<!DOCTYPE html>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title>Prevent additional mouse event</title>
	</head>
	<body>
	<div id="ele" style="width: 300px; height: 300px; background-color: #0FF;">
	This is the parent element.
	<div style="width: 200px; height: 200px; background-color: #FFF;">

	#hostname:port:database:username:password
	localhost:5432:postgres:postgres:01234567989

	javascript:(() => {
	const pad = (x) => { if(x < 10){ return x = '0' + x } return x };
	let now = new Date();
	let y = now.getFullYear();
	let mo = pad(now.getMonth() +1);
	let d = pad(now.getDate());
	let h = pad(now.getUTCHours());
	now = `${y}${mo}${d}`;

	window.location.replace(`https://www.timeanddate.com/worldclock/converter.html?iso=${now}T${h}0000&p1=137&p2=55&p3=250&p4=136&p5=48&p6=56&p7=214&p8=240`);