Discover gists

Prerequisite

sudo apt update
sudo apt install software-properties-common -y

Add custom APT repository

#Transform web.config on build

Unload the project
Edit .csproj
Append figure 1 to the end of the file just before </Project>; v12.0 my change depending on your version of Visual Studio
Save .csproj and reload
Open configuration manager
Add a new Configuration Name: Base. Copy settings from: Release
Copy the contents of your web.config
Right click Web.Config > Add Config Transformation

Code is clean if it can be understood easily – by everyone on the team. Clean code can be read and enhanced by a developer other than its original author. With understandability comes readability, changeability, extensibility and maintainability.

General rules

Follow standard conventions.
Keep it simple stupid. Simpler is always better. Reduce complexity as much as possible.
Boy scout rule. Leave the campground cleaner than you found it.
Always find root cause. Always look for the root cause of a problem.

Design rules

1. Preparing the server

Install git

sudo apt install git-all

Generate Server's SSH public key

ssh-keygen -t rsa -b 4096 -C "deploy"
cat ~/.ssh/id_rsa.pub

Using GitHub Pages with a custom domain: Namecheap Edition

As often happens, I found the official documentation and forum answers to be "close, but no cigar", and so had to experiment a little to get things working.

The main problem for me was a lack of concrete configuration examples. That's not entirely GitHub's fault: having migrated from Google Domains to Namecheap in the middle of this project, I was once again reminded of how many different ways there are to do things in the name service universe [1].

Although you'd think the simplest setup would be to merely configure for the subdomain case (https://www.example.com), in my experience using the apex domain (https://example.com) instead resulted in fewer complications.

Procedure

So here's my recipe for using a custom domain with GitHub pages where Namecheap is the DNS provider:

	/* 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]
	*/

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	#!/bin/bash

	# Colors
	RED='\033[0;31m'
	GREEN='\033[0;32m'
	NO_COLOR='\033[0m'
	BLUE='\033[0;34m'
	YELLOW='\033[0;33m'
	NO_COLOR='\033[0m'

	Encoded Traversal Strings:

	../
	..\
	..\/
	%2e%2e%2f
	%252e%252e%252f
	%c0%ae%c0%ae%c0%af
	%uff0e%uff0e%u2215
	%uff0e%uff0e%u2216

	Rank,Artist,Album,Info,Description
	500,Arcade Fire,Funeral,"Merge, 2004","Loss, love, forced coming-of-age, and fragile generational hope: Arcade Fire’s debut touched on all these themes as it defined the independent rock of the ‘00s. Built on family ties (leader Win Butler, his wife, Régine Chassagne, his brother Will), the Montreal band made symphonic rock that truly rocked, simultaneously outsize and deeply personal, like the best pop. But for all its sad realism, Butler’s is music that still finds solace, and purpose, in communal celebration.
	"
	499,"Rufus, Chaka Khan",Ask Rufus,"ABC, 1977","Fronted by Chaka Khan, one of soul music’s most combustible singers, Rufus built its mid-Seventies sound on heavy-footed, guitar-slathered funk. But after spending 16 months in the studio working on Ask Rufus, they came out with a record that gave their songs more room to breathe, anticipating the lithe, loose arrangements of Nineties neo-soul. Khan glided through the head-nodding “Everlasting Love” and the twisty-tur