geokids/geokids-sql-db repository overview

⁠GeoKids SQL Server 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-sql-db:1.0

⁠How to create the container

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

⁠Version 1.0

docker container run \
    --name geokids-db \
    --hostname geokids-db \
    --publish 1401:1433 \
    --detach geokids/geokids-sql-db:1.0

⁠Version 2.0

docker container run \
    --name geokids-db \
    --hostname geokids-db \
    --publish 1401:1433 \
    --detach geokids/geokids-sql-db:2.0

⁠GeoKids database objects

⁠Tables

• continents
• regions
• countries

⁠Views - Introduced in Version 2.0

• 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

⁠SQL Server authentication

This image was created based on SQL Server official [docker image] (https://hub.docker.com/_/microsoft-mssql-server⁠) with a slight modifications. Here you have the environment value for the SA password:

    --env 'MSSQL_SA_PASSWORD=_SqLr0ck5_' 

Therefore to connect you must use the geokids SQL login 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