Bob Bae bobbae

99% of the information in this guide is taken from here: https://golb.hplar.ch/2019/01/expose-server-vpn.html I've added some stuff and changed some things to suit my needs.

A much easier method would be to follow: Routing Plex traffic through an SSH Tunnel

Both solutions work, however I've had better success with Wireguard.

Make sure your VPS is KVM. I've used both BuyVM and ServerCheap and have had good results.

Expose a server behind CG:NAT via Wireguard

Docker - Create a Bridge and Shared Network

Sometimes I want to use Docker containers like regular VMs, creating a bridge on a Docker host, having containers on the same subnet with IP addresses I want to assign, and then logging into them via port 22. (No port forwarding, please.) So here's how to do it.

On this example, I use Vagrant and VirtualBox on my MacBook and create containers with IP addresses shown on the table below. Once you go through these steps, you should be able to extend the idea into your on-premises network.

PostgreSQL JSON Cheatsheet

Using JSON in Postgres by example.

Quick setup via Docker

Download and install: Docker Toolbox
Open Docker Quickstart Terminal
Start a new postgres container:
docker run --name my-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres

	# Change these variables as necessary.
	main_package_path = ./cmd/example
	binary_name = example

	# ==================================================================================== #
	# HELPERS
	# ==================================================================================== #

	## help: print this help message
	.PHONY: help

	# updates etc
	sudo apt update
	sudo apt upgrade -y
	# install pre-reqs
	sudo apt install tasksel -y
	# get the file
	wget https://dl.google.com/linux/direct/chrome-remote-desktop_current_amd64.deb
	sudo dpkg --install chrome-remote-desktop_current_amd64.deb
	sudo apt install --assume-yes --fix-broken
	sudo tasksel install ubuntu-desktop

	TAG_COMMIT := $(shell git rev-list --abbrev-commit --tags --max-count=1)
	TAG := $(shell git describe --abbrev=0 --tags ${TAG_COMMIT} 2>/dev/null \|\| true)
	COMMIT := $(shell git rev-parse --short HEAD)
	DATE := $(shell git log -1 --format=%cd --date=format:"%Y%m%d")
	VERSION := $(TAG:v%=%)
	ifneq ($(COMMIT), $(TAG_COMMIT))
	VERSION := $(VERSION)-next-$(COMMIT)-$(DATE)
	endif
	ifeq $(VERSION,)
	VERSION := $(COMMIT)-$(DATA)

	import sqlite3 as sql
	import os
	import csv
	from sqlite3 import Error

	try:

	# Connect to database
	conn=sql.connect('mydb.db')

	This is free and unencumbered software released into the public domain.

	Anyone is free to copy, modify, publish, use, compile, sell, or
	distribute this software, either in source code form or as a compiled
	binary, for any purpose, commercial or non-commercial, and by any
	means.

	In jurisdictions that recognize copyright laws, the author or authors
	of this software dedicate any and all copyright interest in the
	software to the public domain. We make this dedication for the benefit

	# Reference:
	https://www.cloudgear.net/blog/2015/5-minutes-kubernetes-setup/

	# install homebrew and cask
	ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

	# install virtualbox
	brew cask install virtualbox

	# install dockertoolbox

	package main

	import (
	"net"
	"os/exec"

	"github.com/k0kubun/pp"
	)

	func Hosts(cidr string) ([]string, error) {