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.

Sign up for GitHub

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

Jump to bottom

Database Ranking Tables, Materialized Views #4

Open
amosborne opened this issue Aug 18, 2021 · 0 comments
Open

Database Ranking Tables, Materialized Views #4

amosborne opened this issue Aug 18, 2021 · 0 comments
Assignees
@amosborne
Labels
database Related to database operations enhancement New feature or request

Comments

@amosborne
Copy link
Collaborator

Create PostgreSQL "materialized views" that are updated on a timed-basis to be displayed on a webpage as a table. According the the MLP specification, these views are generally:

  1. Skill Ranking Table
  2. Activity Ranking Table
  3. Most-Improved Ranking Table
  4. Handshake/Sportsmanship Ranking Table

Use the Hiku's World Ranking test database for generating these views. For now, skill ratings and handshakes can be generated randomly. Create a barebones Flask application to display these views on a webpage as a table.
@amosborne amosborne added enhancement New feature or request database Related to database operations labels Aug 18, 2021
@amosborne amosborne self-assigned this Aug 18, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@amosborne amosborne

Labels
database Related to database operations enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@amosborne