Okay guys second decision time for the feature team. This regards the way the application will be used. Please choose between the following two options:
1. Client Server System
Client-server system. Server will contain the database and all official statistics, player information. Clients will be Windows applications. Anyone can download a client and use the rosters to simulate matches. The simulation algorithms and such will all be stored locally in the client itself. Official tournaments will upload statistics/results back to the main server. Tournament simmers will have to authenticate into the server to activate that functionality. Anyone using the client for fun can have the option of outputting statistics to a local database.
Pros
- Anyone can run simulations
- Centralized database means that if there are multiple simmers, they will not have to email files around
- Software can be distributed to other sites (they would not be able to authenticate into the DB, hopefully!)
Cons
- Simmer would need to be connected to the internet
- Database would have to be available on demand (probably having PC host it would be good)
Other Information
Database: MySQL on server, SQLite for local database
2. Current System
Each simmer would have an executable and a local database. This database would contain information about all players/tournaments/etc. There will hence be no centralized database and each simmer would be forking off their own simulation environment. This is basically option 1 without authentication.
Pros
- Can simulate without internet connection
Cons
- Multiple simmers would have to email the database file around a lot
- Would require extra work on the part of simmers to make stats available to everyone
Other Information
Database: SQLite
--------------
I personally prefer Option 1.