Two questions here.
I’m looking for the best way to store logs. My current project is developing something for an add-on Grand Theft Auto and I wish to log user actions, like in game transactions, player chat etc. What’s the best method of storing these logs that can later be accessed easily? I’m currently using Mysql to store the game data. There’s potential for the logs to get large as we may need to store for a long time.
The project is running on a dedicated server, I am creating a WPF application for higher administrators to access the database to view stats and edit certain items. Is there a way to allow the console application and the WPF application to communicate so I can preform things remotely?