Docker in Practice| Database server and connections | Tutorial 5-Docker Series

Hello everyone, Welcome to Docker in Practice!
This is my fifth tutorial, In today's video, I'm going to talk about Databases and how to set up one database using Docker. Almost every software and application need a storage mechanism such as a Database. There are different kinds of databases: SQL, NoSQL, Cache, and File.

In this lesson, I will talk about setting up an SQL database, and how to manage connections to it.
It's highly recommended to use connection pools to manage connections to a database server.

Among many flavors of SQL servers, I've chosen Postgres which is open source and fast. In addition, there are many libraries for it in Python.

We can use some init.sql scripts at the beginning of database startup to do some initializations such as creating user and database.

To manage dependencies, we use docker-compose "depends_on" feature. For example, "auth" services have a dependency on "db" service. Meaning "auth" service won't bring up until "db" service is fully up and healthy.

Every service has a health check command that indicates its health status. It is highly recommended to add a health check for each service. You can use it either in Dockerfile or in the docker-compose.yml file.


The full source code is available at: https://github.com/teacheetah/tutorial04.git

If you are interested in watching our other videos on the topic of Docker, you can find them by links below:

1. Docker in Practice: Production Grade Usage of Docker| Tutorial 1-Docker Series:
https://youtu.be/i0J3Nz2dlBg

2. How to Use Docker Compose to Orchestrate Containers | Tutorial 2: Docker Series
https://youtu.be/V6SPyMY7C-U

3. Docker in Practice: NGINX Reverse Proxy and Webserver with Docker Compose| Tutorial 3: Docker Series
https://youtu.be/cUrKgu36Fa4

4. Docker in Practice: Rate Limit in NginX Web Server: Tutorial 4-Docker Series
https://youtu.be/CrmKlo5HMI4

#Docker_Tutorials
#Database_server
#how_to_setup_database_with_docker
#Docker_for_Database_setup
#docker_composer
#docker_applications
#Database
#Docker_Examples
#Dockerfile
#Data_base_startup
#Health_Check_Command
#SQL_Database
#Postgres
#Postgres_Libraries_Python
#Docker_Practices
#Docker_with_applications