Twelve repositories for keeping what you built running

# On the Hetzner server, as root. Debian or Ubuntu:
sudo apt update
sudo apt install pgbackrest
# Tell it where to keep backups and which database to protect.
sudo mkdir -p /var/lib/pgbackrest
sudo chown postgres:postgres /var/lib/pgbackrest
sudo tee /etc/pgbackrest/pgbackrest.conf > /dev/null <<'EOF'
[global]
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2
start-fast=y
[main]
pg1-path=/var/lib/postgresql/16/main
EOF
# Then, in postgresql.conf, switch on change logging and point it at pgBackRest:
#   archive_mode = on
#   archive_command = 'pgbackrest --stanza=main archive-push %p'
# Restart PostgreSQL, then:
sudo -u postgres pgbackrest --stanza=main stanza-create
sudo -u postgres pgbackrest --stanza=main check
sudo -u postgres pgbackrest --stanza=main --type=full backup

# On the server:
docker run -d --name dozzle \
  -v /var/run/docker.sock:/var/run/docker.sock \
  -v dozzle_data:/data \
  -p 127.0.0.1:8080:8080 \
  amir20/dozzle:latest

mkdir -p ~/npm && cd ~/npm
cat > docker-compose.yml <<'EOF'
services:
  app:
    image: jc21/nginx-proxy-manager:latest
    restart: unless-stopped
    ports:
      - '80:80'
      - '443:443'
      - '127.0.0.1:81:81'
    volumes:
      - ./data:/data
      - ./letsencrypt:/etc/letsencrypt
EOF
docker compose up -d

mkdir -p ~/pocket-id && cd ~/pocket-id
cat > docker-compose.yml <<'EOF'
services:
  pocket-id:
    image: ghcr.io/pocket-id/pocket-id:v2
    restart: unless-stopped
    env_file: .env
    ports:
      - '127.0.0.1:1411:1411'
    volumes:
      - ./data:/app/data
EOF
echo "APP_URL=https://id.example.com" > .env
echo "TRUST_PROXY=true" >> .env
docker compose up -d

mkdir -p ~/usesend && cd ~/usesend
curl -fsSL https://raw.githubusercontent.com/usesend/useSend/main/docker-compose.yml -o docker-compose.yml
# Read the file, then set your own values in an .env beside it:
#   DATABASE_URL, NEXTAUTH_SECRET, AWS_ACCESS_KEY, AWS_SECRET_KEY, AWS_DEFAULT_REGION
docker compose up -d

# Debian and Ubuntu package it directly:
sudo apt update
sudo apt install pgbadger
# Switch on query logging in postgresql.conf:
#   log_min_duration_statement = 0
#   log_line_prefix = '%t [%p]: user=%u,db=%d,app=%a,client=%h '
#   log_checkpoints = on
#   log_lock_waits = on
#   log_temp_files = 0
# Reload PostgreSQL, let it run for a day, then:
pgbadger /var/log/postgresql/postgresql-16-main.log -o ~/report.html

cd ~/grasppy
source venv/bin/activate
pip install "testcontainers[postgres]" pytest

mkdir -p ~/invoiceshelf && cd ~/invoiceshelf
git clone https://github.com/InvoiceShelf/docker.git .
# Pick one of the provided compose files: SQLite, MariaDB or PostgreSQL.
cp .env.example .env
# Edit .env — set APP_URL and the database password — then:
docker compose up -d

cd ~/your-site
npm install open-props

cd ~/youtube
python3 -m venv venv
source venv/bin/activate
pip install faster-whisper

cd ~/scalpingmate
source venv/bin/activate
pip install Riskfolio-Lib

git clone -b v3.2.1 --single-branch https://github.com/plausible/community-edition plausible-ce
cd plausible-ce
touch .env
echo "BASE_URL=https://plausible.example.com" >> .env
echo "SECRET_KEY_BASE=$(openssl rand -base64 48)" >> .env
docker compose up -d