2021-01-13, 04:49 AM
1) It's not necessary to use MySQL. In a lot of cases it's not even the best solution. How you store the data depends on the data you are storing, how frequently it will be accessed and modified, and the required access to that data. For example, will this data need to be fetched, updated, or displayed from another source; like a forum or control panel?
All these questions should be evaluated. Player data is usually stored in a database for its speed on large data sets and overall flexibility. However if you want to store server configuration settings, that would be better suited in a configuration text file.
2) This also depends on the data. Something that will update frequently (kills, deaths, etc) should be stored in memory and written to the database later. Everything else (passwords, security questions, etc) should be updated immediately.
All these questions should be evaluated. Player data is usually stored in a database for its speed on large data sets and overall flexibility. However if you want to store server configuration settings, that would be better suited in a configuration text file.
2) This also depends on the data. Something that will update frequently (kills, deaths, etc) should be stored in memory and written to the database later. Everything else (passwords, security questions, etc) should be updated immediately.