mazziechai / DonguriGaeru

A Puyo Puyo ranking system
GNU Affero General Public License v3.0
4 stars 0 forks source link

Database Ranking Tables, Materialized Views #4

Open amosborne opened 3 years ago

amosborne commented 3 years ago

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.