# WeFixTech

> Linux, hosting and self-hosting guides in plain English, plus the classic
> "SQL Help" MySQL tutorial archive that lived on this domain in 2006-2009,
> rewritten and updated for MySQL 8 at its original URLs. The domain has been
> online since 2004, when it was a small UK hosting company and a public
> mirror of the Linux Documentation Project, PuTTY and VLC.

## Linux & hosting guides

- [First 10 minutes on a new Linux server](https://wefixtech.co.uk/linux/secure-a-linux-server/): SSH keys, firewall, automatic updates, fail2ban
- [Docker Compose basics](https://wefixtech.co.uk/linux/docker-compose-basics/)
- [Reverse proxy with automatic HTTPS (Caddy)](https://wefixtech.co.uk/linux/reverse-proxy-https-caddy/)
- [Backups that actually restore](https://wefixtech.co.uk/linux/backups-that-restore/)
- [Linux file permissions: chmod, chown](https://wefixtech.co.uk/linux/file-permissions-chmod-chown/)
- [Web hosting explained: types, costs, how to choose](https://wefixtech.co.uk/hosting/)
- [Self-hosting for beginners](https://wefixtech.co.uk/linux/self-hosting-getting-started/): hardware, first services, Docker Compose, backups
- [How to choose a VPS](https://wefixtech.co.uk/linux/choosing-a-vps/): honest spec guidance and fair prices
- [Shared hosting vs VPS](https://wefixtech.co.uk/linux/shared-hosting-vs-vps/): which fits which project
- [PuTTY and SSH clients](https://wefixtech.co.uk/linux/putty-and-ssh-clients/): SSH from Windows
- [VLC media player: safe downloads](https://wefixtech.co.uk/linux/vlc-media-player/)

## SQL Help archive (MySQL tutorials)

- [Index of all tutorials](https://wefixtech.co.uk/sqlhelp/)
- Topics: joins, latest-row-per-group, deleting duplicates, AUTO_INCREMENT and
  LAST_INSERT_ID, transactions, stored procedures, SQL_CALC_FOUND_ROWS replacements, NULL vs empty string, normalising list columns,
  date conversion, calendar tables, booking availability queries, LOAD DATA,
  integer types, exporting with headers

## About

- [The site's story](https://wefixtech.co.uk/about/)