I'm designing an american football management sim, it's going to be free and open-source (working title: Free Football Sim). It will be coded in java (of course
). I need a big time data storage solution for all the stats and ratings that i'm going to be tracking (think scalability; 100 years of statistical information about thousands of players who have been on any of up to 40 teams). I know some SQL, so mySQL has popped into my mind as a very desirable tool.
Is there a way that i can set up a mySQL database using my game's installer that won't have to run all the time? Perhaps a database with a small footprint that i can start up when i start the game and close when i close the game?
Any help would be much appreciated.