ethicnology

SSH over TOR

server

install tor

sudo apt install tor

edit /etc/tor/torrc

HiddenServiceDir /var/lib/tor/sshd/

ethicnology

NewUser=winston
sudo useradd $NewUser --create-home
sudo mkdir /home/$NewUser/.ssh
sudo touch  /home/$NewUser/.ssh/authorized_keys
sudo chown -R $NewUser:$NewUser /home/$NewUser/.ssh
sudo chmod 700 /home/$NewUser/.ssh
sudo chmod 600 /home/$NewUser/.ssh/authorized_keys

ethicnology

# based on: https://www.hughesportal.com/blog.php?article=setup-network-bonding-using-netplan
network:
  version: 2
  ethernets:
    enp2s0f0:
      dhcp4: no
      dhcp6: no
    enp2s0f1:
      dhcp4: no
      dhcp6: no

ethicnology

S01E01 Why ?

• Why golang sql and sqlx libraries can't parse array_agg ?

• Why golang json library parse [null] as a struct with default values (int = 0, string = "") instead of an error or an empty array ?

• Why postgres COALESCE(jsonb_agg(DISTINCT to_jsonb(ti)), '[]') still returns [null] instead of [] ?
  I want to add FILTER…

As always:

ethicnology

Download the whole planet dataset (~80 Gb)

curl -OL https://planet.openstreetmap.org/pbf/planet-latest.osm.pbf

Using osmium tool filter amenity=toilets nodes

osmium tags-filter planet-latest.osm.pbf n/amenity=toilets -o toilets.osm

ethicnology

Supabase self-hosted

Setup

Clone docker repository ONLY

mkdir supabase-for-my-app && cd "$_"

git clone -n --depth=1 --filter=tree:0 https://github.com/supabase/supabase .

ethicnology

#!/bin/bash

# Configuration
DB_HOST=""
DB_PORT=""
DB_NAME=""
DB_USER=""
DB_PASS=""
DIR=""
DATE=$(date +"%Y%m%d_%H%M%S")