What are the current problems with the remote SQL connections other than just latency?
I've heard before about the latency issue, but was wondering what the other problems that cause that may be.
Currently I have a website that is just about done that will allow the users from twitch to be able to trade the currency earned from streams, and use it to bid on other rewards via the website. The only problem there is being able to sync data between stream and website where somebody doesn't spend currency on one without it being withdrawn from the other. So storing the SQL database on the website entirely would be best. The only problem is finding a bot capable of doing so.