I’m working on a multiplayer mobile game. I want the game to be able to query a server database and get information like player high scores. I’ve seen guides where they use sqlite to save and modify a local database, I can’t find any good guides on setting something like this up over the internet.
Does anyone know of any good guides or have some examples I can look at?
If you are just looking at highscores you could use a 3rd party service such as PlayFab. There are a few around. They tend to use a restful API but often have C# libraries for you to use.
You could make your own web API running on your own website. Take a look at Restful API’s. Your website accesses the database and requests are made to your API. These calls will add values to your database or return a current list of highscores etc
For security reasons you don’t want to make your database completely open to the web (e.g using a connection string). You want to secure it behind an API so that only data that you expose via the API can be accessed/changed etc.