Cornel Ghiban cghiban

PostgreSQL is Enough

Background and Cron Jobs

Raspberry Pi on Internet via reverse SSH tunnel

HackerNews discussed this with many alternative solutions: https://news.ycombinator.com/item?id=24893615

I already have my own domain name: mydomain.com. I wanted to be able to run some webapps on my Raspberry Pi 4B running perpetually at home in headless mode (just needs 5W power and wireless internet). I wanted to be able to access these apps from public Internet. Dynamic DNS wasn't an option because my ISP blocks all incoming traffic. ngrok would work but the free plan is too restrictive.

I bought a cheap 2GB RAM, 20GB disk VM + a 25GB volume on Hetzner for about 4 EUR/month. Hetzner gave me a static IP for it. I haven't purchased a floating IP yet.

Introductory resources

High level overview https://yogthos.github.io/ClojureDistilled.html
An Animated Introduction to Clojure https://markm208.github.io/cljbook/
Interactive tutorial in a browser https://tryclojure.org/
Interactive exercises http://clojurescriptkoans.com/
Clerk notebooks with introductory examples https://github.clerk.garden/anthonygalea/notes-on-clojure
More interactive exercises https://4clojure.oxal.org/
Lambda Island tutorials https://lambdaisland.com/
Functional Programming with Clojure resources https://practicalli.github.io/

Intro

This is an experiment in self-teaching Go, starting from complete unfamiliarity with the language. The goal is to provide a step-by-step educational resource that you can follow at your own pace, where each phase effectively builds on that which came before it with as little unnecessary overlap as possible. It's very much a "living document" or work in progress, and will likely be under constant revision as I revisit advice, update sources, tweak ordering and learn more about how these resources interact to create a well-rounded knowledge of the language. Please feel free to issue feedback and make any suggestions you feel are pertinent.

Reading

Go through the tour at https://tour.golang.org/list
Promptly abandon all of those plans you have to use channels everywhere
Read the language spec once over: https://golang.org/ref/spec
https://dave.cheney.net/2017/04/26/understand-go-pointers-in-less-than-800-words-or-your-money-back
Read Effective Go: https://golang.org/doc/effective_go.htm

Cryptographic Best Practices

Putting cryptographic primitives together is a lot like putting a jigsaw puzzle together, where all the pieces are cut exactly the same way, but there is only one correct solution. Thankfully, there are some projects out there that are working hard to make sure developers are getting it right.

The following advice comes from years of research from leading security researchers, developers, and cryptographers. This Gist was [forked from Thomas Ptacek's Gist][1] to be more readable. Additions have been added from

	// Golang example that creates an http client that leverages a SOCKS5 proxy and a DialContext
	func NewClientFromEnv() (*http.Client, error) {
	proxyHost := os.Getenv("PROXY_HOST")

	baseDialer := &net.Dialer{
	Timeout: 30 * time.Second,
	KeepAlive: 30 * time.Second,
	}
	var dialContext DialContext

	#!/bin/bash -e

	image=mdillon/postgis:9.6-alpine
	container_name=my-app-postgresql

	if [ -z "$1" ]; then
	echo "Run command with a dockerised PostgreSQL DB.

	usage: $(basename "$0") command

	fastcgi_cache_path /var/cache/nginx levels=1:2 keys_zone=microcache:10m max_size=1024m inactive=15m;
	map $http_cookie $cache_uid {
	default nil; # hommage to Lisp :)
	~SESS[[:alnum:]]+=(?<session_id>[[:alnum:]]+) $session_id;
	}

	map $request_method $no_cache {
	default 1;
	HEAD 0;
	GET 0;

	from jinja2.environment import create_cache

	# blah blah blah

	app.jinja_env.cache = create_cache(1000)

	# blah blah blah

	app.run()