Docker Compose | How to configure PostgreSQL or MySQL database with Python Django

[@shreyashsrivastava5467]

Again Love from India ❤️

[@veryacademy]

👍

[@sotak77]

Awesome tutorial, thank you for all the good information

[@akhillshetty2140]

Zander, can you make a video with Django API + React Frontend Docker Package/Deployment? That would be a great addition to this series!!

[@veryacademy]

Hey - I keep telling people I will and not get around to it!

[@greykor140]

@@veryacademy I want this too!

[@acronproject]

Thanks so mch Mr. Zanda

[@edecilcorrea3450]

Thank you very much for this tutorial. You are a very good teacher.

[@arek7198]

Thanks a lot for very good tutorial

[@rangabharath4253]

Awesome as always 👍😀

[@veryacademy]

Thank you! Cheers!

[@dennissanchez5171]

Helpful, thanks!

[@benjaminagyekum7283]

Always releasing new interesting videos

[@veryacademy]

Glad you think so!

[@SoloPython]

Please teach us how to do *Docker + Django + React/Vue* much love!!

[@veryacademy]

No problem - will do a docker React then docker django react

[@SoloPython]

@@veryacademy i love you!

[@naheliegend5222]

What about production? Do you have the real data stored on the machine, where the app is running? In this case in ./data/db?

[@txcing9296]

amazing thank you

[@devjeff3192]

For those who are getting error: django.db.utils.operationalerror: could not translate host name "db" to address: temporary failure in name resolution
You should consider adding the addiotional configs to your docker-compose file:
db:
image: postgres
ports:
- 5432:5432
volumes:
- pgdata:/var/lib/postgresql/data
- pgconf:/etc/postgresql
- pglog:/var/log/postgresql
environment:
- POSTGRES_DB=postgres
- POSTGRES_USER=postgres
- POSTGRES_PASSWORD=postgres
container_name: postgres_db
volumes:
pgdata:
driver: local
pgconf:
driver: local
pglog:
driver: local

[@veryacademy]

Thank you 🙏

[@filipk2834]

Thank you!

[@GoziePO]

Thanks! I'm not sure why that fixed it though

[@giannifed]

thank you very much

[@veryacademy]

Thank you 🙏

[@xRezNex]

Excellent. Gained a sub

[@veryacademy]

Welcome aboard! Thank you!

[@kaushalkhokhar6282]

Excellent,
But I am getting some error which can't be resolved by me.
Can you help me on that....
django.db.utils.OperationalError: could not translate host name "db" to address: Temporary failure in name resolution

[@veryacademy]

Hi Kaushal, difficult to fully diagnose without seeing the code. Presume you have named the db service db in the docker file. Best way for me to help you and anyone else if to start a stack overflow post and put the link in here.
stackoverflow.com/questions/41573313/docker-compose-with-django-could-not-translate-host-name-db-to-address-name-o

[@RishiSaikia]

Where does the /var/lib/PostgreSQL/data come from?

[@dodokwak]

Thank you.

[@mrmuranga]

awesome....Thanks for the trouble

[@veryacademy]

No worries! 👍

[@Arjun147gtk]

Getting an error as below:
docker endpoint for "default" not found
Please help.

[@phaniophrero8007]

Hi , anyone with this error ? : raise ImproperlyConfigured("Error loading psycopg2 module: %s" % e)
django-container2 | django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: No module named 'psycopg2'.
(UPDATE Fix) I had to delete my previous app image and create it again so it could install the psycopg2-binary package.

[@sergiaguilar1]

Why do you need to create another container for every service?

[@veryacademy]

You dont need to. However, once things start to scale then you find that might be the most effective way to work. Also it is easier to manage services this way.

[@sergiaguilar1]

@@veryacademy Ok got it good tutorial tough

[@ayeshrodrigo2197]

Is there a way to connect these hosted DBs on Docker with MySql Workbench or PG Admin installed on Host PC for monitoring purposes?

[@veryacademy]

Thanks Ayesh
I have a running order from other members requests.
6. Deploy to Heroku
7. Django + React
8. Deploy to Digital Ocean
9. PostGres PGAdmin setup

[@apurvashirbhate5724]

It is supposed to run both ways with or without docker.
Right?

[@veryacademy]

Point is here we can put Postgres and MySQL in a container so that you don't have to installed them on your computer.

[@apurvashirbhate5724]

@@veryacademySo it is not supposed to run without docker .Right?

[@apurvashirbhate5724]

@@veryacademy So it will give error without docker ?Right?

[@apurvashirbhate5724]

@@veryacademy How to check if the data is added into a table or not

[@veryacademy]

A docker container requires docker installed

[@sabarinathjv4829]

Those who face pg_config executable not found. add below line inside Dockerfile
RUN pip install --upgrade pip
RUN pip3 install -r requirements.txt

[@veryacademy]

Could you make an update request on GitHub I will merge it?

[@shivan2418]

Is there a way to do the database migration that does not involve doing it manually via bash every time?

[@donotlook6048]

What do you mean? I'm learning Docker too but when you want to do a migration in your local machine you gotta do it through your OS command prompt. In this case as you are running the django app in a Linux OS container you need to do it via Bash?

[@Kos37376]

i dont have 'data' directoty((