What data format for a quiz game with nearly 10,000 questions?

Member
Posts: 353
Joined: 2002.04
Post: #1
Hey everybody,

Looks like I'm going to be busy over the holidays with some client work. Specifically I'm in the planning stages of a quiz game which has a potential database of nearly 10,000 questions.

The app is going to need to come with all the questions included, no loading from a web source will be possible. The client will be providing me with Excel files.

So my questions is, what format do you think I should store the data in? This is both a question for how I will read the data in the app, and also how I will convert the data from the supplied excel files into the format I need.

Thanks for any advice!
Quote this message in a reply
⌘-R in Chief
Posts: 1,256
Joined: 2002.05
Post: #2
An SQLite database would definitely work. Open Excel and export to CSV. You can then suck that in and massage into the format you want.
Quote this message in a reply
Member
Posts: 353
Joined: 2002.04
Post: #3
Thanks Seth. I was thinking SQLite might be what I should be researching but didn't want to start if it was the wrong thing. So that clarification helps a lot - cheers! Smile
Quote this message in a reply
Post Reply 

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Questions Using Source Code and Drag & Drop Game Makers Thunder_Strike 2 1,921 Jul 12, 2013 07:59 AM
Last Post: Thunder_Strike
  Basic Questions for a Word Game avidgamer101 4 4,632 May 19, 2012 07:26 PM
Last Post: MattDiamond
  [LIVE DATA] from my featured game fugufish 5 4,081 Dec 15, 2011 11:35 AM
Last Post: fugufish
  A few initial questions about my first game (2D) marcosscriven 2 3,277 Jul 6, 2009 06:15 AM
Last Post: marcosscriven
  Game Programming Questions miigman 11 6,807 May 21, 2009 11:24 AM
Last Post: MikeD