search

joaorb64 / TournamentStreamHelper

101 stars 38 forks source link

Idea: Move the local database to a proper database format #419

Closed Wolfy76700 closed 1 year ago

Wolfy76700 commented 1 year ago

Add a fully-featured database system to be able to quickly fetch and store data between teams, players, etc. It could be useful to also temporarily store runtime data such as players' tournament history in order to optimize the load on StartGG / Challonge.

We need to evaluate as well if the better option is to go for a SQL-like relational database or a MongoDB-like object-based database, depending on whether it can be stored in a local file and depending on our use case.

NB: Potential compatibility-breaking feature so we need to think about how we can transfer the current local database data to the new one easily to the new one

cash12121 commented 1 year ago

If we aren't looking to scale horizontally. We could use PocketBase. It creates an export of collections + tables so you could use that as a base template for people to download on their own machines.

Would probably have to alter something to launch the DB when the program is running.