I'm simply looking for tips and ideas to make my system a little more professional.
The structure: The botting script is hosted on a VPS. There's a database hosted on yet another VPS. There's a webapp periodically hosted locally.
The botting script executes the analytics and trades and periodically updates the the database (MongoDB) with new values; performance metrics, positions and current statuses / errors.
The webapp connects to the MongoDB, pulls the latest data and displays it in a simple data-table along a few simple graphs (I've also added a simple feature that lets me pause the script for certain exchanges and accounts).
This is a pretty vague / ambigious question so it might get flagged for being too broad, but I'm looking for general suggestions for improving the system (I've been running it for almost two years and I'm simply looking for ways to improve it; not just for the sake of improving the performance, but also because I'd like to improve my skills and approach).
For starters, someone might suggest SQL over MongoDB (I'm not saving transaction data at the moment; this is because some of the exchanges I trade on lack sufficient API support for that - but I'm considering to begin as it will allow for better analytics at a later stage as I have more data.)
I'm also running the database and actual script on different servers, perhaps there's a way for me to simply run them together and thus improve performance a bit (right now I've structured it in such a way that the updating of the database values happens at a predictable interval and doesn't interrupt any of the cycles).
I'd be happy to answer any inquiries. Oh, I should note that I'm a mediocre programmer at best (mainly programming in Python).