Flask Web Application to fetch data from Postgresql database

Tools needs to be installed on Web Server

sudo yum update -y
sudo yum install python3 python3-pip nginx -y
sudo pip3 install flask gunicorn -y
sudo pip3 install psycopg2-binary -y

Bastion Host - Postgresql client tool install

sudo yum install postgresql -y

postgresql RDS connect

psql -h <host> -p <port> -U <username> -d <database>

Create table query

Query to add the data into the table

INSERT INTO myapp(name, topic)
VALUES ('NAME', 'TOPIC');