Working example for my Open Source Data Solution Example. Hosted VM with digitalocean.com (if interested see my referral link for an offer benefitting both of us)

Check with other notes on Server Configuration - Virtual Host

Hostname: osdse.roman-halliday.com

################################################################
# As root : or sudo su
 
apt-get update && apt-get upgrade -y
# Kept new version (root login key only)
 
################################################################
# create a user for me
adduser david
# Add my user to sudo
usermod -a -G sudo david
 
#Setup keys
su david
# As david (paste key to new authorized_keys file)
mkdir -p ~/.ssh
vi ~/.ssh/authorized_keys
 
################################################################
# sshd config (stop root login, all authentication by keys only is now default)
vi /etc/ssh/sshd_config
systemctl restart ssh

See Firewall

# Allow SSH before we turn on
sudo ufw allow 22
# Enable Firewall
sudo ufw enable
# View status
ufw status

If you need multiple versions/more control, go for pyenv. But in most cases the latest stable will be fine (right how that's 3.12).

Ubuntu searching python versions

apt-cache search python3 | grep 'python3 '
apt-cache search python3 | grep -e 'python3\.[0-9][0-9]-full'

Just get the latest full package for this version of Ubuntu (more than we need, but it's not like it's expensive)

sudo apt-get install python3-full
 
# Test
python3 --version

see: PostgreSQL

apt-cache search postgres | grep '^postgresql-*[0-9]* '
sudo apt-get install postgresql

Config:

sudo vi /etc/postgresql/16/main/postgresql.conf

listen_addresses = '*'          # what IP address(es) to listen on;

sudo vi /etc/postgresql/16/main/pg_hba.conf

#host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             0.0.0.0/0               scram-sha-256

Configure simple shop: https://github.com/d-roman-halliday/simple_shop_data_generator/blob/main/database_setup/database_and_users_postgres.sql

See: mysql

Probably ignore this

<a href="https://www.digitalocean.com/?refcode=bb281f2fae53&utm_campaign=Referral_Invite&utm_medium=Referral_Program&utm_source=badge"><img src="https://web-platforms.sfo2.cdn.digitaloceanspaces.com/WWW/Badge%201.svg" alt="DigitalOcean Referral Badge" /></a>
[![DigitalOcean Referral Badge](https://web-platforms.sfo2.cdn.digitaloceanspaces.com/WWW/Badge%201.svg)](https://www.digitalocean.com/?refcode=bb281f2fae53&utm_campaign=Referral_Invite&utm_medium=Referral_Program&utm_source=badge)