I have been using Cloudflare Tunnels increasingly over the last year to securely enable my applications to be reached publicly without having to open firewall ports in my server. However, installing cloudflared and then setting up tunnels is not very straightforward. So, I wanted to develop this tutorial as a way to get tunnels up and running quickly. These steps are tested on Ubuntu 22.04.

TL;DR: The “One-Script” Method

If you want to automate everything, save the following script as setup_tunnel.sh, make it executable (chmod +x), and run it as ./setup_tunnel.sh <name> <hostname> <port>.

This post is about the following:

1. Setup Cloudflare Tunnels to access your website publicly without the risks of opening ports on your router.
2. Install Docker and Docker-Compose on Linux.
3. Install Postgres database using Docker.
4. Install Mastodon on Docker

Setup Cloudflare Tunnels

I have another post on how to setup Cloudflare Tunnels on Linux. Please follow those steps and then return here. Make sure you use port 3000 instead of port 80 as shown in the example config.yml file.

I have been trying for some days to create a PostgreSQL server and expose it on the web so that it can be accessed by external clients. This is useful to me for hosting several personal projects that require a database.

First things first, let’s create our env variables.

HOSTNAME="subdomain.domain.tld" # Hostname of your server
EMAIL="email@email.com" # Used for Let's Encrypt certificate
VERSION="14" # PostgreSQL version
NAME="db" # Database name

Let’s update our packages now.

Like many other people, I tend to be frustrated often trying to find the right command while using Git. This document is an attempt to collect as many useful commands from various places on the internet to make commands easier to find in a single location. I used some excellant resources such as this while creating this.

Before You Begin

It is always a good idea to take a backup of your entire working directory including .git before you attempt anything mentioned here.

In order to sort rows in Pandas, you can use the sort_values() function. I have taken examples from this excellant blog. Although it shows a lot of the use cases covered here, the last case is absent pretty much everywhere.

In this tutorial, I will be showing how to use Pandas to sort rows based on different criterion.

You can run a colab notebook containing all code present in this post by clicking here.