Twelve repositories for your database, your money and your files

# The easiest route if Go is already on the machine:
go install github.com/xataio/pgroll@latest
# Otherwise download the Linux build from the releases page:
#   https://github.com/xataio/pgroll/releases/latest
# then make it runnable and put it on your path:
chmod +x ./pgroll
sudo mv ./pgroll /usr/local/bin/pgroll
pgroll --version
# Prepare the database once (it adds its own bookkeeping tables):
pgroll init --postgres-url "postgres://user:password@localhost:5432/yourdb"
# Then start a change, and complete it when your new code is live:
pgroll start migrations/01_add_column.json
pgroll complete

# Nothing to install for the normal route. First get the plan, in psql:
#
#   EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT ... ;
#
# Copy the whole result, then open https://explain.dalibo.com and paste it.
# For a private plan, take the standalone page from the releases list at
#   https://github.com/dalibo/pev2/releases/latest
# It is a single HTML file. Save it and open it with your browser — no
# server and no internet connection needed.

# Python 3.10 or newer
python3 -m venv venv
source venv/bin/activate
pip install locust
# Write a file called locustfile.py, for example:
cat > locustfile.py <<'EOF'
from locust import HttpUser, task, between
class Visitor(HttpUser):
    wait_time = between(1, 3)
    @task
    def home(self):
        self.client.get("/")
EOF
locust -f locustfile.py --host https://example.com
# then open http://localhost:8089 and choose how many visitors

# Debian or Ubuntu
sudo apt install age
# macOS
brew install age
# Make your key once. Keep the private key safe; the public key is printed.
age-keygen -o ~/age-key.txt
# Lock a file, using the public key that age-keygen printed:
age -r age1qqq...yourpublickey -o dump.sql.age dump.sql
# Unlock it again:
age -d -i ~/age-key.txt -o dump.sql dump.sql.age
# Or do it in one line, straight out of PostgreSQL:
pg_dump yourdb | age -r age1qqq...yourpublickey > dump.sql.age

# Needs Docker. Put your settings file in /etc/OliveTin/config.yaml first.
sudo mkdir -p /etc/OliveTin
sudo tee /etc/OliveTin/config.yaml >/dev/null <<'EOF'
listenAddressSingleHTTPFrontend: 0.0.0.0:1337
logLevel: INFO
actions:
  - title: Show disk space
    shell: df -h
  - title: Restart the app
    shell: systemctl restart myapp
EOF
docker create --name olivetin -p 1337:1337 \
  -v /etc/OliveTin/:/config:ro docker.io/jamesread/olivetin
docker start olivetin
# then open http://your-server:1337 — behind a password, not on the open internet

# The easiest route if Rust's package manager is installed:
cargo install argc
# Otherwise take the binary for your system from
#   https://github.com/sigoden/argc/releases/latest
chmod +x ./argc
sudo mv ./argc /usr/local/bin/argc
# A one-file example. Save it as Argcfile.sh:
cat > Argcfile.sh <<'EOF'
#!/usr/bin/env bash
# @describe Small jobs for this project
# @cmd Back up the database
# @arg name!  The database name
backup() {
    pg_dump "$1" > "$1-$(date +%F).sql"
}
eval "$(argc --argc-eval "$0" "$@")"
EOF
chmod +x Argcfile.sh
./Argcfile.sh backup --help

# Needs Docker.
mkdir -p ~/actual-data
docker run --pull=always --restart=unless-stopped -d \
  -p 5006:5006 \
  -v ~/actual-data:/data \
  --name my_actual_budget \
  actualbudget/actual-server:latest
# then open http://localhost:5006 and set a password on first use
# to update later:  docker pull actualbudget/actual-server:latest

# Debian or Ubuntu
sudo apt install hledger
# macOS
brew install hledger
# Make your first journal file:
mkdir -p ~/finance
cat > ~/finance/2026.journal <<'EOF'
2026-09-14 opening balances
    assets:bank:checking          1000
    equity:opening balances
2026-09-14 Hetzner server
    expenses:hosting                12
    assets:bank:checking
EOF
hledger -f ~/finance/2026.journal balance
hledger -f ~/finance/2026.journal incomestatement

# Needs Docker. A database container first:
docker run --name mysql -e MYSQL_ROOT_PASSWORD=change-this -d mysql:8
# Then EspoCRM itself, on port 8080:
docker run --name my-espocrm -p 8080:80 --link mysql:mysql -d espocrm/espocrm
# then open http://localhost:8080 — the first login is admin / password,
# and changing it is the first thing to do.
# For a real install use the Docker Compose setup in the documentation at
#   https://docs.espocrm.com/administration/docker/installation/
# which also runs the background daemon and the websocket service.

# Python 3.9 or newer
python3 -m venv venv
source venv/bin/activate
pip install -U gallery-dl
gallery-dl --version
# Download a whole gallery into a tidy folder:
gallery-dl -d ~/research "https://www.reddit.com/r/somesubreddit/"
# See what it would do, without downloading anything:
gallery-dl --simulate "https://www.reddit.com/r/somesubreddit/"

# Needs Node.js 18 or newer
npm install metascraper \
  metascraper-title \
  metascraper-description \
  metascraper-image \
  metascraper-url
# A minimal use, in a file called preview.mjs:
cat > preview.mjs <<'EOF'
import createMetascraper from 'metascraper'
import title from 'metascraper-title'
import description from 'metascraper-description'
import image from 'metascraper-image'
const scraper = createMetascraper([title(), description(), image()])
const targetUrl = process.argv[2]
const html = await (await fetch(targetUrl)).text()
console.log(await scraper({ html, url: targetUrl }))
EOF
node preview.mjs https://example.com

# Debian or Ubuntu
sudo apt install audiowaveform
# macOS
brew tap bbc/audiowaveform
brew install audiowaveform
# Make a picture of an episode's sound:
audiowaveform -i episode.mp3 -o episode.png -w 1800 -h 280
# Or get the numbers, for drawing on a web page later:
audiowaveform -i episode.mp3 -o episode.json -b 8
# Straight from a video, using ffmpeg to pull the sound out first:
ffmpeg -i episode.mp4 -f wav - | audiowaveform --input-format wav -o episode.png