Unlocking the power of Postgres on Docker: A step-by-step guide | #tipsandtricks
π Welcome back to Nilesh Gule’s tech explorations! In today’s video, we’re diving into the world of PostgreSQL, using pgAdmin to connect to our server running as a Docker container and run some basic queries. We’ll be creating sample tables. π»
pgAdmin is an incredible tool for managing PostgreSQL databases, and we’ll be walking through its features step-by-step. Whether you’re a seasoned database pro or just getting started, this video has something for you.
Remember, understanding databases is a crucial part of tech literacy, and PostgreSQL is one of the most popular options out there. So, let’s get started!
Don’t forget to like π, comment π¬, and subscribe if you haven’t already! Every interaction helps us grow and bring more quality content to you. Stay tuned for more tech explorations! π
#postgres #dockerdesktop #pgadmin #postgresql
β¬β¬β¬β¬β¬β¬ π Additional Info π β¬β¬β¬β¬β¬β¬
– π Postgresql official Docker Hub image – https://hub.docker.com/_/postgres/
– π pgAdmin tool – https://www.pgadmin.org/
– π Postgres create table script – https://github.com/NileshGule/spring-boot-conference-app/blob/master/src/main/resources/Database/postgres/create_tables.sql
– π Postgres insert data script – https://github.com/NileshGule/spring-boot-conference-app/blob/master/src/main/resources/Database/postgres/insert_data.sql
β¬β¬β¬β¬β¬β¬ β± Chaptersβ± β¬β¬β¬β¬β¬β¬
00:00 – Introduction
00:15 – Postgres official image and supported tags
00:50 – Run Postgres 15 using Docker run command
02:28 – Connect to Postgres server using pgAdmin
04:40 – Create database, tables and insert data
06:00 – Summary
β¬β¬β¬β¬β¬β¬ π Contact me π β¬β¬β¬β¬β¬β¬
Connect with me here:
– π Subscribe: https://www.youtube.com/channel/UCJOvQz55Ly-Rkr_ldE8pMEQ
– π YouTube : https://www.YouTube.com/@nilesh-gule/
– π GitHub: https://github.com/nileshgule
– π Twitter: https://twitter.com/nileshgule
– π Website: https://www.HandsOnArchitect.com/
– π LinkedIn : https://www.linkedin.com/in/nileshgule/