Self-hosting Gitea on a VPS: SQLite vs Postgres, HTTPS, and the SSH port nobody warns you about

Gitea is successfully self-hosted on a VPS with secure HTTPS, properly configured SSH, optional HTTPS-only workflow, and CI runner support, using either SQLite