How to have "highscores" and "top-results"
Because how matrix.org spec is done, it does not seem possible to filter the events based on the keys we stored.
In order to be able to "dig in the events of a room", and fetch the one (for example):
- for a specific game
- with the highest score
- from a specific player
we would need some sort of system.
Maybe:
- matrix bot, https://github.com/matrix-org/matrix-hookshot, https://plugins.maubot.xyz/ etc.
- maybe a matrix "app service" https://spec.matrix.org/v1.7/application-service-api/
Somehow we could either (research):
- republish/edit and event with the highest score, inside the room (if that works), or an other (public read only) room (if that works too)
- maintain a sql(ite) db somewhere else
- have a dedicated api endpoint for all that logic
Objectives:
- be able to use matrix as a db
- involve a backend/function/server as little as possible
- keep having a platform agnostic, serverless platform with games and peer connections
Todo:
- think and research