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

[@shreyashsrivastava5467]

Again Love from India ❤️

[@veryacademy]

👍

[@acronproject]

Thanks so mch Mr. Zanda

[@sotak77]

Awesome tutorial, thank you for all the good information

[@edecilcorrea3450]

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

[@rangabharath4253]

Awesome as always 👍😀

[@veryacademy]

Thank you! Cheers!

[@arek7198]

Thanks a lot for very good tutorial

[@benjaminagyekum7283]

Always releasing new interesting videos

[@veryacademy]

Glad you think so!

[@JamelBMensah]

Firstly I will say you are a very good Instructor and you've help me a lot but I have this question Please help me I tried changing the password in the docker-compose file but I'm getting errors My question is can I change it or not? And if I can how can I go about doing that?

[@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!

[@dennissanchez5171]

Helpful, thanks!

[@xRezNex]

Excellent. Gained a sub

[@veryacademy]

Welcome aboard! Thank you!

[@txcing9296]

amazing thank you

[@giannifed]

thank you very much

[@veryacademy]

Thank you 🙏

[@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?

[@mrmuranga]

awesome....Thanks for the trouble

[@veryacademy]

No worries! 👍

[@dodokwak]

Thank you.

[@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

[@RishiSaikia]

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

[@Arjun147gtk]

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

[@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

[@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?

[@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

[@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

[@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.

[@Kos37376]

i dont have 'data' directoty((

[@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?

[@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