Docker is a product that allows developers to create containers, which are self-contained areas on their computer for running applications. They can be used for databases, which is great if you can’t install it normally (e.g. you use a Mac).
This video shows you how to set up a PostgreSQL database on Docker. It uses an existing PostgreSQL image on the Docker Hub website. You can use many different versions of PostgreSQL, not just the latest version.
You’ll learn how to download and install Docker, find the right PostgreSQL image, download the image, run it, and connect to it in the DBeaver IDE. You can use any other IDE that works with PostgreSQL if you prefer.
The connection details for this image mentioned in the video are below.
Host: localhost
Port: 5432
Username: postgres
Password: whatever you specify in the “docker run“ command (default is mysecretpassword)
Timestamps:
00:00 In this video
00:05 High-level steps
00:29 Download Docker
01:23 Run Docker
02:07 Create Docker Hub account
02:41 Search for PostgreSQL image on Docker Hub
03:15 Understand the docker run command
04:29 Adjust docker run command
05:19 Open Terminal and login to Docker
06:12 Download image using Docker Run
06:52 Check status using docker ps
07:19 Connect using DBeaver
07:47 Enter connection details
08:43 Run simple query
09:05 Docker Stop command
/// RESOURCES
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here:
SQL Roadmap: an overview of SQL topics, which is a great place to start:
Contact me here for questions, sponsorship requests, and more:
Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here:
1 view
174
71
5 months ago 00:00:41 1
Coke and Mentos Slicing Prank Gone WRONG!
5 months ago 00:04:12 1
In Hearts Wake - Farewell (video 2024)
5 months ago 00:46:46 1
FOUND MURDER WEAPON after being CONFRONTED by ANGRY NEIGHBOR
5 months ago 00:10:33 1
Принимайте в мае! Средство для здоровья и молодости! Укрепить здоровье и омолодить кожу!
5 months ago 00:05:13 1
Lighthouse Family - High (Official Music Video)
5 months ago 00:03:50 1
AD INFINITUM - Upside Down (Official Video) | Napalm Records
5 months ago 00:00:59 1
Шикарный Весенний Стиль 50+
5 months ago 00:09:44 1
Easy Silk Screening for Pottery - BEST WAY TO SILK SCREEN POTTERY!
5 months ago 01:16:00 1
AI Manifest: The Most Beautiful Space Visualization on the Internet | 4K UHD | 24 FPS
5 months ago 00:03:39 1
Genshin Impact Animation – ONE MORE PULL (Music Video) ■ feat. Black Gryph0n & Rustage
5 months ago 01:51:55 1
1945-1953 From World War to Cold War
5 months ago 00:10:56 1
Cartoon Character Design USING ONLY YOUR MOUSE : Adobe illustrator Tutorial Speed Art 2021.
5 months ago 00:05:31 1
Урок 9. Writing a formal letter. Английский язык 11 класс
5 months ago 00:11:43 1
Secret Chemtrail Pilot Speaks, on Dec 8, 2014
5 months ago 00:00:16 1
Assassins creed mask Steel Soul music tiktok trend
5 months ago 00:04:48 1
How to FIX Desyncs in 5 Minutes
5 months ago 00:01:06 1
Changing ISO Files to use B Raw in resolve 18
5 months ago 00:00:16 1
I and trend mask Triple Death music tiktok
5 months ago 00:06:18 1
OMNIMAR - Forever (Official Video) | darkTunes Music Group
5 months ago 00:04:02 1
How to use can and can’t | English for kids with Novakid
5 months ago 00:06:15 1
After effects “SMOOTH TEXT ANIMATION“
5 months ago 00:04:46 1
Slipknot - Unsainted [OFFICIAL VIDEO]
5 months ago 00:57:00 1
Simon Keye | All The Way Visual March 2024 at Sea Casino | Burgas (Bulgaria)
5 months ago 00:00:00 1
4/4 PORTAL • APRIL 2024 • MANIFEST YOUR DREAMS • MIRACLE FREQUENCY • 528Hz