Dealing with a lot of data in a mobile game - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Programming
Click Here to Login
Reply
 
Thread Tools Display Modes
 
Old 05-17-2017, 02:39 PM   #1 (permalink)
Super Techie
 
danhodge's Avatar
 
Join Date: Aug 2012
Location: UK
Posts: 269
Send a message via Skype™ to danhodge
Default Dealing with a lot of data in a mobile game

Hey! So i'm planning on developing a mobile game soon, which is a quiz game basically, and i was wondering what standard protocol is in storing the questions/answers.
For example, i know how to program this using text files, but i'm assuming that that's an archaic way if doing things. For reference, i'll be using Unity to do this.
Thanks for any help,
Danny
__________________

danhodge is offline   Reply With Quote
Old 05-17-2017, 04:22 PM   #2 (permalink)
Private Joker
 
carnageX's Avatar
 
Join Date: Feb 2007
Location: South Dakota
Posts: 24,388
Default Re: Dealing with a lot of data in a mobile game

Quote:
Originally Posted by danhodge View Post
Hey! So i'm planning on developing a mobile game soon, which is a quiz game basically, and i was wondering what standard protocol is in storing the questions/answers.
For example, i know how to program this using text files, but i'm assuming that that's an archaic way if doing things. For reference, i'll be using Unity to do this.
Thanks for any help,
Danny
SqLite in storing the questions locally if you want to do it that way (for Android anyway - not sure how Apple stores local data).

You could make it expandable by using web services that connected to a server and download new questions, either automatically or when the user taps an "Update" button. You can also deploy the new questions incrementally through whatever app store you're using usually, as part of an update (so that the "GetNewQuestions" API wouldn't be super huge).
__________________

__________________
Laptop: MSI GT70 2OC-059us | i7-4700MQ | 16GB | GTX 770m | 500GB SSD / 750GB HDD | 17.3" | Win10 Pro
Desktop: 4690k | 12GB g.Skill RipJaws | GTX 970 | 520hx | Z87X-UD4H | Corsair Vengeance C70 | Corsair H110 | Acer 25" | Acer 22" | Win10
Mobile: Samsung Galaxy Note 5


If I help you, or you just like what I said, rep me by clicking the under my post
carnageX is offline   Reply With Quote
Old 05-17-2017, 04:34 PM   #3 (permalink)
Super Techie
 
danhodge's Avatar
 
Join Date: Aug 2012
Location: UK
Posts: 269
Send a message via Skype™ to danhodge
Default Re: Dealing with a lot of data in a mobile game

So if i did it locally, would that require a significant amount of SQL, or not too much?
And is there a disadvantage to doing it that way? If its simpler, i'd rather do that for my first release. Dipping my toe in, as they say
Thanks for the help!
__________________
Interested in programming, AI, game development, and robotics.
Talented in none of the above.
danhodge is offline   Reply With Quote
Old 05-17-2017, 08:31 PM   #4 (permalink)
Private Joker
 
carnageX's Avatar
 
Join Date: Feb 2007
Location: South Dakota
Posts: 24,388
Default Re: Dealing with a lot of data in a mobile game

What do you mean by "a significant amount of SQL" ?

Do you mean actual SQL queries? Kind of - but SQLite is a very simplified implementation of SQL. Usually you'd just be doing INSERT, SELECT, and maybe DELETE if need be, especially if all you're doing is storing quiz questions & answers. Can get away with having just a couple tables (a Questions table and a Responses table, tied by a Question ID or something like that).
__________________
Laptop: MSI GT70 2OC-059us | i7-4700MQ | 16GB | GTX 770m | 500GB SSD / 750GB HDD | 17.3" | Win10 Pro
Desktop: 4690k | 12GB g.Skill RipJaws | GTX 970 | 520hx | Z87X-UD4H | Corsair Vengeance C70 | Corsair H110 | Acer 25" | Acer 22" | Win10
Mobile: Samsung Galaxy Note 5


If I help you, or you just like what I said, rep me by clicking the under my post
carnageX is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I cut a lot of holes and soon shall have a lot of fans... take a look aspire Overclocking and Modding 32 10-05-2005 08:29 PM


Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities


Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 02:40 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.