geokids/geokids-db repository overview

⁠GeoKids PostgreSQL database

This is the database repository for the GeoKids app.

⁠Intructions

⁠How to download the image

This is an example on how to pull this image from GeoKids database repository:

docker pull geokids/geokids-db:1.0

⁠How to create the container

This is an example on how to use this docker image:

docker container run \
    --name geokids-db \
    --hostname geokids-db \
    --publish 5432:5432 \
    --detach geokids/geokids-db:1.0

⁠GeoKids database objects

⁠Tables

• continents
• regions
• countries

⁠Views

• List of continents
• List of regions
• List of regions by continent
• List of countries
• List of countries by continent
• List of countries by region
• List of countries by continent and region
• List of countries by continent and region including country code

⁠PostgreSQL authentication

This image was created based on PostgreSQL official [docker image] (https://hub.docker.com/_/postgres⁠) with a slight modifications. Here you have the environment values used:

    --env POSTGRES_USER=geokids
    --env 'POSTGRES_PASSWORD=CmdL1n3-r0ck5'

Therefore to connect you must use the geokids user and CmdL1n3-r0ck5 password. This user is also the owner of the GeoKids database.

⁠Questions?

If you have questions or comments about this demo, don't hesitate to contact me at [email protected]⁠

⁠Follow me