Python: flask-postgresql Deployment

Install PostgreSql

sudo apt update
sudo apt install curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
. /etc/os-release
sudo sh -c "echo 'deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $VERSION_CODENAME-pgdg main' > /etc/apt/sources.list.d/pgdg.list"
sudo apt update
sudo apt -y install postgresql-16

Connect to Database

psql -h azure2501db.postgres.database.azure.com -p 5432 -U adminuser postgres

Create database and Table for application

\list
CREATE DATABASE demo_app;
\c demo_app
\dt

Create Table

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    number VARCHAR(20)
);

check the table and table data

\dt
SELECT * FROM "users";
exit;

download the code into server and run the application

ls
git clone https://github.com/muralialakuntla3/flask-postgresql.git
cd flask-postgresql
ls

Install dependencies

sudo apt install python3-flask -y 
sudo apt install python3-psycopg2 -y

update database details in app.py file

vi app.py

run application

python3 app.py 

check the application

• update the network security group to allow port 5000

- browse the application - public-ip:5000 

check the database

• connect the database and verify the data

psql -h myappdatabase.postgres.database.azure.com -p 5432 -U adminuser demo_app
\dt
SELECT * FROM users;