ctf-gameserver icon indicating copy to clipboard operation
ctf-gameserver copied to clipboard

Controller: Make scoring more maintainable

Open F30 opened this issue 7 years ago • 0 comments

Doing scoring thorugh a Materialized View is nice from a DB point of view, however it causes some problems in practice:

  • Nobody besides @siccegge really understands the SQL, let alone is able to change it
  • Django doesn't know of Materialized Views, so it has to be deployed separately after initial database creation
  • The View's current schema is not optimized for rendering the scoreboard HTML, that still requires some processing in Python (see scores() in "calculations.py")

I want something more maintainable, probably more Python instead of SQL.

F30 avatar Jun 15 '18 15:06 F30