Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Docker image with PostgreSQL database pre-populated with ATP tennis data #337

Open
mcekovic opened this issue Jan 6, 2020 · 2 comments
Open

Comments

@mcekovic
Copy link
Owner

@mcekovic mcekovic commented Jan 6, 2020

Docker image mcekovic/uts-database with PostgreSQL database pre-populated with ATP tennis data as of season 2020:

  • Install Docker
  • Ensure PostgreSQL port 5432 is NOT open on your machine (i.e. PostgreSQL is not running if eventually installed)
  • Run UTS database Docker image in a container:
    docker run -p 5432:5432 -d --name uts-database mcekovic/uts-database
    (this will take a while to download the image with data)
  • Enter PostgreSQL client command line tool:
    docker exec -it uts-database psql -U tcb
  • Execute SQL commands, like:
    SELECT goat_rank, name, country_id, goat_points FROM player_v ORDER BY goat_points DESC NULLS LAST LIMIT 20;
  • Next time you want Docker container with UTS database running type:
    docker start uts-database
  • If you want Docker container with UTS database to autostart when you start Docker Desktop/Daemon, add --restart always to the docker run ... command above
  • To refer to the UTS database Docker images created at the end of particular season use image URLs with following tags:
    • mcekovic/uts-database:asof2020
    • mcekovic/uts-database:asof2019
@mcekovic
Copy link
Owner Author

@mcekovic mcekovic commented Jan 6, 2020

UTS

Repository owner deleted a comment from tomeydemarcos Feb 3, 2021
@mcekovic
Copy link
Owner Author

@mcekovic mcekovic commented Feb 6, 2021

Refreshed with 2020 data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant