How to manage a sports games player database?

Unity Engine
1

Hi,

Say you were creating a sports manager game and you would have to create a database of perhaps thousands of (football/hockey/baseball)players that all have randomly created names/stats etc. You would have to be able to update the stats of the players individually during the game to have the players develop.

How would you go about this if the target is to create an offline local game with C#.

Thanks in advance for any opinions!

2

Would take a data driven approach using SQL or json

3

This seems unnecessary to store in a database.
If they’re randomly generated, why not generate them at game start and only save the ones being used by the player(s)?

That said, if you need a database for offline use I’d use SQLite.

4

for using and modifying athletes data while playing, using a Dictionary could do a good enough job and wouldnt be too bad to code, i would probably use a SortedDictionary with an athlete’s name as key, and an int array of the athlete’s stats as value

1 Like