Alderon-Games / pot-community-servers

Bug Reporting and Wiki for Community Servers
16 stars 0 forks source link

Server data in SQL for servers with local database. #112

Open rodrigomacaubas opened 1 year ago

rodrigomacaubas commented 1 year ago

Study the possibility of including data storage in an SQL database.

Benefits: Servers would be more secure in handling data, performing backup routines and configuring audit logs. In applications that run in real time, SQL manages to avoid overwriting changes, that is, not allowing two changes to be made at the same time or not editing information if the server is reading at the time of the change.

Very unusual but reported, some servers have been saying that after updates some databases got damaged. At the moment, there are no further details about the problem, but SQL storage would facilitate data recovery after a disaster.

sasbrasil commented 1 year ago

sounds good about this ;)