一覧へ戻る
Example of dockerfile python Web flask and a postgresql12.1 database
- star 数
- 4
- watcher 数
- 1
- fork 数
- 147
- issue 数
- 0
- 最終更新
- 2025/09/23
gem-hunterExample of dockerfile python Web flask and a postgresql12.1 database
Example on how to set up a multi-containers platform using Python-Flask-SqlAlchemy, postgresql12 database and Pgadmin4
Get this repository
git clone https://github.com/system-dev-formations/todo-flask-postgres.git
Do a fork and git clone in your local host where your IDE is installed and in your Vm
docker volume create data docker volume ls
Start the Postgresql database container
docker run -d --name db -e POSTGRES_PASSWORD=password -v data:/bitnami/postgresql \ -p 30452:5432 bitnamilegacy/postgresql:17.6.0-debian-12-r4
Launch the PgAdmin 4 container connected to the Postgresql database
docker run -d --name pgadmin -p 30100:80 --link db:postgres -e PGADMIN_DEFAULT_EMAIL=ambient-it@gmail.com \ -e PGADMIN_DEFAULT_PASSWORD=p4ssw0rd dpage/pgadmin4
Study the way how to set up the database connection using the Docker internal DNS container name as an IP address entry. So for connecting to postgresql database use the container name db and its port number 5432.
cd todo-flask-postgres cd sql docker cp todos.sql db:/tmp docker exec -it db /bin/ash cd tmp ls su postgres create database tododb; \c tododb \i todos.sql select * from todos; \q exit
Click on the tab named Database on the right hand-side of your Jetbrains IDE
click on the sign + and select datasource -> PostgreSQL
enter a name, ip address, username postgres , password: password
Hit test connection button
After that a console screen is opened
Type CREATE DATABASE tododb;
Edit the file todos.sql in your project file the sql directory
Put your mouse cursor in the file and right click , select run todos
Press the sign + on target datasource and select tododb
and press run
In pgAdmin4 set a connection to the postgresql database, username is ambient-it@gmail.com and the password is
p4ssw0rd
create a database named create database tododb
and run the script ./sql/todos.sql against the tododb database
Build todo-sql image
cd todo-flask-postgres
docker build -t todo-postgres .
After type in your shell console
docker run -it -d --name todo --link db:todo -p 32500:5000 todo-postgres
Bring up your favorite browser
http://<ip>:32500/
and check the connectivity
We are going to setup a python virtualenv
sudo apt-get install python3
sudo apt-get -y install python3-pip
sudo apt-get -y install python3-venv
sudo apt-get -y install build-essential
sudo apt-get -y install python3-dev libxml2-dev libxslt-dev libffi-dev
python3 -m venv venv
source venv/bin/activate
pip3 install wheel
pip3 install docker-compose
sudo yum install python3 sudo yum install python3-pip python3 -m venv venv source venv/bin/activate pip3 install docker-compose # should be version 1.29.2
In the directory todo-flask-postgres, type
docker-compose up for frontend usage
or
docker-compose up -d for background usage
###- NOTE pour Ubuntu 16.04 ----
rm -Rf venv python3 -m venv venv source venv/bin/activate pip install --upgrade "pip < 21.0" pip install wheel pip install docker pip install docker-compose pip3 install ansible
docker run -d --name db1 -e POSTGRES_PASSWORD=password -v /opt/postgres13:/var/lib/postgresql/data
-p 7432:5432 postgres13
docker volume create portainer_data docker run -d -p 32125:8000 -p 32126:9443 --name portainer --restart=always -v /var/run/docker.sock:/var/run/docker.sock \ -v portainer_data:/data portainer/portainer-ce:2.27.0-alpine