[Backend #2] Install & use Docker + Postgres + TablePlus to create DB schema

In this lecture, we will learn how to install Docker desktop on local machine, then download and start a PostgreSQL container, run some basic docker commands.
We will also learn how to setup and use TablePlus to connect and interact with Postgres, and use it to run the SQL script that we’ve generated in the previous lecture to create our Simple Bank’s database schema.

---

In this backend master class, we’re going to learn everything about how to design, develop, and deploy a complete backend system from scratch using PostgreSQL, Golang and Docker.

TECH SCHOOL - From noob to pro
At Tech School, we believe that everyone deserves a good and free education. We create high-quality courses and tutorials in Information Technology. If you like the videos, please feel free to share and subscribe to support the channel.

Credit:

[zulia]

This is awesome! Splitting the course into short videos is such a smart idea. As someone with ADHD, I really appreciate this. Thank you so much (cảm ơn anh rất nhiều)

[mannerism]

Just pure respect for the clarity and the quality of information you voluntarily share with us all.

[aminuolawale]

The clarity and pace of your teaching are just perfect.

[vincentadams]

teaching me what university failed to, thank you so much. These videos deserve millions of views.

[bernardobalves-i]

Wanted to add that if by any chance you already have psql installed on your local machine serving the port 5432, tableplus will try to connect to that local psql instance.

To work around this, when running the docker set your port to 5433:5432 (just an example) and then choose port 5433 on tableplus.

[wahebbenzaid]

Perfect, nothing to say or add! thank you for your effort and for sharing this all knowledge with us!

[vedantshinde]

I'm so excited to go through this entire series! Thank you for it!!

[rishabhagrawalzra]

Hi, TECH SCHOOL, you just made my day with this awsome playlist

[gorangratte]

at 8:00 you can also just type the first character(s) of the docker id.
if there is only one id that starts with 7 (79711fc0f51c) you can use $ docker exec -it 7 psql

[steviecoyle]

You helped me solve my port bridging. Thanks. Great explaination.

[lakshminarayana]

Nevr before ever after, such a nice explanation on db design

[tuandungnguyen]

Cảm ơn anh, vids của anh thực sự rất hữu ích ! Chúc anh luôn mạnh khỏe !

[i-am-learning-life]

Content is amazing love to learn more 😍😍😍

[johntony]

Awesome video, very helpful. I prefer beekeeper studio community edition for database gui

[nguyenhuytoan]

Thank you for videos! Great content for me.

[connorcantrell]

Brilliant tutorial. I am stuck at testing the database (9:40) with TablePlus. I am receiving `FATAL: role "root" does not exist`. Help would be greatly appreciated!

[blackaccel]

So for anyone following this process with WSL2 in Windows, maybe you tried to connect to postgres from TablePlus and it send an error. That is because Docker doesn't share the same IP address when installed with WSL2. So to access the server in the Docker container:
- Find out the IP of your WSL session. Type "ip a" from within WSL2.
- Connect to TablePlus with the address of the WSL session.
Example of the Docker container address I got 172.20.190.192/20. And remove the /20 when connecting to TablePlus

[sajirt]

Thanks for the tutorials. It helped me a lot.

Is there a way to use do database migrations without using docker?

[vic_shine]

Thanks for such a detailed tutorial!
One question for more understand: as I know, all data on Docker containers destroyed, when I stop container. So, how to save database data using Docker? For example, for backup or transfer between servers? Would be great to video tutorial or dev.to article about this process.

[makhchanemosaab]

For the rest of the series are we going to use WSL or Poweshell ?