koobas.hobune.stream
How to get update from database?
Hi! I'm making an educational game that's sort of like a quiz game but with tutorials. I'm using mySQL(online server) as my database and I'm gonna store the questions in there. Since the game is only offline:
1) How can I save the questions from the database to Unity so I don't have to connect to the internet to get the questions from the database?
2) If I add new questions to the database, how can I update it in Unity?
TIP: When building web games (or anything else really)... never.... ever... have the user access the database.
The database server should only be accessible through either an API server or directly through a Web Server.
Hello,
In the future I suggest if you have 2 questions, ask them separately.
None the less, I'm going to answer both your questions.
1) There are so many ways to save data in any application, and that is really dependent on your platform.
If you are building for desktop (or mobile), you can simply save (text) files or have all your data in the registry. Either way is good (however I prefer txt files XD)
If you are building for the Web. The only real way of doing it (The only way you should) is by creating cookies. However you could (please don't) create a plugin that does it as well.
2) As stated in my comment, you never directly access the database server (you shouldn't even be able to get it's IP)
I suggest making a Web Server that accesses the database server for all your questions. I then suggest, that ever time you add or change any data, a certain variable on the server gets changed. In the user data you also have this certain variable. Every time you want to update the client data, the client requests this variable from the server. Only if they do not match, does the client update.
As for the server, I suggest building it in either Python, Ruby or Node.js. If you are familiar with Unityscript, making a Node.js server shouldn't be too difficult :)
Now I would like to address your question. To be honest, this has been asked (and answered) before. You can probably get many answers through a simple google search and get the information you want.
In the future, I suggest asking more precise, less opinionated and more detailed question.
Hope this helps,
Benproductions1
@Benproductions1 Thank you very much for answering my question. :) I tried searching about this on Google but I was getting confused because I didn't know if I should make my game for online or offline play only but thanks to your answer I know what to use.
I never got to make text files for Unity but I want to see if that will work and also I'll just use $$anonymous$$ySQL, Xampp, and PHP$$anonymous$$yAd$$anonymous$$ for the main database.
Thank you very much again! :D
