How to use PostgreSQL with Docker & Python (also Web UI)



How to use PostgreSQL with Docker & Python (also Web UI)

How to use PostgreSQL with Docker & Python (also Web UI)

Setup Postgres locally with docker and interact with it using Python & a Web UI.

We set up Postgres locally from scratch using docker compose. We also setup a Web UI called Adminer which makes interacting with the Database easier. Lastly, we look at a Python library you can use to insert or read data easily from Postgres.

This can be a quick backend setup for any app that you develop. You can also spin it up inside an EC2 instance when deploying in prod. You will just have to tweak the Docker file to retain the docker volume.

0:00 Intro
0:32 Setup Docker Compose
3:27 Adminer Web UI
5:35 Python & Postgres
12:20 Recap & Outro

Docker Images:
https://hub.docker.com/_/postgres
https://hub.docker.com/_/adminer

Code: https://github.com/irtiza07/postgres-python-docker

Visit me at: https://irtizahafiz.com
Contact me at: [email protected]

#postgres #database #python #docker

Comments are closed.