Andre Steenveld AndreSteenveld

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.

Backend as a Service

Supabase - ~52K stars

Designed explicitly as an open source firebase alternative
Typescript based
Docker support

Appwrite - ~32K stars

Written in JavaScript and PHP
Docker based
Realtime support across all services

Create a new project

poetry new <project-name>

Add a new lib

poetry add <library>

Remove a lib

Enable TCP port 2375 for external connection to Docker

See this issue.
Docker best practise to Control and configure Docker with systemd.

Create daemon.json file in /etc/docker:

 {"hosts": ["tcp://0.0.0.0:2375", "unix:///var/run/docker.sock"]}

	#!/bin/bash
	###################################################################
	#Script Name : mssql_dump.sh
	#Description : will create SQL scripts as defined by mssql-scripter
	# and will zip backup files and store for X days (set to 30)
	#Author : Tim Moses
	#Github : https://github.com/tjmoses
	#Notes : Make sure to add the appropriate MSSQL_SCRIPTER_CONNECTION_STRING
	# for your db connection. Also, revise your target & edition
	# sql server for the mssql-scripter command below. The zip library is

	using System;
	using System.Collections.Concurrent;
	using System.Linq;
	using System.Reflection;
	using LanguageExt;
	using Newtonsoft.Json;
	using Newtonsoft.Json.Linq;

	public class OptionJsonConverter : JsonConverter
	{

	# m5.2xlarge 32.0 GiB 8 vCPUs
	# s=100, n=10

	*** Only SELECTs, -T 30 -j4 -c12
	transaction type: <builtin: select only>
	scaling factor: 100
	query mode: prepared
	number of clients: 12
	number of threads: 4
	duration: 30 s

	version: "3"

	services:
	sonarqube:
	image: sonarqube
	expose:
	- 9000
	ports:
	- "127.0.0.1:9000:9000"
	networks:

	using System;
	using Microsoft.CodeAnalysis;
	using Microsoft.CodeAnalysis.CSharp;
	using Microsoft.CodeAnalysis.CSharp.Syntax;

	namespace Roslyn.CodeGeneration
	{
	public class Program
	{
	public static void Main(string[] args)

	# Pass the env-vars to MYCOMMAND
	eval $(egrep -v '^#' .env \| xargs) MYCOMMAND
	# … or ...
	# Export the vars in .env into your shell:
	export $(egrep -v '^#' .env \| xargs)