Starting to map out a server for a game that will communicate with a MySQL database to store all the data.
So the questions:
1. How will the code actually look? Is it best to fetch values from MySQL database, calculate and then set the new value and then repeat or is it best to just save the entire "cache" into the database from time to time?
2. How do i best plan all the classes and then create them in MySQL? I saw some software that can create code from UML maps and were thinking if there was some easy way to do the same in MySQL.
3.Do you have any other general tips? I've never done anything in a database before but I think they look great and seem neat.