Notes taken by Abd @ITNA Digital
🔗 Link to the video
pgAdmin, Postgres, docker network
Table of Contents
A sample SQL statement to see what we have.
SELECT max(tpep_pickup_datetime), min(tpep_pickup_datetime), max(total_amount) FROM yellow_taxi_data;
pgCLI allows for quickly looking into data. But the more convenient way to work with a postgres database is to use the pgAdmin tool which is a web based GUI tool.
Rather than installing pgAdmin directly we can use docker to install pgAdmin container.
To pull the docker image:
to run the container:
docker run -it \\\\ -e PGADMIN_DEFAULT_EMAIL="firstname.lastname@example.org" \\\\ -e PGADMIN_DEFAULT_PASSWORD="root" \\\\ -p 8080:80 \\\\ dpage/pgadmin4
We will be making the requests we will be sending will be to port 8080, which will forwarded to port 80 of the container.