- Home /
quiz game how to store questions
Hi all, I'm making a quiz game. I have a problem that how to store questions. If I have 7000 questions , where can I store? use excel? or json ? or MySQL ? I don't know the right way , where do I start?
Answer by IronBytes · Jul 25, 2019 at 05:37 AM
Hello Mojaja, foremost should be said you can store them however you want. I would not suggest sql as I think it's overkill for this task. JSON and Excel both are fine. Alternatively you can look into ScriptableObjects and store each question as its own scriptable object or you can just have them in a text file each question on its own line (similar to excel).
I would suggest you to use the method that you are most comfortable with and with which you are able to work fastest.
Hi @IronBytes ,If I already prepare the questions and answers, do I use Excel better than JSON?
From the perspective of your game it doesn't matter how you store it, but excel could provide a better overview of the questions for humans than JSON does.
In both cases you need to write code to import the questions and answers into your project. For JSON this is really simple, in Excel I have no experience but it shouldn't be hard to do either. Once that code is written you won't have to touch it again, so I would pick wherever you can keep a good overview of your questions the easiest.
I follow the tutorial with Unity. link text
But, I think it too slow to add the questions . So,I'm looking for the better way to add and change.
Answer by game-dev333 · Jul 26, 2019 at 04:42 AM
There are many ways to do it. you can store it in JSON or scriptable object (scriptable object is advised ). The best way would be store a small amount of data in scriptable object and retrieve rest from remote values. In that way you can always change/modify questions.
Your answer
Follow this Question
Related Questions
Quiz game with images 0 Answers
[Closed] Place to store user data 1 Answer
Make quiz game Confused About PlayerPrefs and database 1 Answer