Web server management
Apache setup & Virtual servers
Initial setup Install packages sudo apt install apache2 mariadb-server libapache2-mod-php php-my...
SQL
After install ensure secure access sudo mysql_secure_installation Logging in mysql -u USER...
SSL & Certificate management
Install certbot and run setup sudo apt install certbot python3-certbot-apache a2enmod ssl sudo...
PostgreSQL
Install Install postgresql and postgis for coordinates data sudo apt install postgresql postgis...
SQL Reference
Create a table that auto deletes on other table deletion CREATE TABLE tradie_postcode_covered ( ...
Mailcow Dockerized Setup Guide (Home Server + VPS Proxy + Tailscale)
This guide installs Mailcow on your home server (behind CGNAT), with your VPS handling public-fac...